1 PACKAGE HZ_IMP_LOAD_FINNUMBERS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLFNNS.pls 120.1 2005/10/30 04:45:41 appldev noship $*/
3
4 TYPE insert_cursor_type IS REF CURSOR;
5 TYPE update_cursor_type IS REF CURSOR;
6 TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
7 TYPE FN_ID IS TABLE OF HZ_IMP_FINNUMBERS_SG.FINANCIAL_NUMBER_ID%TYPE;
8 TYPE FR_ID IS TABLE OF HZ_IMP_FINNUMBERS_SG.FINANCIAL_REPORT_ID%TYPE;
9 TYPE TCA_FR_ID IS TABLE OF HZ_FINANCIAL_REPORTS.FINANCIAL_REPORT_ID%TYPE;
10
11 TYPE FINANCIAL_NUMBER IS TABLE OF HZ_IMP_FINNUMBERS_INT.FINANCIAL_NUMBER%TYPE;
12 TYPE FINANCIAL_NUMBER_NAME IS TABLE OF HZ_IMP_FINNUMBERS_INT.FINANCIAL_NUMBER_NAME%TYPE;
13 TYPE FINANCIAL_NUMBER_CURRENCY IS TABLE OF HZ_IMP_FINNUMBERS_INT.FINANCIAL_NUMBER_CURRENCY%TYPE;
14 TYPE PROJECTED_ACTUAL_FLAG IS TABLE OF HZ_IMP_FINNUMBERS_INT.PROJECTED_ACTUAL_FLAG%TYPE;
15 TYPE FINANCIAL_UNITS_APPLIED IS TABLE OF HZ_IMP_FINNUMBERS_INT.FINANCIAL_UNITS_APPLIED%TYPE;
16 TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_FINNUMBERS_INT.CREATED_BY_MODULE%TYPE;
17 TYPE ACTION_FLAG IS TABLE OF HZ_IMP_FINNUMBERS_SG.ACTION_FLAG%TYPE;
18
19 TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
20 TYPE LOOKUP_ERROR IS TABLE OF ar_lookups.lookup_code%TYPE;
21 TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
22 TYPE ERROR_ID IS TABLE OF HZ_IMP_FINNUMBERS_INT.ERROR_ID%TYPE;
23 TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
24 TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
25 TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
26
27 PROCEDURE load_finnumbers (
28 P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2 );
32
33
34 END HZ_IMP_LOAD_FINNUMBERS_PKG;