eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACCOUNT_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 131: hz_utility_pub.CREATED_BY,

127: NUM_COL3_ORIG_LIST(I),
128: NUM_COL3_NEW_LIST(I),
129: 'U',
130: req_id,
131: hz_utility_pub.CREATED_BY,
132: hz_utility_pub.CREATION_DATE,
133: hz_utility_pub.LAST_UPDATE_LOGIN,
134: hz_utility_pub.LAST_UPDATE_DATE,
135: hz_utility_pub.LAST_UPDATED_BY

Line 132: hz_utility_pub.CREATION_DATE,

128: NUM_COL3_NEW_LIST(I),
129: 'U',
130: req_id,
131: hz_utility_pub.CREATED_BY,
132: hz_utility_pub.CREATION_DATE,
133: hz_utility_pub.LAST_UPDATE_LOGIN,
134: hz_utility_pub.LAST_UPDATE_DATE,
135: hz_utility_pub.LAST_UPDATED_BY
136: );

Line 133: hz_utility_pub.LAST_UPDATE_LOGIN,

129: 'U',
130: req_id,
131: hz_utility_pub.CREATED_BY,
132: hz_utility_pub.CREATION_DATE,
133: hz_utility_pub.LAST_UPDATE_LOGIN,
134: hz_utility_pub.LAST_UPDATE_DATE,
135: hz_utility_pub.LAST_UPDATED_BY
136: );
137:

Line 134: hz_utility_pub.LAST_UPDATE_DATE,

130: req_id,
131: hz_utility_pub.CREATED_BY,
132: hz_utility_pub.CREATION_DATE,
133: hz_utility_pub.LAST_UPDATE_LOGIN,
134: hz_utility_pub.LAST_UPDATE_DATE,
135: hz_utility_pub.LAST_UPDATED_BY
136: );
137:
138: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 135: hz_utility_pub.LAST_UPDATED_BY

131: hz_utility_pub.CREATED_BY,
132: hz_utility_pub.CREATION_DATE,
133: hz_utility_pub.LAST_UPDATE_LOGIN,
134: hz_utility_pub.LAST_UPDATE_DATE,
135: hz_utility_pub.LAST_UPDATED_BY
136: );
137:
138: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
139: UPDATE ozf_account_allocations yt SET

Line 271: hz_utility_pub.CREATED_BY,

267: NUM_COL2_ORIG_LIST(I),
268: NUM_COL2_NEW_LIST(I),
269: 'U',
270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY

Line 272: hz_utility_pub.CREATION_DATE,

268: NUM_COL2_NEW_LIST(I),
269: 'U',
270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );

Line 273: hz_utility_pub.LAST_UPDATE_LOGIN,

269: 'U',
270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:

Line 274: hz_utility_pub.LAST_UPDATE_DATE,

270: req_id,
271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:
278: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 275: hz_utility_pub.LAST_UPDATED_BY

271: hz_utility_pub.CREATED_BY,
272: hz_utility_pub.CREATION_DATE,
273: hz_utility_pub.LAST_UPDATE_LOGIN,
274: hz_utility_pub.LAST_UPDATE_DATE,
275: hz_utility_pub.LAST_UPDATED_BY
276: );
277:
278: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
279: UPDATE ozf_claim_lines yt SET

Line 415: hz_utility_pub.CREATED_BY,

411: NUM_COL2_ORIG_LIST(I),
412: NUM_COL2_NEW_LIST(I),
413: 'U',
414: req_id,
415: hz_utility_pub.CREATED_BY,
416: hz_utility_pub.CREATION_DATE,
417: hz_utility_pub.LAST_UPDATE_LOGIN,
418: hz_utility_pub.LAST_UPDATE_DATE,
419: hz_utility_pub.LAST_UPDATED_BY

Line 416: hz_utility_pub.CREATION_DATE,

412: NUM_COL2_NEW_LIST(I),
413: 'U',
414: req_id,
415: hz_utility_pub.CREATED_BY,
416: hz_utility_pub.CREATION_DATE,
417: hz_utility_pub.LAST_UPDATE_LOGIN,
418: hz_utility_pub.LAST_UPDATE_DATE,
419: hz_utility_pub.LAST_UPDATED_BY
420: );

