DBA Data[Home] [Help]

APPS.JL_CMERGE dependencies on HZ_UTILITY_PUB

Line 111: hz_utility_pub.CREATED_BY,

107: NUM_COL1_ORIG_LIST(I),
108: NUM_COL1_NEW_LIST(I),
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY

Line 112: hz_utility_pub.CREATION_DATE,

108: NUM_COL1_NEW_LIST(I),
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );

Line 113: hz_utility_pub.LAST_UPDATE_LOGIN,

109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:

Line 114: hz_utility_pub.LAST_UPDATE_DATE,

110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 115: hz_utility_pub.LAST_UPDATED_BY

111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
119: UPDATE JL_BR_AR_BANK_RETURNS yt SET

Line 260: hz_utility_pub.CREATED_BY,

256: NUM_COL2_ORIG_LIST(I),
257: NUM_COL2_NEW_LIST(I),
258: 'U',
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY

Line 261: hz_utility_pub.CREATION_DATE,

257: NUM_COL2_NEW_LIST(I),
258: 'U',
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );

Line 262: hz_utility_pub.LAST_UPDATE_LOGIN,

258: 'U',
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
266: END IF;

Line 263: hz_utility_pub.LAST_UPDATE_DATE,

259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
266: END IF;
267:

Line 264: hz_utility_pub.LAST_UPDATED_BY

260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
266: END IF;
267:
268: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 396: hz_utility_pub.CREATED_BY,

392: NUM_COL1_ORIG_LIST(I),
393: NUM_COL1_NEW_LIST(I),
394: 'U',
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY

Line 397: hz_utility_pub.CREATION_DATE,

393: NUM_COL1_NEW_LIST(I),
394: 'U',
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );

Line 398: hz_utility_pub.LAST_UPDATE_LOGIN,

394: 'U',
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:

Line 399: hz_utility_pub.LAST_UPDATE_DATE,

395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:
403: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 400: hz_utility_pub.LAST_UPDATED_BY

396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:
403: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
404: UPDATE JL_BR_AR_PAY_SCHED_AUX yt SET

Line 768: hz_utility_pub.CREATED_BY,

764: VCHAR_COL1_ORIG_LIST(I),
765: VCHAR_COL1_NEW_LIST(I),
766: 'U',
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY

Line 769: hz_utility_pub.CREATION_DATE,

765: VCHAR_COL1_NEW_LIST(I),
766: 'U',
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );

Line 770: hz_utility_pub.LAST_UPDATE_LOGIN,

766: 'U',
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
774:

Line 771: hz_utility_pub.LAST_UPDATE_DATE,

767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
774:
775: END IF;

Line 772: hz_utility_pub.LAST_UPDATED_BY

768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
774:
775: END IF;
776:

Line 1646: hz_utility_pub.CREATED_BY,

1642: NUM_COL5_ORIG_LIST(I),
1643: NUM_COL6_ORIG_LIST(I),
1644: 'D',
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY

Line 1647: hz_utility_pub.CREATION_DATE,

1643: NUM_COL6_ORIG_LIST(I),
1644: 'D',
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );

Line 1648: hz_utility_pub.LAST_UPDATE_LOGIN,

1644: 'D',
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1652:

Line 1649: hz_utility_pub.LAST_UPDATE_DATE,

1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1652:
1653: END IF;

Line 1650: hz_utility_pub.LAST_UPDATED_BY

1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1652:
1653: END IF;
1654: