DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARTRX dependencies on HZ_UTILITY_PUB

Line 106: hz_utility_pub.CREATED_BY,

102: NUM_COL2_ORIG_LIST(I),
103: NUM_COL2_NEW_LIST(I),
104: 'U',
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY

Line 107: hz_utility_pub.CREATION_DATE,

103: NUM_COL2_NEW_LIST(I),
104: 'U',
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );

Line 108: hz_utility_pub.LAST_UPDATE_LOGIN,

104: 'U',
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:

Line 109: hz_utility_pub.LAST_UPDATE_DATE,

105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:
113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 110: hz_utility_pub.LAST_UPDATED_BY

106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:
113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
114: UPDATE AR_CASH_RECEIPTS yt SET

Line 237: hz_utility_pub.CREATED_BY,

233: NUM_COL2_ORIG_LIST(I),
234: NUM_COL2_NEW_LIST(I),
235: 'U',
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY

Line 238: hz_utility_pub.CREATION_DATE,

234: NUM_COL2_NEW_LIST(I),
235: 'U',
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );

Line 239: hz_utility_pub.LAST_UPDATE_LOGIN,

235: 'U',
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:

Line 240: hz_utility_pub.LAST_UPDATE_DATE,

236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:
244: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 241: hz_utility_pub.LAST_UPDATED_BY

237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:
244: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
245: UPDATE AR_PAYMENT_SCHEDULES yt SET

Line 482: hz_utility_pub.CREATED_BY,

478: NUM_COL10_ORIG_LIST(I),
479: NUM_COL10_NEW_LIST(I),
480: 'U',
481: req_id,
482: hz_utility_pub.CREATED_BY,
483: hz_utility_pub.CREATION_DATE,
484: hz_utility_pub.LAST_UPDATE_LOGIN,
485: hz_utility_pub.LAST_UPDATE_DATE,
486: hz_utility_pub.LAST_UPDATED_BY

Line 483: hz_utility_pub.CREATION_DATE,

479: NUM_COL10_NEW_LIST(I),
480: 'U',
481: req_id,
482: hz_utility_pub.CREATED_BY,
483: hz_utility_pub.CREATION_DATE,
484: hz_utility_pub.LAST_UPDATE_LOGIN,
485: hz_utility_pub.LAST_UPDATE_DATE,
486: hz_utility_pub.LAST_UPDATED_BY
487: );

Line 484: hz_utility_pub.LAST_UPDATE_LOGIN,

480: 'U',
481: req_id,
482: hz_utility_pub.CREATED_BY,
483: hz_utility_pub.CREATION_DATE,
484: hz_utility_pub.LAST_UPDATE_LOGIN,
485: hz_utility_pub.LAST_UPDATE_DATE,
486: hz_utility_pub.LAST_UPDATED_BY
487: );
488: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 485: hz_utility_pub.LAST_UPDATE_DATE,

481: req_id,
482: hz_utility_pub.CREATED_BY,
483: hz_utility_pub.CREATION_DATE,
484: hz_utility_pub.LAST_UPDATE_LOGIN,
485: hz_utility_pub.LAST_UPDATE_DATE,
486: hz_utility_pub.LAST_UPDATED_BY
487: );
488: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
489: UPDATE RA_CUSTOMER_TRX yt SET

Line 486: hz_utility_pub.LAST_UPDATED_BY

482: hz_utility_pub.CREATED_BY,
483: hz_utility_pub.CREATION_DATE,
484: hz_utility_pub.LAST_UPDATE_LOGIN,
485: hz_utility_pub.LAST_UPDATE_DATE,
486: hz_utility_pub.LAST_UPDATED_BY
487: );
488: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
489: UPDATE RA_CUSTOMER_TRX yt SET
490: bill_to_customer_id=NUM_COL1_NEW_LIST(I)

Line 629: hz_utility_pub.CREATED_BY,

