APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on HZ_UTILITY_V2PUB

Line 254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

250: AUTOMATCH_SET_ID
251: )
252: VALUES (
253: DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),
254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
257: HZ_UTILITY_V2PUB.CREATED_BY,
258: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

251: )
252: VALUES (
253: DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),
254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
257: HZ_UTILITY_V2PUB.CREATED_BY,
258: HZ_UTILITY_V2PUB.CREATION_DATE,
259: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),

Line 256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

252: VALUES (
253: DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),
254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
257: HZ_UTILITY_V2PUB.CREATED_BY,
258: HZ_UTILITY_V2PUB.CREATION_DATE,
259: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
260: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

Line 257: HZ_UTILITY_V2PUB.CREATED_BY,

253: DECODE( X_CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, HZ_CUSTOMER_PROFILES_S.NEXTVAL, NULL, HZ_CUSTOMER_PROFILES_S.NEXTVAL, X_CUST_ACCOUNT_PROFILE_ID ),
254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
257: HZ_UTILITY_V2PUB.CREATED_BY,
258: HZ_UTILITY_V2PUB.CREATION_DATE,
259: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
260: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
261: DECODE( X_COLLECTOR_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.collector_id, X_COLLECTOR_ID ),

Line 258: HZ_UTILITY_V2PUB.CREATION_DATE,

254: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
255: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
256: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
257: HZ_UTILITY_V2PUB.CREATED_BY,
258: HZ_UTILITY_V2PUB.CREATION_DATE,
259: DECODE( X_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
260: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
261: DECODE( X_COLLECTOR_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.collector_id, X_COLLECTOR_ID ),
262: DECODE( X_CREDIT_ANALYST_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.credit_analyst_id, X_CREDIT_ANALYST_ID ),

Line 299: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

295: DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute7, X_ATTRIBUTE7 ),
296: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute8, X_ATTRIBUTE8 ),
297: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute9, X_ATTRIBUTE9 ),
298: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute10, X_ATTRIBUTE10 ),
299: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
300: HZ_UTILITY_V2PUB.PROGRAM_ID,
301: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
302: HZ_UTILITY_V2PUB.REQUEST_ID,
303: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute11, X_ATTRIBUTE11 ),

Line 300: HZ_UTILITY_V2PUB.PROGRAM_ID,

296: DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute8, X_ATTRIBUTE8 ),
297: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute9, X_ATTRIBUTE9 ),
298: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute10, X_ATTRIBUTE10 ),
299: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
300: HZ_UTILITY_V2PUB.PROGRAM_ID,
301: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
302: HZ_UTILITY_V2PUB.REQUEST_ID,
303: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute11, X_ATTRIBUTE11 ),
304: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute12, X_ATTRIBUTE12 ),

Line 301: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

297: DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute9, X_ATTRIBUTE9 ),
298: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute10, X_ATTRIBUTE10 ),
299: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
300: HZ_UTILITY_V2PUB.PROGRAM_ID,
301: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
302: HZ_UTILITY_V2PUB.REQUEST_ID,
303: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute11, X_ATTRIBUTE11 ),
304: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute12, X_ATTRIBUTE12 ),
305: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute13, X_ATTRIBUTE13 ),

Line 302: HZ_UTILITY_V2PUB.REQUEST_ID,

298: DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute10, X_ATTRIBUTE10 ),
299: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
300: HZ_UTILITY_V2PUB.PROGRAM_ID,
301: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
302: HZ_UTILITY_V2PUB.REQUEST_ID,
303: DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute11, X_ATTRIBUTE11 ),
304: DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute12, X_ATTRIBUTE12 ),
305: DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute13, X_ATTRIBUTE13 ),
306: DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.attribute14, X_ATTRIBUTE14 ),

Line 549: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

545: END IF;
546:
547: UPDATE HZ_CUSTOMER_PROFILES SET
548: CUST_ACCOUNT_PROFILE_ID = DECODE( X_CUST_ACCOUNT_PROFILE_ID, NULL, CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_PROFILE_ID ),
549: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
550: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
551: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
552: CREATED_BY = CREATED_BY,
553: CREATION_DATE = CREATION_DATE,

Line 550: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

546:
547: UPDATE HZ_CUSTOMER_PROFILES SET
548: CUST_ACCOUNT_PROFILE_ID = DECODE( X_CUST_ACCOUNT_PROFILE_ID, NULL, CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_PROFILE_ID ),
549: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
550: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
551: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
552: CREATED_BY = CREATED_BY,
553: CREATION_DATE = CREATION_DATE,
554: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),

Line 551: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

547: UPDATE HZ_CUSTOMER_PROFILES SET
548: CUST_ACCOUNT_PROFILE_ID = DECODE( X_CUST_ACCOUNT_PROFILE_ID, NULL, CUST_ACCOUNT_PROFILE_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_PROFILE_ID ),
549: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
550: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
551: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
552: CREATED_BY = CREATED_BY,
553: CREATION_DATE = CREATION_DATE,
554: CUST_ACCOUNT_ID = DECODE( X_CUST_ACCOUNT_ID, NULL, CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, X_CUST_ACCOUNT_ID ),
555: STATUS = DECODE( X_STATUS, NULL, STATUS, FND_API.G_MISS_CHAR, 'A', X_STATUS ),

Line 598: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

594: ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE7, l_profile_class_rec.attribute7 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
595: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE8, l_profile_class_rec.attribute8 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
596: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE9, l_profile_class_rec.attribute9 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
597: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE10, l_profile_class_rec.attribute10 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
598: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
599: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
600: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
601: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
602: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE11, l_profile_class_rec.attribute11 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),

Line 599: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,

595: ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE8, l_profile_class_rec.attribute8 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
596: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE9, l_profile_class_rec.attribute9 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
597: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE10, l_profile_class_rec.attribute10 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
598: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
599: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
600: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
601: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
602: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE11, l_profile_class_rec.attribute11 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
603: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE12, l_profile_class_rec.attribute12 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),

Line 600: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,

596: ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE9, l_profile_class_rec.attribute9 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
597: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE10, l_profile_class_rec.attribute10 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
598: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
599: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
600: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
601: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
602: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE11, l_profile_class_rec.attribute11 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
603: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE12, l_profile_class_rec.attribute12 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
604: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE13, l_profile_class_rec.attribute13 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),

Line 601: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,

597: ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE10, l_profile_class_rec.attribute10 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
598: PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
599: PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
600: PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
601: REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
602: ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE11, l_profile_class_rec.attribute11 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
603: ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE12, l_profile_class_rec.attribute12 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
604: ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE13, l_profile_class_rec.attribute13 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
605: ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, DECODE( l_profile_class_updated, 'N', ATTRIBUTE14, l_profile_class_rec.attribute14 ), FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),