APPS.OKS_HZ_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 198: hz_utility_pub.CREATED_BY,

194: NUM_COL2_ORIG_LIST(I),
195: NUM_COL2_NEW_LIST(I),
196: 'U',
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY

Line 199: hz_utility_pub.CREATION_DATE,

195: NUM_COL2_NEW_LIST(I),
196: 'U',
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );

Line 200: hz_utility_pub.LAST_UPDATE_LOGIN,

196: 'U',
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;

Line 201: hz_utility_pub.LAST_UPDATE_DATE,

197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;
205: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 202: hz_utility_pub.LAST_UPDATED_BY

198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;
205: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
206: UPDATE OKS_BILLING_PROFILES_B yt SET

Line 407: hz_utility_pub.CREATED_BY,

403: NUM_COL4_ORIG_LIST(I),
404: NUM_COL4_NEW_LIST(I),
405: 'U',
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY

Line 408: hz_utility_pub.CREATION_DATE,

404: NUM_COL4_NEW_LIST(I),
405: 'U',
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );

Line 409: hz_utility_pub.LAST_UPDATE_LOGIN,

405: 'U',
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
413:

Line 410: hz_utility_pub.LAST_UPDATE_DATE,

406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
413:
414: END IF;

Line 411: hz_utility_pub.LAST_UPDATED_BY

407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
413:
414: END IF;
415: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 484: hz_utility_pub.CREATED_BY,

480: NUM_COL2_ORIG_LIST_QUOTE(I),
481: NUM_COL2_NEW_LIST_QUOTE(I),
482: 'U',
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY

Line 485: hz_utility_pub.CREATION_DATE,

481: NUM_COL2_NEW_LIST_QUOTE(I),
482: 'U',
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );

Line 486: hz_utility_pub.LAST_UPDATE_LOGIN,

482: 'U',
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
490:

Line 487: hz_utility_pub.LAST_UPDATE_DATE,

483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
490:
491: END IF;

Line 488: hz_utility_pub.LAST_UPDATED_BY

484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
490:
491: END IF;
492: