109: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
110: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
110: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF;
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF;
121:
338: NUM_COL1_ORIG_LIST(I), NUM_COL1_NEW_LIST(I),
339: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
340: 'U',
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
339: NUM_COL2_ORIG_LIST(I), NUM_COL2_NEW_LIST(I),
340: 'U',
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
340: 'U',
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
348:
341: req_id,
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
348:
349: END IF;
342: hz_utility_pub.CREATED_BY,
343: hz_utility_pub.CREATION_DATE,
344: hz_utility_pub.LAST_UPDATE_LOGIN,
345: hz_utility_pub.LAST_UPDATE_DATE,
346: hz_utility_pub.LAST_UPDATED_BY
347: );
348:
349: END IF;
350:
415: PARTY_ID_LIST(I),
416: COLLECTOR_ID_LIST(I),
417: 'D',
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
416: COLLECTOR_ID_LIST(I),
417: 'D',
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
417: 'D',
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
425:
418: req_id,
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
425:
426: END IF;
419: hz_utility_pub.CREATED_BY,
420: hz_utility_pub.CREATION_DATE,
421: hz_utility_pub.LAST_UPDATE_LOGIN,
422: hz_utility_pub.LAST_UPDATE_DATE,
423: hz_utility_pub.LAST_UPDATED_BY
424: );
425:
426: END IF;
427:
550: Account_Owner_Party_ID_List(i),
551: Parent_Party_ID_List(i),
552: 'D',
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
551: Parent_Party_ID_List(i),
552: 'D',
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
552: 'D',
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:
553: Req_ID,
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:
561: FORALL i in 1..Merge_Header_ID_List.Count
554: HZ_Utility_Pub.CREATED_BY,
555: HZ_Utility_Pub.CREATION_DATE,
556: HZ_Utility_Pub.LAST_UPDATE_LOGIN,
557: HZ_Utility_Pub.LAST_UPDATE_DATE,
558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:
561: FORALL i in 1..Merge_Header_ID_List.Count
562: DELETE FROM FII_Cust_Accounts