126: NUM_COL3_ORIG_LIST(I),
127: NUM_COL3_NEW_LIST(I),
128: 'U',
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
127: NUM_COL3_NEW_LIST(I),
128: 'U',
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
128: 'U',
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
137: END IF;
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
137: END IF;
138: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
295: NUM_COL3_ORIG_LIST(I),
296: NUM_COL3_NEW_LIST(I),
297: 'U',
298: req_id,
299: hz_utility_pub.CREATED_BY,
300: hz_utility_pub.CREATION_DATE,
301: hz_utility_pub.LAST_UPDATE_LOGIN,
302: hz_utility_pub.LAST_UPDATE_DATE,
303: hz_utility_pub.LAST_UPDATED_BY
296: NUM_COL3_NEW_LIST(I),
297: 'U',
298: req_id,
299: hz_utility_pub.CREATED_BY,
300: hz_utility_pub.CREATION_DATE,
301: hz_utility_pub.LAST_UPDATE_LOGIN,
302: hz_utility_pub.LAST_UPDATE_DATE,
303: hz_utility_pub.LAST_UPDATED_BY
304: );
297: 'U',
298: req_id,
299: hz_utility_pub.CREATED_BY,
300: hz_utility_pub.CREATION_DATE,
301: hz_utility_pub.LAST_UPDATE_LOGIN,
302: hz_utility_pub.LAST_UPDATE_DATE,
303: hz_utility_pub.LAST_UPDATED_BY
304: );
305:
298: req_id,
299: hz_utility_pub.CREATED_BY,
300: hz_utility_pub.CREATION_DATE,
301: hz_utility_pub.LAST_UPDATE_LOGIN,
302: hz_utility_pub.LAST_UPDATE_DATE,
303: hz_utility_pub.LAST_UPDATED_BY
304: );
305:
306: END IF;
299: hz_utility_pub.CREATED_BY,
300: hz_utility_pub.CREATION_DATE,
301: hz_utility_pub.LAST_UPDATE_LOGIN,
302: hz_utility_pub.LAST_UPDATE_DATE,
303: hz_utility_pub.LAST_UPDATED_BY
304: );
305:
306: END IF;
307: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
457: NUM_COL3_ORIG_LIST(I),
458: NUM_COL3_NEW_LIST(I),
459: 'U',
460: req_id,
461: hz_utility_pub.CREATED_BY,
462: hz_utility_pub.CREATION_DATE,
463: hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,
465: hz_utility_pub.LAST_UPDATED_BY
458: NUM_COL3_NEW_LIST(I),
459: 'U',
460: req_id,
461: hz_utility_pub.CREATED_BY,
462: hz_utility_pub.CREATION_DATE,
463: hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,
465: hz_utility_pub.LAST_UPDATED_BY
466: );
459: 'U',
460: req_id,
461: hz_utility_pub.CREATED_BY,
462: hz_utility_pub.CREATION_DATE,
463: hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,
465: hz_utility_pub.LAST_UPDATED_BY
466: );
467:
460: req_id,
461: hz_utility_pub.CREATED_BY,
462: hz_utility_pub.CREATION_DATE,
463: hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,
465: hz_utility_pub.LAST_UPDATED_BY
466: );
467:
468: END IF;
461: hz_utility_pub.CREATED_BY,
462: hz_utility_pub.CREATION_DATE,
463: hz_utility_pub.LAST_UPDATE_LOGIN,
464: hz_utility_pub.LAST_UPDATE_DATE,
465: hz_utility_pub.LAST_UPDATED_BY
466: );
467:
468: END IF;
469: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
662: NUM_COL6_ORIG_LIST(I),
663: NUM_COL6_NEW_LIST(I),
664: 'U',
665: req_id,
666: hz_utility_pub.CREATED_BY,
667: hz_utility_pub.CREATION_DATE,
668: hz_utility_pub.LAST_UPDATE_LOGIN,
669: hz_utility_pub.LAST_UPDATE_DATE,
670: hz_utility_pub.LAST_UPDATED_BY
663: NUM_COL6_NEW_LIST(I),
664: 'U',
665: req_id,
666: hz_utility_pub.CREATED_BY,
667: hz_utility_pub.CREATION_DATE,
668: hz_utility_pub.LAST_UPDATE_LOGIN,
669: hz_utility_pub.LAST_UPDATE_DATE,
670: hz_utility_pub.LAST_UPDATED_BY
671: );
664: 'U',
665: req_id,
666: hz_utility_pub.CREATED_BY,
667: hz_utility_pub.CREATION_DATE,
668: hz_utility_pub.LAST_UPDATE_LOGIN,
669: hz_utility_pub.LAST_UPDATE_DATE,
670: hz_utility_pub.LAST_UPDATED_BY
671: );
672:
665: req_id,
666: hz_utility_pub.CREATED_BY,
667: hz_utility_pub.CREATION_DATE,
668: hz_utility_pub.LAST_UPDATE_LOGIN,
669: hz_utility_pub.LAST_UPDATE_DATE,
670: hz_utility_pub.LAST_UPDATED_BY
671: );
672:
673: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
666: hz_utility_pub.CREATED_BY,
667: hz_utility_pub.CREATION_DATE,
668: hz_utility_pub.LAST_UPDATE_LOGIN,
669: hz_utility_pub.LAST_UPDATE_DATE,
670: hz_utility_pub.LAST_UPDATED_BY
671: );
672:
673: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
674: UPDATE MRP_SALES_ORDER_UPDATES yt SET
810: NUM_COL2_ORIG_LIST(I),
811: NUM_COL2_NEW_LIST(I),
812: 'U',
813: req_id,
814: hz_utility_pub.CREATED_BY,
815: hz_utility_pub.CREATION_DATE,
816: hz_utility_pub.LAST_UPDATE_LOGIN,
817: hz_utility_pub.LAST_UPDATE_DATE,
818: hz_utility_pub.LAST_UPDATED_BY
811: NUM_COL2_NEW_LIST(I),
812: 'U',
813: req_id,
814: hz_utility_pub.CREATED_BY,
815: hz_utility_pub.CREATION_DATE,
816: hz_utility_pub.LAST_UPDATE_LOGIN,
817: hz_utility_pub.LAST_UPDATE_DATE,
818: hz_utility_pub.LAST_UPDATED_BY
819: );
812: 'U',
813: req_id,
814: hz_utility_pub.CREATED_BY,
815: hz_utility_pub.CREATION_DATE,
816: hz_utility_pub.LAST_UPDATE_LOGIN,
817: hz_utility_pub.LAST_UPDATE_DATE,
818: hz_utility_pub.LAST_UPDATED_BY
819: );
820:
813: req_id,
814: hz_utility_pub.CREATED_BY,
815: hz_utility_pub.CREATION_DATE,
816: hz_utility_pub.LAST_UPDATE_LOGIN,
817: hz_utility_pub.LAST_UPDATE_DATE,
818: hz_utility_pub.LAST_UPDATED_BY
819: );
820:
821: END IF;
814: hz_utility_pub.CREATED_BY,
815: hz_utility_pub.CREATION_DATE,
816: hz_utility_pub.LAST_UPDATE_LOGIN,
817: hz_utility_pub.LAST_UPDATE_DATE,
818: hz_utility_pub.LAST_UPDATED_BY
819: );
820:
821: END IF;
822: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT