DBA Data[Home] [Help]

APPS.HZ_ORG_CONTACTS_PKG dependencies on HZ_UTILITY_V2PUB

Line 120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

116: DECODE( X_DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_DECISION_MAKER_FLAG ),
117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

117: DECODE( X_JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,

Line 122: HZ_UTILITY_V2PUB.CREATION_DATE,

118: DECODE( X_REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, 'N', NULL, 'N', X_REFERENCE_USE_FLAG ),
119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 123: HZ_UTILITY_V2PUB.CREATED_BY,

119: DECODE( X_RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,

Line 124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

120: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 125: HZ_UTILITY_V2PUB.REQUEST_ID,

121: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),

Line 126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

122: HZ_UTILITY_V2PUB.CREATION_DATE,
123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 127: HZ_UTILITY_V2PUB.PROGRAM_ID,

123: HZ_UTILITY_V2PUB.CREATED_BY,
124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

124: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
125: HZ_UTILITY_V2PUB.REQUEST_ID,
126: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
127: HZ_UTILITY_V2PUB.PROGRAM_ID,
128: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
129: DECODE( X_ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), NULL, TO_CHAR(NVL(X_ORG_CONTACT_ID,HZ_ORG_CONTACTS_S.CURRVAL)), X_ORIG_SYSTEM_REFERENCE ),
130: DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
131: DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
132: DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),

Line 261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

257: DECISION_MAKER_FLAG = DECODE( X_DECISION_MAKER_FLAG, NULL, DECISION_MAKER_FLAG, FND_API.G_MISS_CHAR, 'N', X_DECISION_MAKER_FLAG ),
258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

258: JOB_TITLE_CODE = DECODE( X_JOB_TITLE_CODE, NULL, JOB_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_JOB_TITLE_CODE ),
259: REFERENCE_USE_FLAG = DECODE( X_REFERENCE_USE_FLAG, NULL, REFERENCE_USE_FLAG, FND_API.G_MISS_CHAR, NULL, X_REFERENCE_USE_FLAG ),
260: RANK = DECODE( X_RANK, NULL, RANK, FND_API.G_MISS_CHAR, NULL, X_RANK ),
261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

Line 265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

261: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

Line 266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

262: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),

Line 267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

263: CREATION_DATE = CREATION_DATE,
264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),

Line 268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

264: CREATED_BY = CREATED_BY,
265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),

Line 269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

265: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
266: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
267: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
268: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
269: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
270: ORIG_SYSTEM_REFERENCE = DECODE( X_ORIG_SYSTEM_REFERENCE, NULL, ORIG_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIG_SYSTEM_REFERENCE, X_ORIG_SYSTEM_REFERENCE ),
271: ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
272: ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
273: ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),