DBA Data[Home] [Help]

APPS.CSC_ACCOUNT_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 140: hz_utility_pub.CREATED_BY,

136: NUM_COL2_ORIG_LIST(I),
137: NUM_COL2_NEW_LIST(I),
138: 'U',
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY

Line 141: hz_utility_pub.CREATION_DATE,

137: NUM_COL2_NEW_LIST(I),
138: 'U',
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );

Line 142: hz_utility_pub.LAST_UPDATE_LOGIN,

138: 'U',
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:

Line 143: hz_utility_pub.LAST_UPDATE_DATE,

139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:
147: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 144: hz_utility_pub.LAST_UPDATED_BY

140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:
147: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
148: UPDATE CSC_CUSTOMERS yt SET

Line 253: hz_utility_pub.CREATED_BY,

249: NUM_COL1_ORIG_LIST(I),
250: NUM_COL1_NEW_LIST(I),
251: 'U',
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY

Line 254: hz_utility_pub.CREATION_DATE,

250: NUM_COL1_NEW_LIST(I),
251: 'U',
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );

Line 255: hz_utility_pub.LAST_UPDATE_LOGIN,

251: 'U',
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:

Line 256: hz_utility_pub.LAST_UPDATE_DATE,

252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 257: hz_utility_pub.LAST_UPDATED_BY

253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET

Line 377: hz_utility_pub.CREATED_BY,

373: NUM_COL2_ORIG_LIST(I),
374: NUM_COL2_NEW_LIST(I),
375: 'U',
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY

Line 378: hz_utility_pub.CREATION_DATE,

374: NUM_COL2_NEW_LIST(I),
375: 'U',
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );

Line 379: hz_utility_pub.LAST_UPDATE_LOGIN,

375: 'U',
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:

Line 380: hz_utility_pub.LAST_UPDATE_DATE,

376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:
384: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 381: hz_utility_pub.LAST_UPDATED_BY

377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:
384: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
385: UPDATE CSC_CUSTOMIZED_PLANS yt SET

Line 511: hz_utility_pub.CREATED_BY,

507: NUM_COL2_ORIG_LIST(I),
508: NUM_COL2_NEW_LIST(I),
509: 'U',
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY

Line 512: hz_utility_pub.CREATION_DATE,

508: NUM_COL2_NEW_LIST(I),
509: 'U',
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );

Line 513: hz_utility_pub.LAST_UPDATE_LOGIN,

509: 'U',
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
517:

Line 514: hz_utility_pub.LAST_UPDATE_DATE,

510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
517:
518: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 515: hz_utility_pub.LAST_UPDATED_BY

511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
517:
518: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
519: UPDATE CSC_CUST_PLANS yt SET

Line 667: hz_utility_pub.CREATED_BY,

663: NUM_COL2_ORIG_LIST(I),
664: NUM_COL2_NEW_LIST(I),
665: 'U',
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY

Line 668: hz_utility_pub.CREATION_DATE,

664: NUM_COL2_NEW_LIST(I),
665: 'U',
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );

Line 669: hz_utility_pub.LAST_UPDATE_LOGIN,

665: 'U',
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:

Line 670: hz_utility_pub.LAST_UPDATE_DATE,

666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:
674: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 671: hz_utility_pub.LAST_UPDATED_BY

667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:
674: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
675: UPDATE CSC_CUST_PLANS_AUDIT yt SET