Line 417: hz_utility_pub.LAST_UPDATE_LOGIN,

413: 'U',
414: req_id,
415: hz_utility_pub.CREATED_BY,
416: hz_utility_pub.CREATION_DATE,
417: hz_utility_pub.LAST_UPDATE_LOGIN,
418: hz_utility_pub.LAST_UPDATE_DATE,
419: hz_utility_pub.LAST_UPDATED_BY
420: );
421:

Line 418: hz_utility_pub.LAST_UPDATE_DATE,

414: req_id,
415: hz_utility_pub.CREATED_BY,
416: hz_utility_pub.CREATION_DATE,
417: hz_utility_pub.LAST_UPDATE_LOGIN,
418: hz_utility_pub.LAST_UPDATE_DATE,
419: hz_utility_pub.LAST_UPDATED_BY
420: );
421:
422: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 419: hz_utility_pub.LAST_UPDATED_BY

415: hz_utility_pub.CREATED_BY,
416: hz_utility_pub.CREATION_DATE,
417: hz_utility_pub.LAST_UPDATE_LOGIN,
418: hz_utility_pub.LAST_UPDATE_DATE,
419: hz_utility_pub.LAST_UPDATED_BY
420: );
421:
422: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
423: UPDATE ozf_claim_lines_hist yt SET

Line 615: hz_utility_pub.CREATED_BY,

611: NUM_COL6_ORIG_LIST(I),
612: NUM_COL6_NEW_LIST(I),
613: 'U',
614: req_id,
615: hz_utility_pub.CREATED_BY,
616: hz_utility_pub.CREATION_DATE,
617: hz_utility_pub.LAST_UPDATE_LOGIN,
618: hz_utility_pub.LAST_UPDATE_DATE,
619: hz_utility_pub.LAST_UPDATED_BY

Line 616: hz_utility_pub.CREATION_DATE,

612: NUM_COL6_NEW_LIST(I),
613: 'U',
614: req_id,
615: hz_utility_pub.CREATED_BY,
616: hz_utility_pub.CREATION_DATE,
617: hz_utility_pub.LAST_UPDATE_LOGIN,
618: hz_utility_pub.LAST_UPDATE_DATE,
619: hz_utility_pub.LAST_UPDATED_BY
620: );

Line 617: hz_utility_pub.LAST_UPDATE_LOGIN,

613: 'U',
614: req_id,
615: hz_utility_pub.CREATED_BY,
616: hz_utility_pub.CREATION_DATE,
617: hz_utility_pub.LAST_UPDATE_LOGIN,
618: hz_utility_pub.LAST_UPDATE_DATE,
619: hz_utility_pub.LAST_UPDATED_BY
620: );
621:

Line 618: hz_utility_pub.LAST_UPDATE_DATE,

614: req_id,
615: hz_utility_pub.CREATED_BY,
616: hz_utility_pub.CREATION_DATE,
617: hz_utility_pub.LAST_UPDATE_LOGIN,
618: hz_utility_pub.LAST_UPDATE_DATE,
619: hz_utility_pub.LAST_UPDATED_BY
620: );
621:
622: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 619: hz_utility_pub.LAST_UPDATED_BY

615: hz_utility_pub.CREATED_BY,
616: hz_utility_pub.CREATION_DATE,
617: hz_utility_pub.LAST_UPDATE_LOGIN,
618: hz_utility_pub.LAST_UPDATE_DATE,
619: hz_utility_pub.LAST_UPDATED_BY
620: );
621:
622: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
623: UPDATE ozf_claims yt SET

Line 819: hz_utility_pub.CREATED_BY,

815: NUM_COL6_ORIG_LIST(I),
816: NUM_COL6_NEW_LIST(I),
817: 'U',
818: req_id,
819: hz_utility_pub.CREATED_BY,
820: hz_utility_pub.CREATION_DATE,
821: hz_utility_pub.LAST_UPDATE_LOGIN,
822: hz_utility_pub.LAST_UPDATE_DATE,
823: hz_utility_pub.LAST_UPDATED_BY

Line 820: hz_utility_pub.CREATION_DATE,