625: NUM_COL2_ORIG_LIST(I),
626: NUM_COL2_NEW_LIST(I),
627: 'U',
628: req_id,
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY

Line 630: hz_utility_pub.CREATION_DATE,

626: NUM_COL2_NEW_LIST(I),
627: 'U',
628: req_id,
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: );

Line 631: hz_utility_pub.LAST_UPDATE_LOGIN,

627: 'U',
628: req_id,
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: );
635: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 632: hz_utility_pub.LAST_UPDATE_DATE,

628: req_id,
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: );
635: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
636: UPDATE RA_CUSTOMER_TRX_LINES yt SET

Line 633: hz_utility_pub.LAST_UPDATED_BY

629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: );
635: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
636: UPDATE RA_CUSTOMER_TRX_LINES yt SET
637:

Line 764: hz_utility_pub.CREATED_BY,

760: NUM_COL2_ORIG_LIST(I),
761: NUM_COL2_NEW_LIST(I),
762: 'U',
763: req_id,
764: hz_utility_pub.CREATED_BY,
765: hz_utility_pub.CREATION_DATE,
766: hz_utility_pub.LAST_UPDATE_LOGIN,
767: hz_utility_pub.LAST_UPDATE_DATE,
768: hz_utility_pub.LAST_UPDATED_BY

Line 765: hz_utility_pub.CREATION_DATE,

761: NUM_COL2_NEW_LIST(I),
762: 'U',
763: req_id,
764: hz_utility_pub.CREATED_BY,
765: hz_utility_pub.CREATION_DATE,
766: hz_utility_pub.LAST_UPDATE_LOGIN,
767: hz_utility_pub.LAST_UPDATE_DATE,
768: hz_utility_pub.LAST_UPDATED_BY
769: );

Line 766: hz_utility_pub.LAST_UPDATE_LOGIN,

762: 'U',
763: req_id,
764: hz_utility_pub.CREATED_BY,
765: hz_utility_pub.CREATION_DATE,
766: hz_utility_pub.LAST_UPDATE_LOGIN,
767: hz_utility_pub.LAST_UPDATE_DATE,
768: hz_utility_pub.LAST_UPDATED_BY
769: );
770: END IF;

Line 767: hz_utility_pub.LAST_UPDATE_DATE,

763: req_id,
764: hz_utility_pub.CREATED_BY,
765: hz_utility_pub.CREATION_DATE,
766: hz_utility_pub.LAST_UPDATE_LOGIN,
767: hz_utility_pub.LAST_UPDATE_DATE,
768: hz_utility_pub.LAST_UPDATED_BY
769: );
770: END IF;
771:

Line 768: hz_utility_pub.LAST_UPDATED_BY

764: hz_utility_pub.CREATED_BY,
765: hz_utility_pub.CREATION_DATE,
766: hz_utility_pub.LAST_UPDATE_LOGIN,
767: hz_utility_pub.LAST_UPDATE_DATE,
768: hz_utility_pub.LAST_UPDATED_BY
769: );
770: END IF;
771:
772: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1248: hz_utility_pub.CREATED_BY,

1244: VCHAR_COL5_ORIG_LIST(I),
1245: VCHAR_COL5_NEW_LIST(I),
1246: 'U',
1247: req_id,
1248: hz_utility_pub.CREATED_BY,
1249: hz_utility_pub.CREATION_DATE,
1250: hz_utility_pub.LAST_UPDATE_LOGIN,
1251: hz_utility_pub.LAST_UPDATE_DATE,
1252: hz_utility_pub.LAST_UPDATED_BY

Line 1249: hz_utility_pub.CREATION_DATE,

1245: VCHAR_COL5_NEW_LIST(I),
1246: 'U',
1247: req_id,
1248: hz_utility_pub.CREATED_BY,
1249: hz_utility_pub.CREATION_DATE,
1250: hz_utility_pub.LAST_UPDATE_LOGIN,
1251: hz_utility_pub.LAST_UPDATE_DATE,
1252: hz_utility_pub.LAST_UPDATED_BY
1253: );

