APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 700: hz_utility_pub.CREATED_BY,

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);

Line 701: hz_utility_pub.CREATION_DATE,

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;

Line 702: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 703: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 704: hz_utility_pub.LAST_UPDATED_BY);

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

Line 3860: hz_utility_pub.CREATED_BY,

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);

Line 3861: hz_utility_pub.CREATION_DATE,

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;

Line 3862: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 3863: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 3864: hz_utility_pub.LAST_UPDATED_BY);

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

Line 4181: hz_utility_pub.CREATED_BY,

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);

Line 4182: hz_utility_pub.CREATION_DATE,

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:

Line 4183: hz_utility_pub.LAST_UPDATE_LOGIN,

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;

Line 4184: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 4185: hz_utility_pub.LAST_UPDATED_BY);

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

Line 4357: hz_utility_pub.CREATED_BY,

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

Line 4358: hz_utility_pub.CREATION_DATE,

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: );

Line 4359: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 4360: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 4361: hz_utility_pub.LAST_UPDATED_BY

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

Line 4615: hz_utility_pub.CREATED_BY,

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

Line 4616: hz_utility_pub.CREATION_DATE,

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: );

Line 4617: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 4618: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 4619: hz_utility_pub.LAST_UPDATED_BY

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

Line 4892: hz_utility_pub.CREATED_BY,

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

Line 4893: hz_utility_pub.CREATION_DATE,

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: );

Line 4894: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 4895: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 4896: hz_utility_pub.LAST_UPDATED_BY

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

Line 5053: hz_utility_pub.CREATED_BY,

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

Line 5054: hz_utility_pub.CREATION_DATE,

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: );

Line 5055: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5056: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 5057: hz_utility_pub.LAST_UPDATED_BY

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

Line 5181: hz_utility_pub.CREATED_BY,

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

Line 5182: hz_utility_pub.CREATION_DATE,

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: );

Line 5183: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5184: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 5185: hz_utility_pub.LAST_UPDATED_BY

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

Line 5322: hz_utility_pub.CREATED_BY,

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

Line 5323: hz_utility_pub.CREATION_DATE,

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: );

Line 5324: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5325: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 5326: hz_utility_pub.LAST_UPDATED_BY

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

Line 5450: hz_utility_pub.CREATED_BY,

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

Line 5451: hz_utility_pub.CREATION_DATE,

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: );

Line 5452: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5453: hz_utility_pub.LAST_UPDATE_DATE,

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;

Line 5454: hz_utility_pub.LAST_UPDATED_BY

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

Line 5570: hz_utility_pub.CREATED_BY,

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

Line 5571: hz_utility_pub.CREATION_DATE,

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: );

Line 5572: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5573: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 5574: hz_utility_pub.LAST_UPDATED_BY

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

Line 5693: hz_utility_pub.CREATED_BY,

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);

Line 5694: hz_utility_pub.CREATION_DATE,

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;

Line 5695: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5696: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 5697: hz_utility_pub.LAST_UPDATED_BY);

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

Line 5813: hz_utility_pub.CREATED_BY,

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

Line 5814: hz_utility_pub.CREATION_DATE,

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: );

Line 5815: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 5816: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 5817: hz_utility_pub.LAST_UPDATED_BY

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

Line 6366: hz_utility_pub.CREATED_BY,

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);

Line 6367: hz_utility_pub.CREATION_DATE,

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;

Line 6368: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 6369: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 6370: hz_utility_pub.LAST_UPDATED_BY);

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