816: NUM_COL6_NEW_LIST(I),
817: 'U',
818: req_id,
819: hz_utility_pub.CREATED_BY,
820: hz_utility_pub.CREATION_DATE,
821: hz_utility_pub.LAST_UPDATE_LOGIN,
822: hz_utility_pub.LAST_UPDATE_DATE,
823: hz_utility_pub.LAST_UPDATED_BY
824: );

Line 821: hz_utility_pub.LAST_UPDATE_LOGIN,

817: 'U',
818: req_id,
819: hz_utility_pub.CREATED_BY,
820: hz_utility_pub.CREATION_DATE,
821: hz_utility_pub.LAST_UPDATE_LOGIN,
822: hz_utility_pub.LAST_UPDATE_DATE,
823: hz_utility_pub.LAST_UPDATED_BY
824: );
825:

Line 822: hz_utility_pub.LAST_UPDATE_DATE,

818: req_id,
819: hz_utility_pub.CREATED_BY,
820: hz_utility_pub.CREATION_DATE,
821: hz_utility_pub.LAST_UPDATE_LOGIN,
822: hz_utility_pub.LAST_UPDATE_DATE,
823: hz_utility_pub.LAST_UPDATED_BY
824: );
825:
826: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 823: hz_utility_pub.LAST_UPDATED_BY

819: hz_utility_pub.CREATED_BY,
820: hz_utility_pub.CREATION_DATE,
821: hz_utility_pub.LAST_UPDATE_LOGIN,
822: hz_utility_pub.LAST_UPDATE_DATE,
823: hz_utility_pub.LAST_UPDATED_BY
824: );
825:
826: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
827: UPDATE ozf_claims_history yt SET

Line 953: hz_utility_pub.CREATED_BY,

949: NUM_COL1_ORIG_LIST(I),
950: NUM_COL1_NEW_LIST(I),
951: 'U',
952: req_id,
953: hz_utility_pub.CREATED_BY,
954: hz_utility_pub.CREATION_DATE,
955: hz_utility_pub.LAST_UPDATE_LOGIN,
956: hz_utility_pub.LAST_UPDATE_DATE,
957: hz_utility_pub.LAST_UPDATED_BY

Line 954: hz_utility_pub.CREATION_DATE,

950: NUM_COL1_NEW_LIST(I),
951: 'U',
952: req_id,
953: hz_utility_pub.CREATED_BY,
954: hz_utility_pub.CREATION_DATE,
955: hz_utility_pub.LAST_UPDATE_LOGIN,
956: hz_utility_pub.LAST_UPDATE_DATE,
957: hz_utility_pub.LAST_UPDATED_BY
958: );

Line 955: hz_utility_pub.LAST_UPDATE_LOGIN,

951: 'U',
952: req_id,
953: hz_utility_pub.CREATED_BY,
954: hz_utility_pub.CREATION_DATE,
955: hz_utility_pub.LAST_UPDATE_LOGIN,
956: hz_utility_pub.LAST_UPDATE_DATE,
957: hz_utility_pub.LAST_UPDATED_BY
958: );
959:

Line 956: hz_utility_pub.LAST_UPDATE_DATE,

952: req_id,
953: hz_utility_pub.CREATED_BY,
954: hz_utility_pub.CREATION_DATE,
955: hz_utility_pub.LAST_UPDATE_LOGIN,
956: hz_utility_pub.LAST_UPDATE_DATE,
957: hz_utility_pub.LAST_UPDATED_BY
958: );
959:
960: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 957: hz_utility_pub.LAST_UPDATED_BY

953: hz_utility_pub.CREATED_BY,
954: hz_utility_pub.CREATION_DATE,
955: hz_utility_pub.LAST_UPDATE_LOGIN,
956: hz_utility_pub.LAST_UPDATE_DATE,
957: hz_utility_pub.LAST_UPDATED_BY
958: );
959:
960: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
961: UPDATE ozf_code_conversions yt SET

Line 1106: hz_utility_pub.CREATED_BY,

1102: NUM_COL3_ORIG_LIST(I),
1103: NUM_COL3_NEW_LIST(I),
1104: 'U',
1105: req_id,
1106: hz_utility_pub.CREATED_BY,
1107: hz_utility_pub.CREATION_DATE,
1108: hz_utility_pub.LAST_UPDATE_LOGIN,
1109: hz_utility_pub.LAST_UPDATE_DATE,
1110: hz_utility_pub.LAST_UPDATED_BY

