DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_CONTACT_POINTS

Line 36: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

32: TYPE STATE IS TABLE OF HZ_LOCATIONS.STATE%TYPE;
33: TYPE CREATED_BY_MODULE IS TABLE OF HZ_LOCATIONS.CREATED_BY_MODULE%TYPE;
34: TYPE PARTY_NUMBER IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;
35:
36: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

Line 37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;

33: TYPE CREATED_BY_MODULE IS TABLE OF HZ_LOCATIONS.CREATED_BY_MODULE%TYPE;
34: TYPE PARTY_NUMBER IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;
35:
36: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;

Line 38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;

34: TYPE PARTY_NUMBER IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;
35:
36: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;

Line 39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

35:
36: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;

Line 40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;

36: TYPE CONTACT_POINT_ID IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;

Line 41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;

37: TYPE RAW_PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%TYPE;
38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;

Line 42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;

38: TYPE COUNTRY_CODE IS TABLE OF HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;

Line 43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;

39: TYPE PHONE_AREA_CODE IS TABLE OF HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;

Line 44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;

40: TYPE PHONE_NUMBER IS TABLE OF HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;
48: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;

Line 45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;

41: TYPE OWNER_TABLE_NAME IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_NAME%TYPE;
42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;
48: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
49:

Line 46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;

42: TYPE OWNER_TABLE_ID IS TABLE OF HZ_CONTACT_POINTS.OWNER_TABLE_ID%TYPE;
43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;
48: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
49:
50: TYPE TITLE IS TABLE OF HZ_ORG_CONTACTS.TITLE%TYPE;

Line 47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;

43: TYPE PRIMARY_FLAG IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_FLAG%TYPE;
44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;
48: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
49:
50: TYPE TITLE IS TABLE OF HZ_ORG_CONTACTS.TITLE%TYPE;
51:

Line 48: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;

44: TYPE PRIMARY_BY_PURPOSE IS TABLE OF HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%TYPE;
45: TYPE PHONE_LINE_TYPE IS TABLE OF HZ_CONTACT_POINTS.PHONE_LINE_TYPE%TYPE;
46: TYPE PHONE_EXTENSION IS TABLE OF HZ_CONTACT_POINTS.PHONE_EXTENSION%TYPE;
47: TYPE ACTUAL_CONTENT_SOURCE IS TABLE OF HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%TYPE;
48: TYPE CONTACT_POINT_TYPE IS TABLE OF HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%TYPE;
49:
50: TYPE TITLE IS TABLE OF HZ_ORG_CONTACTS.TITLE%TYPE;
51:
52: TYPE RELATIONSHIP_ID IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;