1 PACKAGE HZ_IMP_LOAD_FINREPORTS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLFNRS.pls 120.1 2005/10/30 04:45:43 appldev noship $*/
3
4
5 --TYPE finreport_cursor_type IS REF CURSOR;
6 TYPE insert_cursor_type IS REF CURSOR;
7 TYPE update_cursor_type IS REF CURSOR;
8 TYPE error_cursor_type IS REF CURSOR;
9 TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
10
11 TYPE PARENT_PARTY_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
12 TYPE FR_ID IS TABLE OF HZ_IMP_FINREPORTS_SG.FINANCIAL_REPORT_ID%TYPE;
13 TYPE PARTY_ID IS TABLE OF HZ_IMP_FINREPORTS_SG.PARTY_ID%TYPE;
14 TYPE AUDIT_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.AUDIT_IND%TYPE;
15 TYPE CONSOLIDATED_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.CONSOLIDATED_IND%TYPE;
16 TYPE DATE_REPORT_ISSUED IS TABLE OF HZ_IMP_FINREPORTS_INT.DATE_REPORT_ISSUED%TYPE;
17 TYPE DOCUMENT_REFERENCE IS TABLE OF HZ_IMP_FINREPORTS_INT.DOCUMENT_REFERENCE%TYPE;
18 TYPE ESTIMATED_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.ESTIMATED_IND%TYPE;
19 TYPE FINAL_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.FINAL_IND%TYPE;
20 TYPE FISCAL_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.FISCAL_IND%TYPE;
21 TYPE FORECAST_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.FORECAST_IND%TYPE;
22 TYPE ISSUED_PERIOD IS TABLE OF HZ_IMP_FINREPORTS_INT.ISSUED_PERIOD%TYPE;
23 TYPE OPENING_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.OPENING_IND%TYPE;
24 TYPE PROFORMA_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.PROFORMA_IND%TYPE;
25 TYPE QUALIFIED_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.QUALIFIED_IND%TYPE;
26 TYPE REPORT_END_DATE IS TABLE OF HZ_IMP_FINREPORTS_INT.REPORT_END_DATE%TYPE;
27 TYPE REPORT_START_DATE IS TABLE OF HZ_IMP_FINREPORTS_INT.REPORT_START_DATE%TYPE;
28 TYPE REQUIRING_AUTHORITY IS TABLE OF HZ_IMP_FINREPORTS_INT.REQUIRING_AUTHORITY%TYPE;
29 TYPE RESTATED_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.RESTATED_IND%TYPE;
30 TYPE SIGNED_BY_PRINCIPALS_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.SIGNED_BY_PRINCIPALS_IND%TYPE;
31 TYPE TRIAL_BALANCE_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.TRIAL_BALANCE_IND%TYPE;
32 TYPE TYPE_OF_FINANCIAL_REPORT IS TABLE OF HZ_IMP_FINREPORTS_INT.TYPE_OF_FINANCIAL_REPORT%TYPE;
33 TYPE UNBALANCED_IND IS TABLE OF HZ_IMP_FINREPORTS_INT.UNBALANCED_IND%TYPE;
34 TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_FINREPORTS_INT.CREATED_BY_MODULE%TYPE;
35
36 TYPE ACTION_FLAG IS TABLE OF HZ_IMP_FINREPORTS_SG.ACTION_FLAG%TYPE;
37 TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
38 TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
39 TYPE ERROR_ID IS TABLE OF HZ_IMP_ADDRESSES_INT.ERROR_ID%TYPE;
40 TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
41 TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_VALUE%TYPE;
42 TYPE ERROR_MESSAGE_TOKEN_NAME IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
43
44 TYPE ERROR_REC_TABLE IS TABLE OF hz_imp_tmp_errors%ROWTYPE;
45
46 PROCEDURE load_finreports (
47 P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2 );
51
52
53 END HZ_IMP_LOAD_FINREPORTS_PKG;