Line 1107: hz_utility_pub.CREATION_DATE,

1103: NUM_COL3_NEW_LIST(I),
1104: 'U',
1105: req_id,
1106: hz_utility_pub.CREATED_BY,
1107: hz_utility_pub.CREATION_DATE,
1108: hz_utility_pub.LAST_UPDATE_LOGIN,
1109: hz_utility_pub.LAST_UPDATE_DATE,
1110: hz_utility_pub.LAST_UPDATED_BY
1111: );

Line 1108: hz_utility_pub.LAST_UPDATE_LOGIN,

1104: 'U',
1105: req_id,
1106: hz_utility_pub.CREATED_BY,
1107: hz_utility_pub.CREATION_DATE,
1108: hz_utility_pub.LAST_UPDATE_LOGIN,
1109: hz_utility_pub.LAST_UPDATE_DATE,
1110: hz_utility_pub.LAST_UPDATED_BY
1111: );
1112:

Line 1109: hz_utility_pub.LAST_UPDATE_DATE,

1105: req_id,
1106: hz_utility_pub.CREATED_BY,
1107: hz_utility_pub.CREATION_DATE,
1108: hz_utility_pub.LAST_UPDATE_LOGIN,
1109: hz_utility_pub.LAST_UPDATE_DATE,
1110: hz_utility_pub.LAST_UPDATED_BY
1111: );
1112:
1113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1110: hz_utility_pub.LAST_UPDATED_BY

1106: hz_utility_pub.CREATED_BY,
1107: hz_utility_pub.CREATION_DATE,
1108: hz_utility_pub.LAST_UPDATE_LOGIN,
1109: hz_utility_pub.LAST_UPDATE_DATE,
1110: hz_utility_pub.LAST_UPDATED_BY
1111: );
1112:
1113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1114: UPDATE ozf_cust_daily_facts yt SET

Line 1246: hz_utility_pub.CREATED_BY,

1242: NUM_COL2_ORIG_LIST(I),
1243: NUM_COL2_NEW_LIST(I),
1244: 'U',
1245: req_id,
1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY

Line 1247: hz_utility_pub.CREATION_DATE,

1243: NUM_COL2_NEW_LIST(I),
1244: 'U',
1245: req_id,
1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY
1251: );

Line 1248: hz_utility_pub.LAST_UPDATE_LOGIN,

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

Line 1249: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 1250: hz_utility_pub.LAST_UPDATED_BY

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

Line 1400: hz_utility_pub.CREATED_BY,

1396: NUM_COL2_ORIG_LIST(I),
1397: NUM_COL2_NEW_LIST(I),
1398: 'U',
1399: req_id,
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY

Line 1401: hz_utility_pub.CREATION_DATE,

1397: NUM_COL2_NEW_LIST(I),
1398: 'U',
1399: req_id,
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: );

Line 1402: hz_utility_pub.LAST_UPDATE_LOGIN,

1398: 'U',
1399: req_id,
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: );
1406:

Line 1403: hz_utility_pub.LAST_UPDATE_DATE,

1399: req_id,
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: );
1406:
1407: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1404: hz_utility_pub.LAST_UPDATED_BY

1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: );
1406:
1407: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1408: UPDATE ozf_activity_customers yt SET

Line 1528: hz_utility_pub.CREATED_BY,

1524: NUM_COL1_ORIG_LIST(I),
1525: NUM_COL1_NEW_LIST(I),
1526: 'U',
1527: req_id,
1528: hz_utility_pub.CREATED_BY,
1529: hz_utility_pub.CREATION_DATE,
1530: hz_utility_pub.LAST_UPDATE_LOGIN,
1531: hz_utility_pub.LAST_UPDATE_DATE,
1532: hz_utility_pub.LAST_UPDATED_BY

Line 1529: hz_utility_pub.CREATION_DATE,

1525: NUM_COL1_NEW_LIST(I),
1526: 'U',
1527: req_id,
1528: hz_utility_pub.CREATED_BY,
1529: hz_utility_pub.CREATION_DATE,
1530: hz_utility_pub.LAST_UPDATE_LOGIN,
1531: hz_utility_pub.LAST_UPDATE_DATE,
1532: hz_utility_pub.LAST_UPDATED_BY
1533: );

