APPS.HZ_ORG_CONTACT_ROLES_PKG dependencies on HZ_UTILITY_V2PUB

Line 50: HZ_UTILITY_V2PUB.CREATED_BY,

46: VALUES (
47: DECODE( X_ORG_CONTACT_ROLE_ID, FND_API.G_MISS_NUM, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, NULL, HZ_ORG_CONTACT_ROLES_S.NEXTVAL, X_ORG_CONTACT_ROLE_ID ),
48: DECODE( X_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, X_ORG_CONTACT_ID ),
49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

Line 53: HZ_UTILITY_V2PUB.CREATION_DATE,

49: DECODE( X_ROLE_TYPE, FND_API.G_MISS_CHAR, NULL, X_ROLE_TYPE ),
50: HZ_UTILITY_V2PUB.CREATED_BY,
51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

51: DECODE( X_ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_ROLE_LEVEL ),
52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

52: DECODE( X_PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_FLAG ),
53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

53: HZ_UTILITY_V2PUB.CREATION_DATE,
54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 58: HZ_UTILITY_V2PUB.REQUEST_ID,

54: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ROLE_ID,HZ_ORG_CONTACT_ROLES_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),

Line 59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

55: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 60: HZ_UTILITY_V2PUB.PROGRAM_ID,

56: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

57: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
58: HZ_UTILITY_V2PUB.REQUEST_ID,
59: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
60: HZ_UTILITY_V2PUB.PROGRAM_ID,
61: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
62: DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
63: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
64: DECODE( X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
65: DECODE( X_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

129: ROLE_LEVEL = DECODE( X_ROLE_LEVEL, NULL, ROLE_LEVEL, FND_API.G_MISS_CHAR, 'N', X_ROLE_LEVEL ),
130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
131: CREATION_DATE = CREATION_DATE,
132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

130: PRIMARY_FLAG = DECODE( X_PRIMARY_FLAG, NULL, PRIMARY_FLAG, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_FLAG ),
131: CREATION_DATE = CREATION_DATE,
132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

131: CREATION_DATE = CREATION_DATE,
132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

132: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),

Line 137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

133: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

Line 138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

134: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

135: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
136: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
137: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
138: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
139: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
140: PRIMARY_CONTACT_PER_ROLE_TYPE = DECODE( X_PRIMARY_CON_PER_ROLE_TYPE, NULL, PRIMARY_CONTACT_PER_ROLE_TYPE, FND_API.G_MISS_CHAR, 'N', X_PRIMARY_CON_PER_ROLE_TYPE ),
141: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),
142: OBJECT_VERSION_NUMBER = DECODE( X_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
143: CREATED_BY_MODULE = DECODE( X_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),