696: IS_ID_LIST(I),
697: NEW_IS_ID_LIST(I),
698: 'U',
699: req_id,
700: hz_utility_pub.CREATED_BY,
701: hz_utility_pub.CREATION_DATE,
702: hz_utility_pub.LAST_UPDATE_LOGIN,
703: hz_utility_pub.LAST_UPDATE_DATE,
704: hz_utility_pub.LAST_UPDATED_BY);
697: NEW_IS_ID_LIST(I),
698: 'U',
699: req_id,
700: hz_utility_pub.CREATED_BY,
701: hz_utility_pub.CREATION_DATE,
702: hz_utility_pub.LAST_UPDATE_LOGIN,
703: hz_utility_pub.LAST_UPDATE_DATE,
704: hz_utility_pub.LAST_UPDATED_BY);
705: END IF;
698: 'U',
699: req_id,
700: hz_utility_pub.CREATED_BY,
701: hz_utility_pub.CREATION_DATE,
702: hz_utility_pub.LAST_UPDATE_LOGIN,
703: hz_utility_pub.LAST_UPDATE_DATE,
704: hz_utility_pub.LAST_UPDATED_BY);
705: END IF;
706:
699: req_id,
700: hz_utility_pub.CREATED_BY,
701: hz_utility_pub.CREATION_DATE,
702: hz_utility_pub.LAST_UPDATE_LOGIN,
703: hz_utility_pub.LAST_UPDATE_DATE,
704: hz_utility_pub.LAST_UPDATED_BY);
705: END IF;
706:
707: FORALL I IN 1..ASSET_ID_LIST.COUNT
700: hz_utility_pub.CREATED_BY,
701: hz_utility_pub.CREATION_DATE,
702: hz_utility_pub.LAST_UPDATE_LOGIN,
703: hz_utility_pub.LAST_UPDATE_DATE,
704: hz_utility_pub.LAST_UPDATED_BY);
705: END IF;
706:
707: FORALL I IN 1..ASSET_ID_LIST.COUNT
708: UPDATE OKL_ASSETS_B SET
3856: UL_OLD_ID_LIST(I),
3857: UL_ID_LIST(I),
3858: 'U',
3859: req_id,
3860: hz_utility_pub.CREATED_BY,
3861: hz_utility_pub.CREATION_DATE,
3862: hz_utility_pub.LAST_UPDATE_LOGIN,
3863: hz_utility_pub.LAST_UPDATE_DATE,
3864: hz_utility_pub.LAST_UPDATED_BY);
3857: UL_ID_LIST(I),
3858: 'U',
3859: req_id,
3860: hz_utility_pub.CREATED_BY,
3861: hz_utility_pub.CREATION_DATE,
3862: hz_utility_pub.LAST_UPDATE_LOGIN,
3863: hz_utility_pub.LAST_UPDATE_DATE,
3864: hz_utility_pub.LAST_UPDATED_BY);
3865: END IF;
3858: 'U',
3859: req_id,
3860: hz_utility_pub.CREATED_BY,
3861: hz_utility_pub.CREATION_DATE,
3862: hz_utility_pub.LAST_UPDATE_LOGIN,
3863: hz_utility_pub.LAST_UPDATE_DATE,
3864: hz_utility_pub.LAST_UPDATED_BY);
3865: END IF;
3866:
3859: req_id,
3860: hz_utility_pub.CREATED_BY,
3861: hz_utility_pub.CREATION_DATE,
3862: hz_utility_pub.LAST_UPDATE_LOGIN,
3863: hz_utility_pub.LAST_UPDATE_DATE,
3864: hz_utility_pub.LAST_UPDATED_BY);
3865: END IF;
3866:
3867: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3860: hz_utility_pub.CREATED_BY,
3861: hz_utility_pub.CREATION_DATE,
3862: hz_utility_pub.LAST_UPDATE_LOGIN,
3863: hz_utility_pub.LAST_UPDATE_DATE,
3864: hz_utility_pub.LAST_UPDATED_BY);
3865: END IF;
3866:
3867: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3868: UPDATE OKL_LEASE_OPPORTUNITIES_B yt SET
4177: PROSPECT_ADD_OLD_ID_LIST(I),
4178: PROSPECT_ADDRESS_ID_LIST(I),
4179: 'U',
4180: req_id,
4181: hz_utility_pub.CREATED_BY,
4182: hz_utility_pub.CREATION_DATE,
4183: hz_utility_pub.LAST_UPDATE_LOGIN,
4184: hz_utility_pub.LAST_UPDATE_DATE,
4185: hz_utility_pub.LAST_UPDATED_BY);
4178: PROSPECT_ADDRESS_ID_LIST(I),
4179: 'U',
4180: req_id,
4181: hz_utility_pub.CREATED_BY,
4182: hz_utility_pub.CREATION_DATE,
4183: hz_utility_pub.LAST_UPDATE_LOGIN,
4184: hz_utility_pub.LAST_UPDATE_DATE,
4185: hz_utility_pub.LAST_UPDATED_BY);
4186:
4179: 'U',
4180: req_id,
4181: hz_utility_pub.CREATED_BY,
4182: hz_utility_pub.CREATION_DATE,
4183: hz_utility_pub.LAST_UPDATE_LOGIN,
4184: hz_utility_pub.LAST_UPDATE_DATE,
4185: hz_utility_pub.LAST_UPDATED_BY);
4186:
4187: END IF;
4180: req_id,
4181: hz_utility_pub.CREATED_BY,
4182: hz_utility_pub.CREATION_DATE,
4183: hz_utility_pub.LAST_UPDATE_LOGIN,
4184: hz_utility_pub.LAST_UPDATE_DATE,
4185: hz_utility_pub.LAST_UPDATED_BY);
4186:
4187: END IF;
4188: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4181: hz_utility_pub.CREATED_BY,
4182: hz_utility_pub.CREATION_DATE,
4183: hz_utility_pub.LAST_UPDATE_LOGIN,
4184: hz_utility_pub.LAST_UPDATE_DATE,
4185: hz_utility_pub.LAST_UPDATED_BY);
4186:
4187: END IF;
4188: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4189: UPDATE OKL_LEASE_APPLICATIONS_B yt SET
4353: NUM_COL2_ORIG_LIST(I),
4354: NUM_COL2_NEW_LIST(I),
4355: 'U',
4356: req_id,
4357: hz_utility_pub.CREATED_BY,
4358: hz_utility_pub.CREATION_DATE,
4359: hz_utility_pub.LAST_UPDATE_LOGIN,
4360: hz_utility_pub.LAST_UPDATE_DATE,
4361: hz_utility_pub.LAST_UPDATED_BY
4354: NUM_COL2_NEW_LIST(I),
4355: 'U',
4356: req_id,
4357: hz_utility_pub.CREATED_BY,
4358: hz_utility_pub.CREATION_DATE,
4359: hz_utility_pub.LAST_UPDATE_LOGIN,
4360: hz_utility_pub.LAST_UPDATE_DATE,
4361: hz_utility_pub.LAST_UPDATED_BY
4362: );
4355: 'U',
4356: req_id,
4357: hz_utility_pub.CREATED_BY,
4358: hz_utility_pub.CREATION_DATE,
4359: hz_utility_pub.LAST_UPDATE_LOGIN,
4360: hz_utility_pub.LAST_UPDATE_DATE,
4361: hz_utility_pub.LAST_UPDATED_BY
4362: );
4363:
4356: req_id,
4357: hz_utility_pub.CREATED_BY,
4358: hz_utility_pub.CREATION_DATE,
4359: hz_utility_pub.LAST_UPDATE_LOGIN,
4360: hz_utility_pub.LAST_UPDATE_DATE,
4361: hz_utility_pub.LAST_UPDATED_BY
4362: );
4363:
4364: END IF;
4357: hz_utility_pub.CREATED_BY,
4358: hz_utility_pub.CREATION_DATE,
4359: hz_utility_pub.LAST_UPDATE_LOGIN,
4360: hz_utility_pub.LAST_UPDATE_DATE,
4361: hz_utility_pub.LAST_UPDATED_BY
4362: );
4363:
4364: END IF;
4365: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4611: ST_LOC_ID_ORIG_LIST(I),
4612: ST_LOC_ID_NEW_LIST(I),
4613: 'U',
4614: req_id,
4615: hz_utility_pub.CREATED_BY,
4616: hz_utility_pub.CREATION_DATE,
4617: hz_utility_pub.LAST_UPDATE_LOGIN,
4618: hz_utility_pub.LAST_UPDATE_DATE,
4619: hz_utility_pub.LAST_UPDATED_BY
4612: ST_LOC_ID_NEW_LIST(I),
4613: 'U',
4614: req_id,
4615: hz_utility_pub.CREATED_BY,
4616: hz_utility_pub.CREATION_DATE,
4617: hz_utility_pub.LAST_UPDATE_LOGIN,
4618: hz_utility_pub.LAST_UPDATE_DATE,
4619: hz_utility_pub.LAST_UPDATED_BY
4620: );
4613: 'U',
4614: req_id,
4615: hz_utility_pub.CREATED_BY,
4616: hz_utility_pub.CREATION_DATE,
4617: hz_utility_pub.LAST_UPDATE_LOGIN,
4618: hz_utility_pub.LAST_UPDATE_DATE,
4619: hz_utility_pub.LAST_UPDATED_BY
4620: );
4621:
4614: req_id,
4615: hz_utility_pub.CREATED_BY,
4616: hz_utility_pub.CREATION_DATE,
4617: hz_utility_pub.LAST_UPDATE_LOGIN,
4618: hz_utility_pub.LAST_UPDATE_DATE,
4619: hz_utility_pub.LAST_UPDATED_BY
4620: );
4621:
4622: END IF;
4615: hz_utility_pub.CREATED_BY,
4616: hz_utility_pub.CREATION_DATE,
4617: hz_utility_pub.LAST_UPDATE_LOGIN,
4618: hz_utility_pub.LAST_UPDATE_DATE,
4619: hz_utility_pub.LAST_UPDATED_BY
4620: );
4621:
4622: END IF;
4623: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
4888: ST_LOC_ID_ORIG_LIST(I),
4889: ST_LOC_ID_NEW_LIST(I),
4890: 'U',
4891: req_id,
4892: hz_utility_pub.CREATED_BY,
4893: hz_utility_pub.CREATION_DATE,
4894: hz_utility_pub.LAST_UPDATE_LOGIN,
4895: hz_utility_pub.LAST_UPDATE_DATE,
4896: hz_utility_pub.LAST_UPDATED_BY
4889: ST_LOC_ID_NEW_LIST(I),
4890: 'U',
4891: req_id,
4892: hz_utility_pub.CREATED_BY,
4893: hz_utility_pub.CREATION_DATE,
4894: hz_utility_pub.LAST_UPDATE_LOGIN,
4895: hz_utility_pub.LAST_UPDATE_DATE,
4896: hz_utility_pub.LAST_UPDATED_BY
4897: );
4890: 'U',
4891: req_id,
4892: hz_utility_pub.CREATED_BY,
4893: hz_utility_pub.CREATION_DATE,
4894: hz_utility_pub.LAST_UPDATE_LOGIN,
4895: hz_utility_pub.LAST_UPDATE_DATE,
4896: hz_utility_pub.LAST_UPDATED_BY
4897: );
4898:
4891: req_id,
4892: hz_utility_pub.CREATED_BY,
4893: hz_utility_pub.CREATION_DATE,
4894: hz_utility_pub.LAST_UPDATE_LOGIN,
4895: hz_utility_pub.LAST_UPDATE_DATE,
4896: hz_utility_pub.LAST_UPDATED_BY
4897: );
4898:
4899: END IF;
4892: hz_utility_pub.CREATED_BY,
4893: hz_utility_pub.CREATION_DATE,
4894: hz_utility_pub.LAST_UPDATE_LOGIN,
4895: hz_utility_pub.LAST_UPDATE_DATE,
4896: hz_utility_pub.LAST_UPDATED_BY
4897: );
4898:
4899: END IF;
4900: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5049: NUM_COL2_ORIG_LIST(I),
5050: NUM_COL2_NEW_LIST(I),
5051: 'U',
5052: req_id,
5053: hz_utility_pub.CREATED_BY,
5054: hz_utility_pub.CREATION_DATE,
5055: hz_utility_pub.LAST_UPDATE_LOGIN,
5056: hz_utility_pub.LAST_UPDATE_DATE,
5057: hz_utility_pub.LAST_UPDATED_BY
5050: NUM_COL2_NEW_LIST(I),
5051: 'U',
5052: req_id,
5053: hz_utility_pub.CREATED_BY,
5054: hz_utility_pub.CREATION_DATE,
5055: hz_utility_pub.LAST_UPDATE_LOGIN,
5056: hz_utility_pub.LAST_UPDATE_DATE,
5057: hz_utility_pub.LAST_UPDATED_BY
5058: );
5051: 'U',
5052: req_id,
5053: hz_utility_pub.CREATED_BY,
5054: hz_utility_pub.CREATION_DATE,
5055: hz_utility_pub.LAST_UPDATE_LOGIN,
5056: hz_utility_pub.LAST_UPDATE_DATE,
5057: hz_utility_pub.LAST_UPDATED_BY
5058: );
5059:
5052: req_id,
5053: hz_utility_pub.CREATED_BY,
5054: hz_utility_pub.CREATION_DATE,
5055: hz_utility_pub.LAST_UPDATE_LOGIN,
5056: hz_utility_pub.LAST_UPDATE_DATE,
5057: hz_utility_pub.LAST_UPDATED_BY
5058: );
5059:
5060: END IF;
5053: hz_utility_pub.CREATED_BY,
5054: hz_utility_pub.CREATION_DATE,
5055: hz_utility_pub.LAST_UPDATE_LOGIN,
5056: hz_utility_pub.LAST_UPDATE_DATE,
5057: hz_utility_pub.LAST_UPDATED_BY
5058: );
5059:
5060: END IF;
5061: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5177: NUM_COL1_ORIG_LIST(I),
5178: NUM_COL1_NEW_LIST(I),
5179: 'U',
5180: req_id,
5181: hz_utility_pub.CREATED_BY,
5182: hz_utility_pub.CREATION_DATE,
5183: hz_utility_pub.LAST_UPDATE_LOGIN,
5184: hz_utility_pub.LAST_UPDATE_DATE,
5185: hz_utility_pub.LAST_UPDATED_BY
5178: NUM_COL1_NEW_LIST(I),
5179: 'U',
5180: req_id,
5181: hz_utility_pub.CREATED_BY,
5182: hz_utility_pub.CREATION_DATE,
5183: hz_utility_pub.LAST_UPDATE_LOGIN,
5184: hz_utility_pub.LAST_UPDATE_DATE,
5185: hz_utility_pub.LAST_UPDATED_BY
5186: );
5179: 'U',
5180: req_id,
5181: hz_utility_pub.CREATED_BY,
5182: hz_utility_pub.CREATION_DATE,
5183: hz_utility_pub.LAST_UPDATE_LOGIN,
5184: hz_utility_pub.LAST_UPDATE_DATE,
5185: hz_utility_pub.LAST_UPDATED_BY
5186: );
5187:
5180: req_id,
5181: hz_utility_pub.CREATED_BY,
5182: hz_utility_pub.CREATION_DATE,
5183: hz_utility_pub.LAST_UPDATE_LOGIN,
5184: hz_utility_pub.LAST_UPDATE_DATE,
5185: hz_utility_pub.LAST_UPDATED_BY
5186: );
5187:
5188: END IF;
5181: hz_utility_pub.CREATED_BY,
5182: hz_utility_pub.CREATION_DATE,
5183: hz_utility_pub.LAST_UPDATE_LOGIN,
5184: hz_utility_pub.LAST_UPDATE_DATE,
5185: hz_utility_pub.LAST_UPDATED_BY
5186: );
5187:
5188: END IF;
5189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5318: NUM_COL2_ORIG_LIST(I),
5319: NUM_COL2_NEW_LIST(I),
5320: 'U',
5321: req_id,
5322: hz_utility_pub.CREATED_BY,
5323: hz_utility_pub.CREATION_DATE,
5324: hz_utility_pub.LAST_UPDATE_LOGIN,
5325: hz_utility_pub.LAST_UPDATE_DATE,
5326: hz_utility_pub.LAST_UPDATED_BY
5319: NUM_COL2_NEW_LIST(I),
5320: 'U',
5321: req_id,
5322: hz_utility_pub.CREATED_BY,
5323: hz_utility_pub.CREATION_DATE,
5324: hz_utility_pub.LAST_UPDATE_LOGIN,
5325: hz_utility_pub.LAST_UPDATE_DATE,
5326: hz_utility_pub.LAST_UPDATED_BY
5327: );
5320: 'U',
5321: req_id,
5322: hz_utility_pub.CREATED_BY,
5323: hz_utility_pub.CREATION_DATE,
5324: hz_utility_pub.LAST_UPDATE_LOGIN,
5325: hz_utility_pub.LAST_UPDATE_DATE,
5326: hz_utility_pub.LAST_UPDATED_BY
5327: );
5328:
5321: req_id,
5322: hz_utility_pub.CREATED_BY,
5323: hz_utility_pub.CREATION_DATE,
5324: hz_utility_pub.LAST_UPDATE_LOGIN,
5325: hz_utility_pub.LAST_UPDATE_DATE,
5326: hz_utility_pub.LAST_UPDATED_BY
5327: );
5328:
5329: END IF;
5322: hz_utility_pub.CREATED_BY,
5323: hz_utility_pub.CREATION_DATE,
5324: hz_utility_pub.LAST_UPDATE_LOGIN,
5325: hz_utility_pub.LAST_UPDATE_DATE,
5326: hz_utility_pub.LAST_UPDATED_BY
5327: );
5328:
5329: END IF;
5330: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5446: NUM_COL1_ORIG_LIST(I),
5447: NUM_COL1_NEW_LIST(I),
5448: 'U',
5449: req_id,
5450: hz_utility_pub.CREATED_BY,
5451: hz_utility_pub.CREATION_DATE,
5452: hz_utility_pub.LAST_UPDATE_LOGIN,
5453: hz_utility_pub.LAST_UPDATE_DATE,
5454: hz_utility_pub.LAST_UPDATED_BY
5447: NUM_COL1_NEW_LIST(I),
5448: 'U',
5449: req_id,
5450: hz_utility_pub.CREATED_BY,
5451: hz_utility_pub.CREATION_DATE,
5452: hz_utility_pub.LAST_UPDATE_LOGIN,
5453: hz_utility_pub.LAST_UPDATE_DATE,
5454: hz_utility_pub.LAST_UPDATED_BY
5455: );
5448: 'U',
5449: req_id,
5450: hz_utility_pub.CREATED_BY,
5451: hz_utility_pub.CREATION_DATE,
5452: hz_utility_pub.LAST_UPDATE_LOGIN,
5453: hz_utility_pub.LAST_UPDATE_DATE,
5454: hz_utility_pub.LAST_UPDATED_BY
5455: );
5456:
5449: req_id,
5450: hz_utility_pub.CREATED_BY,
5451: hz_utility_pub.CREATION_DATE,
5452: hz_utility_pub.LAST_UPDATE_LOGIN,
5453: hz_utility_pub.LAST_UPDATE_DATE,
5454: hz_utility_pub.LAST_UPDATED_BY
5455: );
5456:
5457: END IF;
5450: hz_utility_pub.CREATED_BY,
5451: hz_utility_pub.CREATION_DATE,
5452: hz_utility_pub.LAST_UPDATE_LOGIN,
5453: hz_utility_pub.LAST_UPDATE_DATE,
5454: hz_utility_pub.LAST_UPDATED_BY
5455: );
5456:
5457: END IF;
5458: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5566: NUM_COL1_ORIG_LIST(I),
5567: NUM_COL1_NEW_LIST(I),
5568: 'U',
5569: req_id,
5570: hz_utility_pub.CREATED_BY,
5571: hz_utility_pub.CREATION_DATE,
5572: hz_utility_pub.LAST_UPDATE_LOGIN,
5573: hz_utility_pub.LAST_UPDATE_DATE,
5574: hz_utility_pub.LAST_UPDATED_BY
5567: NUM_COL1_NEW_LIST(I),
5568: 'U',
5569: req_id,
5570: hz_utility_pub.CREATED_BY,
5571: hz_utility_pub.CREATION_DATE,
5572: hz_utility_pub.LAST_UPDATE_LOGIN,
5573: hz_utility_pub.LAST_UPDATE_DATE,
5574: hz_utility_pub.LAST_UPDATED_BY
5575: );
5568: 'U',
5569: req_id,
5570: hz_utility_pub.CREATED_BY,
5571: hz_utility_pub.CREATION_DATE,
5572: hz_utility_pub.LAST_UPDATE_LOGIN,
5573: hz_utility_pub.LAST_UPDATE_DATE,
5574: hz_utility_pub.LAST_UPDATED_BY
5575: );
5576:
5569: req_id,
5570: hz_utility_pub.CREATED_BY,
5571: hz_utility_pub.CREATION_DATE,
5572: hz_utility_pub.LAST_UPDATE_LOGIN,
5573: hz_utility_pub.LAST_UPDATE_DATE,
5574: hz_utility_pub.LAST_UPDATED_BY
5575: );
5576:
5577: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5570: hz_utility_pub.CREATED_BY,
5571: hz_utility_pub.CREATION_DATE,
5572: hz_utility_pub.LAST_UPDATE_LOGIN,
5573: hz_utility_pub.LAST_UPDATE_DATE,
5574: hz_utility_pub.LAST_UPDATED_BY
5575: );
5576:
5577: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5578: UPDATE OKL_ACCT_SOURCES yt SET
5689: NUM_COL1_ORIG_LIST(I),
5690: NUM_COL1_NEW_LIST(I),
5691: 'U',
5692: req_id,
5693: hz_utility_pub.CREATED_BY,
5694: hz_utility_pub.CREATION_DATE,
5695: hz_utility_pub.LAST_UPDATE_LOGIN,
5696: hz_utility_pub.LAST_UPDATE_DATE,
5697: hz_utility_pub.LAST_UPDATED_BY);
5690: NUM_COL1_NEW_LIST(I),
5691: 'U',
5692: req_id,
5693: hz_utility_pub.CREATED_BY,
5694: hz_utility_pub.CREATION_DATE,
5695: hz_utility_pub.LAST_UPDATE_LOGIN,
5696: hz_utility_pub.LAST_UPDATE_DATE,
5697: hz_utility_pub.LAST_UPDATED_BY);
5698: END IF;
5691: 'U',
5692: req_id,
5693: hz_utility_pub.CREATED_BY,
5694: hz_utility_pub.CREATION_DATE,
5695: hz_utility_pub.LAST_UPDATE_LOGIN,
5696: hz_utility_pub.LAST_UPDATE_DATE,
5697: hz_utility_pub.LAST_UPDATED_BY);
5698: END IF;
5699:
5692: req_id,
5693: hz_utility_pub.CREATED_BY,
5694: hz_utility_pub.CREATION_DATE,
5695: hz_utility_pub.LAST_UPDATE_LOGIN,
5696: hz_utility_pub.LAST_UPDATE_DATE,
5697: hz_utility_pub.LAST_UPDATED_BY);
5698: END IF;
5699:
5700: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5693: hz_utility_pub.CREATED_BY,
5694: hz_utility_pub.CREATION_DATE,
5695: hz_utility_pub.LAST_UPDATE_LOGIN,
5696: hz_utility_pub.LAST_UPDATE_DATE,
5697: hz_utility_pub.LAST_UPDATED_BY);
5698: END IF;
5699:
5700: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5701: UPDATE OKL_SUPP_INVOICE_DTLS yt SET
5809: NUM_COL1_ORIG_LIST(I),
5810: NUM_COL1_NEW_LIST(I),
5811: 'U',
5812: req_id,
5813: hz_utility_pub.CREATED_BY,
5814: hz_utility_pub.CREATION_DATE,
5815: hz_utility_pub.LAST_UPDATE_LOGIN,
5816: hz_utility_pub.LAST_UPDATE_DATE,
5817: hz_utility_pub.LAST_UPDATED_BY
5810: NUM_COL1_NEW_LIST(I),
5811: 'U',
5812: req_id,
5813: hz_utility_pub.CREATED_BY,
5814: hz_utility_pub.CREATION_DATE,
5815: hz_utility_pub.LAST_UPDATE_LOGIN,
5816: hz_utility_pub.LAST_UPDATE_DATE,
5817: hz_utility_pub.LAST_UPDATED_BY
5818: );
5811: 'U',
5812: req_id,
5813: hz_utility_pub.CREATED_BY,
5814: hz_utility_pub.CREATION_DATE,
5815: hz_utility_pub.LAST_UPDATE_LOGIN,
5816: hz_utility_pub.LAST_UPDATE_DATE,
5817: hz_utility_pub.LAST_UPDATED_BY
5818: );
5819:
5812: req_id,
5813: hz_utility_pub.CREATED_BY,
5814: hz_utility_pub.CREATION_DATE,
5815: hz_utility_pub.LAST_UPDATE_LOGIN,
5816: hz_utility_pub.LAST_UPDATE_DATE,
5817: hz_utility_pub.LAST_UPDATED_BY
5818: );
5819:
5820: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5813: hz_utility_pub.CREATED_BY,
5814: hz_utility_pub.CREATION_DATE,
5815: hz_utility_pub.LAST_UPDATE_LOGIN,
5816: hz_utility_pub.LAST_UPDATE_DATE,
5817: hz_utility_pub.LAST_UPDATED_BY
5818: );
5819:
5820: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
5821: UPDATE OKL_SUPP_INVOICE_DTLS_H yt SET
6362: NUM_RUL_OBJ1_ORIG_LIST(I),
6363: NUM_RUL_OBJ1_NEW_LIST(I),
6364: 'U',
6365: req_id,
6366: hz_utility_pub.CREATED_BY,
6367: hz_utility_pub.CREATION_DATE,
6368: hz_utility_pub.LAST_UPDATE_LOGIN,
6369: hz_utility_pub.LAST_UPDATE_DATE,
6370: hz_utility_pub.LAST_UPDATED_BY);
6363: NUM_RUL_OBJ1_NEW_LIST(I),
6364: 'U',
6365: req_id,
6366: hz_utility_pub.CREATED_BY,
6367: hz_utility_pub.CREATION_DATE,
6368: hz_utility_pub.LAST_UPDATE_LOGIN,
6369: hz_utility_pub.LAST_UPDATE_DATE,
6370: hz_utility_pub.LAST_UPDATED_BY);
6371: END IF;
6364: 'U',
6365: req_id,
6366: hz_utility_pub.CREATED_BY,
6367: hz_utility_pub.CREATION_DATE,
6368: hz_utility_pub.LAST_UPDATE_LOGIN,
6369: hz_utility_pub.LAST_UPDATE_DATE,
6370: hz_utility_pub.LAST_UPDATED_BY);
6371: END IF;
6372:
6365: req_id,
6366: hz_utility_pub.CREATED_BY,
6367: hz_utility_pub.CREATION_DATE,
6368: hz_utility_pub.LAST_UPDATE_LOGIN,
6369: hz_utility_pub.LAST_UPDATE_DATE,
6370: hz_utility_pub.LAST_UPDATED_BY);
6371: END IF;
6372:
6373: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
6366: hz_utility_pub.CREATED_BY,
6367: hz_utility_pub.CREATION_DATE,
6368: hz_utility_pub.LAST_UPDATE_LOGIN,
6369: hz_utility_pub.LAST_UPDATE_DATE,
6370: hz_utility_pub.LAST_UPDATED_BY);
6371: END IF;
6372:
6373: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
6374: UPDATE OKC_RULES_B yt SET