Line 1530: hz_utility_pub.LAST_UPDATE_LOGIN,

1526: 'U',
1527: req_id,
1528: hz_utility_pub.CREATED_BY,
1529: hz_utility_pub.CREATION_DATE,
1530: hz_utility_pub.LAST_UPDATE_LOGIN,
1531: hz_utility_pub.LAST_UPDATE_DATE,
1532: hz_utility_pub.LAST_UPDATED_BY
1533: );
1534:

Line 1531: hz_utility_pub.LAST_UPDATE_DATE,

1527: req_id,
1528: hz_utility_pub.CREATED_BY,
1529: hz_utility_pub.CREATION_DATE,
1530: hz_utility_pub.LAST_UPDATE_LOGIN,
1531: hz_utility_pub.LAST_UPDATE_DATE,
1532: hz_utility_pub.LAST_UPDATED_BY
1533: );
1534:
1535: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1532: hz_utility_pub.LAST_UPDATED_BY

1528: hz_utility_pub.CREATED_BY,
1529: hz_utility_pub.CREATION_DATE,
1530: hz_utility_pub.LAST_UPDATE_LOGIN,
1531: hz_utility_pub.LAST_UPDATE_DATE,
1532: hz_utility_pub.LAST_UPDATED_BY
1533: );
1534:
1535: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1536: UPDATE ozf_offers yt SET

Line 1681: hz_utility_pub.CREATED_BY,

1677: NUM_COL3_ORIG_LIST(I),
1678: NUM_COL3_NEW_LIST(I),
1679: 'U',
1680: req_id,
1681: hz_utility_pub.CREATED_BY,
1682: hz_utility_pub.CREATION_DATE,
1683: hz_utility_pub.LAST_UPDATE_LOGIN,
1684: hz_utility_pub.LAST_UPDATE_DATE,
1685: hz_utility_pub.LAST_UPDATED_BY

Line 1682: hz_utility_pub.CREATION_DATE,

1678: NUM_COL3_NEW_LIST(I),
1679: 'U',
1680: req_id,
1681: hz_utility_pub.CREATED_BY,
1682: hz_utility_pub.CREATION_DATE,
1683: hz_utility_pub.LAST_UPDATE_LOGIN,
1684: hz_utility_pub.LAST_UPDATE_DATE,
1685: hz_utility_pub.LAST_UPDATED_BY
1686: );

Line 1683: hz_utility_pub.LAST_UPDATE_LOGIN,

1679: 'U',
1680: req_id,
1681: hz_utility_pub.CREATED_BY,
1682: hz_utility_pub.CREATION_DATE,
1683: hz_utility_pub.LAST_UPDATE_LOGIN,
1684: hz_utility_pub.LAST_UPDATE_DATE,
1685: hz_utility_pub.LAST_UPDATED_BY
1686: );
1687:

Line 1684: hz_utility_pub.LAST_UPDATE_DATE,

1680: req_id,
1681: hz_utility_pub.CREATED_BY,
1682: hz_utility_pub.CREATION_DATE,
1683: hz_utility_pub.LAST_UPDATE_LOGIN,
1684: hz_utility_pub.LAST_UPDATE_DATE,
1685: hz_utility_pub.LAST_UPDATED_BY
1686: );
1687:
1688: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1685: hz_utility_pub.LAST_UPDATED_BY

1681: hz_utility_pub.CREATED_BY,
1682: hz_utility_pub.CREATION_DATE,
1683: hz_utility_pub.LAST_UPDATE_LOGIN,
1684: hz_utility_pub.LAST_UPDATE_DATE,
1685: hz_utility_pub.LAST_UPDATED_BY
1686: );
1687:
1688: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1689: UPDATE ozf_request_headers_all_b yt SET

Line 1827: hz_utility_pub.CREATED_BY,

1823: NUM_COL2_ORIG_LIST(I),
1824: NUM_COL2_NEW_LIST(I),
1825: 'U',
1826: req_id,
1827: hz_utility_pub.CREATED_BY,
1828: hz_utility_pub.CREATION_DATE,
1829: hz_utility_pub.LAST_UPDATE_LOGIN,
1830: hz_utility_pub.LAST_UPDATE_DATE,
1831: hz_utility_pub.LAST_UPDATED_BY

