DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CREDITRATINGS_PKG dependencies on HZ_IMP_CREDITRTNGS_SG

Line 7: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CREDITRTNGS_SG.ACTION_FLAG%TYPE;

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); -- isn't row id about 60 chars?
7: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CREDITRTNGS_SG.ACTION_FLAG%TYPE;
8: TYPE AVG_HIGH_CREDIT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.AVG_HIGH_CREDIT%TYPE;
9: TYPE BANKRUPTCY_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.BANKRUPTCY_IND%TYPE;
10: TYPE BUSINESS_DISCONTINUED IS TABLE OF HZ_IMP_CREDITRTNGS_INT.BUSINESS_DISCONTINUED%TYPE;
11: TYPE CLAIMS_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CLAIMS_IND%TYPE;

Line 14: TYPE CREDIT_RATING_ID IS TABLE OF HZ_IMP_CREDITRTNGS_SG.CREDIT_RATING_ID%TYPE;

10: TYPE BUSINESS_DISCONTINUED IS TABLE OF HZ_IMP_CREDITRTNGS_INT.BUSINESS_DISCONTINUED%TYPE;
11: TYPE CLAIMS_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CLAIMS_IND%TYPE;
12: TYPE COMMENTS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.COMMENTS%TYPE;
13: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREATED_BY_MODULE%TYPE;
14: TYPE CREDIT_RATING_ID IS TABLE OF HZ_IMP_CREDITRTNGS_SG.CREDIT_RATING_ID%TYPE;
15: TYPE CREDIT_SCORE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE%TYPE;
16: TYPE CREDIT_SCORE_AGE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_AGE%TYPE;
17: TYPE CREDIT_SCORE_CLASS IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_CLASS%TYPE;
18: TYPE CREDIT_SCORE_COMMENTARY IS TABLE OF HZ_IMP_CREDITRTNGS_INT.CREDIT_SCORE_COMMENTARY%TYPE;

Line 81: TYPE PARTY_ID IS TABLE OF HZ_IMP_CREDITRTNGS_SG.PARTY_ID%TYPE;

77: TYPE NUM_TRADE_EXPERIENCES IS TABLE OF HZ_IMP_CREDITRTNGS_INT.NUM_TRADE_EXPERIENCES%TYPE;
78: TYPE OPRG_SPEC_EVNT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.OPRG_SPEC_EVNT_IND%TYPE;
79: TYPE OTHER_SPEC_EVNT_IND IS TABLE OF HZ_IMP_CREDITRTNGS_INT.OTHER_SPEC_EVNT_IND%TYPE;
80: TYPE PARENT_PARTY_ID IS TABLE OF HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID%TYPE;
81: TYPE PARTY_ID IS TABLE OF HZ_IMP_CREDITRTNGS_SG.PARTY_ID%TYPE;
82: TYPE PARTY_ORIG_SYSTEM IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PARTY_ORIG_SYSTEM%TYPE;
83: TYPE PARTY_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PARTY_ORIG_SYSTEM_REFERENCE%TYPE;
84: TYPE PAYDEX_COMMENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_COMMENT%TYPE;
85: TYPE PAYDEX_FIRM_COMMENT IS TABLE OF HZ_IMP_CREDITRTNGS_INT.PAYDEX_FIRM_COMMENT%TYPE;