Line 1250: hz_utility_pub.LAST_UPDATE_LOGIN,

1246: 'U',
1247: req_id,
1248: hz_utility_pub.CREATED_BY,
1249: hz_utility_pub.CREATION_DATE,
1250: hz_utility_pub.LAST_UPDATE_LOGIN,
1251: hz_utility_pub.LAST_UPDATE_DATE,
1252: hz_utility_pub.LAST_UPDATED_BY
1253: );
1254:

Line 1251: hz_utility_pub.LAST_UPDATE_DATE,

1247: req_id,
1248: hz_utility_pub.CREATED_BY,
1249: hz_utility_pub.CREATION_DATE,
1250: hz_utility_pub.LAST_UPDATE_LOGIN,
1251: hz_utility_pub.LAST_UPDATE_DATE,
1252: hz_utility_pub.LAST_UPDATED_BY
1253: );
1254:
1255: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1252: hz_utility_pub.LAST_UPDATED_BY

1248: hz_utility_pub.CREATED_BY,
1249: hz_utility_pub.CREATION_DATE,
1250: hz_utility_pub.LAST_UPDATE_LOGIN,
1251: hz_utility_pub.LAST_UPDATE_DATE,
1252: hz_utility_pub.LAST_UPDATED_BY
1253: );
1254:
1255: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1256: UPDATE RA_INTERFACE_LINES yt SET

Line 1383: hz_utility_pub.CREATED_BY,

1379: NUM_COL2_ORIG_LIST(I),
1380: NUM_COL2_NEW_LIST(I),
1381: 'U',
1382: req_id,
1383: hz_utility_pub.CREATED_BY,
1384: hz_utility_pub.CREATION_DATE,
1385: hz_utility_pub.LAST_UPDATE_LOGIN,
1386: hz_utility_pub.LAST_UPDATE_DATE,
1387: hz_utility_pub.LAST_UPDATED_BY

Line 1384: hz_utility_pub.CREATION_DATE,

1380: NUM_COL2_NEW_LIST(I),
1381: 'U',
1382: req_id,
1383: hz_utility_pub.CREATED_BY,
1384: hz_utility_pub.CREATION_DATE,
1385: hz_utility_pub.LAST_UPDATE_LOGIN,
1386: hz_utility_pub.LAST_UPDATE_DATE,
1387: hz_utility_pub.LAST_UPDATED_BY
1388: );

Line 1385: hz_utility_pub.LAST_UPDATE_LOGIN,

1381: 'U',
1382: req_id,
1383: hz_utility_pub.CREATED_BY,
1384: hz_utility_pub.CREATION_DATE,
1385: hz_utility_pub.LAST_UPDATE_LOGIN,
1386: hz_utility_pub.LAST_UPDATE_DATE,
1387: hz_utility_pub.LAST_UPDATED_BY
1388: );
1389:

Line 1386: hz_utility_pub.LAST_UPDATE_DATE,

1382: req_id,
1383: hz_utility_pub.CREATED_BY,
1384: hz_utility_pub.CREATION_DATE,
1385: hz_utility_pub.LAST_UPDATE_LOGIN,
1386: hz_utility_pub.LAST_UPDATE_DATE,
1387: hz_utility_pub.LAST_UPDATED_BY
1388: );
1389:
1390: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1387: hz_utility_pub.LAST_UPDATED_BY

1383: hz_utility_pub.CREATED_BY,
1384: hz_utility_pub.CREATION_DATE,
1385: hz_utility_pub.LAST_UPDATE_LOGIN,
1386: hz_utility_pub.LAST_UPDATE_DATE,
1387: hz_utility_pub.LAST_UPDATED_BY
1388: );
1389:
1390: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1391: UPDATE AR_DISTRIBUTIONS yt SET