Line 1828: hz_utility_pub.CREATION_DATE,

1824: NUM_COL2_NEW_LIST(I),
1825: 'U',
1826: req_id,
1827: hz_utility_pub.CREATED_BY,
1828: hz_utility_pub.CREATION_DATE,
1829: hz_utility_pub.LAST_UPDATE_LOGIN,
1830: hz_utility_pub.LAST_UPDATE_DATE,
1831: hz_utility_pub.LAST_UPDATED_BY
1832: );

Line 1829: hz_utility_pub.LAST_UPDATE_LOGIN,

1825: 'U',
1826: req_id,
1827: hz_utility_pub.CREATED_BY,
1828: hz_utility_pub.CREATION_DATE,
1829: hz_utility_pub.LAST_UPDATE_LOGIN,
1830: hz_utility_pub.LAST_UPDATE_DATE,
1831: hz_utility_pub.LAST_UPDATED_BY
1832: );
1833:

Line 1830: hz_utility_pub.LAST_UPDATE_DATE,

1826: req_id,
1827: hz_utility_pub.CREATED_BY,
1828: hz_utility_pub.CREATION_DATE,
1829: hz_utility_pub.LAST_UPDATE_LOGIN,
1830: hz_utility_pub.LAST_UPDATE_DATE,
1831: hz_utility_pub.LAST_UPDATED_BY
1832: );
1833:
1834: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1831: hz_utility_pub.LAST_UPDATED_BY

1827: hz_utility_pub.CREATED_BY,
1828: hz_utility_pub.CREATION_DATE,
1829: hz_utility_pub.LAST_UPDATE_LOGIN,
1830: hz_utility_pub.LAST_UPDATE_DATE,
1831: hz_utility_pub.LAST_UPDATED_BY
1832: );
1833:
1834: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1835: UPDATE ozf_retail_price_points yt SET

Line 1967: hz_utility_pub.CREATED_BY,

1963: NUM_COL2_ORIG_LIST(I),
1964: NUM_COL2_NEW_LIST(I),
1965: 'U',
1966: req_id,
1967: hz_utility_pub.CREATED_BY,
1968: hz_utility_pub.CREATION_DATE,
1969: hz_utility_pub.LAST_UPDATE_LOGIN,
1970: hz_utility_pub.LAST_UPDATE_DATE,
1971: hz_utility_pub.LAST_UPDATED_BY

Line 1968: hz_utility_pub.CREATION_DATE,

1964: NUM_COL2_NEW_LIST(I),
1965: 'U',
1966: req_id,
1967: hz_utility_pub.CREATED_BY,
1968: hz_utility_pub.CREATION_DATE,
1969: hz_utility_pub.LAST_UPDATE_LOGIN,
1970: hz_utility_pub.LAST_UPDATE_DATE,
1971: hz_utility_pub.LAST_UPDATED_BY
1972: );

Line 1969: hz_utility_pub.LAST_UPDATE_LOGIN,

1965: 'U',
1966: req_id,
1967: hz_utility_pub.CREATED_BY,
1968: hz_utility_pub.CREATION_DATE,
1969: hz_utility_pub.LAST_UPDATE_LOGIN,
1970: hz_utility_pub.LAST_UPDATE_DATE,
1971: hz_utility_pub.LAST_UPDATED_BY
1972: );
1973:

Line 1970: hz_utility_pub.LAST_UPDATE_DATE,

1966: req_id,
1967: hz_utility_pub.CREATED_BY,
1968: hz_utility_pub.CREATION_DATE,
1969: hz_utility_pub.LAST_UPDATE_LOGIN,
1970: hz_utility_pub.LAST_UPDATE_DATE,
1971: hz_utility_pub.LAST_UPDATED_BY
1972: );
1973:
1974: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 1971: hz_utility_pub.LAST_UPDATED_BY

1967: hz_utility_pub.CREATED_BY,
1968: hz_utility_pub.CREATION_DATE,
1969: hz_utility_pub.LAST_UPDATE_LOGIN,
1970: hz_utility_pub.LAST_UPDATE_DATE,
1971: hz_utility_pub.LAST_UPDATED_BY
1972: );
1973:
1974: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1975: UPDATE ozf_cust_trd_prfls yt SET