DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on HZ_IMP_CONTACTROLES_INT

Line 4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;

1: PACKAGE HZ_IMP_LOAD_CONTACT_ROLE_PKG AUTHID CURRENT_USER AS
2: /*$Header: ARHLOCRS.pls 120.6 2005/10/30 03:53:00 appldev noship $*/
3: /* ARHLOCRS.pls */
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;
5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;

Line 5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;

1: PACKAGE HZ_IMP_LOAD_CONTACT_ROLE_PKG AUTHID CURRENT_USER AS
2: /*$Header: ARHLOCRS.pls 120.6 2005/10/30 03:53:00 appldev noship $*/
3: /* ARHLOCRS.pls */
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;
5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;

Line 6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;

2: /*$Header: ARHLOCRS.pls 120.6 2005/10/30 03:53:00 appldev noship $*/
3: /* ARHLOCRS.pls */
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;
5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;
10: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;

Line 7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;

3: /* ARHLOCRS.pls */
4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;
5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;
10: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;
11: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;

Line 8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;

4: TYPE BATCH_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.BATCH_ID%TYPE;
5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;
10: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;
11: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;
12: TYPE ORG_CONTACT_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ID%TYPE;

Line 9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;

5: TYPE CONT_ORIG_SYSTEM IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM%TYPE;
6: TYPE CONT_ORIG_SYSTEM_REFERENCE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CONTACT_ORIG_SYSTEM_REFERENCE%TYPE;
7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;
10: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;
11: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;
12: TYPE ORG_CONTACT_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ID%TYPE;
13: TYPE ORG_CONTACT_ROLE_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ROLE_ID%TYPE;

Line 11: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;

7: TYPE INSERT_UPDATE_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_INT.INSERT_UPDATE_FLAG%TYPE;
8: TYPE ROLE_TYPE IS TABLE OF HZ_IMP_CONTACTROLES_INT.ROLE_TYPE%TYPE;
9: TYPE INTERFACE_STATUS IS TABLE OF HZ_IMP_CONTACTROLES_INT.INTERFACE_STATUS%TYPE;
10: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;
11: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;
12: TYPE ORG_CONTACT_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ID%TYPE;
13: TYPE ORG_CONTACT_ROLE_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ROLE_ID%TYPE;
14: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CREATED_BY_MODULE%TYPE;
15:

Line 14: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CREATED_BY_MODULE%TYPE;

10: TYPE ACTION_FLAG IS TABLE OF HZ_IMP_CONTACTROLES_SG.ACTION_FLAG%TYPE;
11: TYPE ERROR_ID IS TABLE OF HZ_IMP_CONTACTROLES_INT.ERROR_ID%TYPE;
12: TYPE ORG_CONTACT_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ID%TYPE;
13: TYPE ORG_CONTACT_ROLE_ID IS TABLE OF HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ROLE_ID%TYPE;
14: TYPE CREATED_BY_MODULE IS TABLE OF HZ_IMP_CONTACTROLES_INT.CREATED_BY_MODULE%TYPE;
15:
16: TYPE ERROR_MESSAGE_NAME IS TABLE OF HZ_IMP_ERRORS.MESSAGE_NAME%TYPE;
17: TYPE ERROR_MESSAGE_TOKEN IS TABLE OF HZ_IMP_ERRORS.TOKEN1_NAME%TYPE;
18: TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;