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 452: hz_utility_pub.CREATED_BY,

448: NUM_COL8_ORIG_LIST(I),
449: NUM_COL8_NEW_LIST(I),
450: 'U',
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY

Line 453: hz_utility_pub.CREATION_DATE,

449: NUM_COL8_NEW_LIST(I),
450: 'U',
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );

Line 454: hz_utility_pub.LAST_UPDATE_LOGIN,

450: 'U',
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
458: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 455: hz_utility_pub.LAST_UPDATE_DATE,

451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
458: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
459: UPDATE RA_CUSTOMER_TRX yt SET

Line 456: hz_utility_pub.LAST_UPDATED_BY

452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
458: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
459: UPDATE RA_CUSTOMER_TRX yt SET
460: bill_to_customer_id=NUM_COL1_NEW_LIST(I)

Line 762: hz_utility_pub.CREATED_BY,

758: VCHAR_COL5_ORIG_LIST(I),
759: VCHAR_COL5_NEW_LIST(I),
760: 'U',
761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY

Line 763: hz_utility_pub.CREATION_DATE,

759: VCHAR_COL5_NEW_LIST(I),
760: 'U',
761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );

Line 764: hz_utility_pub.LAST_UPDATE_LOGIN,

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

Line 765: hz_utility_pub.LAST_UPDATE_DATE,

761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );
768:
769: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 766: hz_utility_pub.LAST_UPDATED_BY

762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );
768:
769: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
770: UPDATE RA_INTERFACE_LINES yt SET

Line 897: hz_utility_pub.CREATED_BY,

893: NUM_COL2_ORIG_LIST(I),
894: NUM_COL2_NEW_LIST(I),
895: 'U',
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY

Line 898: hz_utility_pub.CREATION_DATE,

894: NUM_COL2_NEW_LIST(I),
895: 'U',
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );

Line 899: hz_utility_pub.LAST_UPDATE_LOGIN,

895: 'U',
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:

Line 900: hz_utility_pub.LAST_UPDATE_DATE,

896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 901: hz_utility_pub.LAST_UPDATED_BY

897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
905: UPDATE AR_DISTRIBUTIONS yt SET