This GL Daily rate interface program code supports oracle database 8.

Dear Experts,
We are using oracle database 8,we are preparing some codes on Daily conversation rates interface program.

please find the below mentioned code.

GL Daily Rates Interface

LOAD DATA
INFILE 'Give your data file path in .dat or .txt file’
TRUNCATE INTO TABLE XTG_GL_DAILY_RATES_STG
FIELDS TERMINATED BY','
OPTIONALLY ENCLOSED BY'"'
TRAILING NULLCOLS
(
FROM_CURRENCY
,TO_CURRENCY
,FROM_CONVERSION_DATE
,TO_CONVERSION_DATE
,USER_CONVERSION_TYPE
,CONVERSION_RATE
,MODE_FLAG
--,INVERSE_CONVERSION_RATE
--,USER_ID
)

CREATE OR REPLACE PACKAGE GL_DAILY_PKG
AS
PROCEDURE GL_DAILY_TBL (ERRBUF OUT VARCHAR2,
                                       RETCODE OUT VARCHAR2);