APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_PARTY_SITE_USES

Line 244: FROM HZ_PARTY_SITE_USES

240: INTO p_party_site_use_rec.COMMENTS
241: , p_party_site_use_rec.SITE_USE_TYPE
242: , p_party_site_use_rec.PRIMARY_PER_TYPE
243: , p_party_site_use_rec.STATUS
244: FROM HZ_PARTY_SITE_USES
245: WHERE PARTY_SITE_USE_ID = p_old_party_site_use_id;
246:
247: p_party_site_use_rec.PARTY_SITE_ID := p_party_site_id;
248: p_party_site_use_rec.created_by_module := 'OKL';

Line 434: , HZ_PARTY_SITE_USES HPSU

430: SELECT HPSUN.PARTY_SITE_USE_ID
431: FROM HZ_PARTY_SITES HPS
432: , HZ_CUST_ACCOUNTS_ALL HCA
433: , HZ_PARTY_SITES HPSN
434: , HZ_PARTY_SITE_USES HPSU
435: , HZ_PARTY_SITE_USES HPSUN
436: WHERE HPSU.PARTY_SITE_USE_ID = l_old_party_site_use_id
437: AND HPS.PARTY_SITE_ID = HPSU.PARTY_SITE_ID
438: AND HCA.CUST_ACCOUNT_ID = l_new_cust_acct_id

Line 435: , HZ_PARTY_SITE_USES HPSUN

431: FROM HZ_PARTY_SITES HPS
432: , HZ_CUST_ACCOUNTS_ALL HCA
433: , HZ_PARTY_SITES HPSN
434: , HZ_PARTY_SITE_USES HPSU
435: , HZ_PARTY_SITE_USES HPSUN
436: WHERE HPSU.PARTY_SITE_USE_ID = l_old_party_site_use_id
437: AND HPS.PARTY_SITE_ID = HPSU.PARTY_SITE_ID
438: AND HCA.CUST_ACCOUNT_ID = l_new_cust_acct_id
439: AND HCA.PARTY_ID = HPSN.PARTY_ID

Line 503: , HZ_PARTY_SITE_USES HPSU

499: , HPS.PARTY_SITE_ID
500: FROM OKL_ASSETS_B ASS
501: , OKL_LEASE_QUOTES_B LSQ
502: , OKL_LEASE_APPLICATIONS_B LAP
503: , HZ_PARTY_SITE_USES HPSU
504: , HZ_PARTY_SITES HPS
505: WHERE ASS.PARENT_OBJECT_CODE = 'LEASEQUOTE'
506: AND LSQ.ID = ASS.PARENT_OBJECT_ID
507: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'

Line 520: , HZ_PARTY_SITE_USES HPSU

516: , HPS.PARTY_SITE_ID
517: FROM OKL_ASSETS_B ASS
518: , OKL_LEASE_QUOTES_B LSQ
519: , OKL_LEASE_OPPORTUNITIES_B LOP
520: , HZ_PARTY_SITE_USES HPSU
521: , HZ_PARTY_SITES HPS
522: WHERE ASS.PARENT_OBJECT_CODE = 'LEASEQUOTE'
523: AND LSQ.ID = ASS.PARENT_OBJECT_ID
524: AND LSQ.PARENT_OBJECT_CODE = 'LEASEOPP'

Line 1566: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES'

1562: begin
1563: arp_message.set_name('AR','AR_UPDATING_TABLE');
1564: arp_message.set_token('TABLE_NAME','OKL_TXL_ITM_INSTS',FALSE);
1565:
1566: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES'
1567: THEN
1568: --updating the OKL_TXL_ITM_INSTS table for column references PROSPECT_ID
1569: UPDATE OKL_TXL_ITM_INSTS TAB
1570: SET TAB.object_id1_new = p_to_fk_id

Line 1921: ELSIF p_parent_entity_name = 'HZ_PARTY_SITE_USES'

1917: , TAB.last_update_date = SYSDATE
1918: , TAB.last_updated_by = arp_standard.profile.user_id
1919: , TAB.last_update_login = arp_standard.profile.last_update_login
1920: WHERE TAB.PROSPECT_ADDRESS_ID = p_from_fk_id ;
1921: ELSIF p_parent_entity_name = 'HZ_PARTY_SITE_USES'
1922: THEN
1923: --updating the OKL_LEASE_OPPS_ALL_B table for column references INSTALL_SITE_ID
1924: UPDATE OKL_LEASE_OPPS_ALL_B TAB
1925: SET TAB.INSTALL_SITE_ID = p_to_fk_id

Line 2020: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES'

2016: begin
2017: arp_message.set_name('AR','AR_UPDATING_TABLE');
2018: arp_message.set_token('TABLE_NAME','OKL_LEASE_OPPS_ALL_B',FALSE);
2019:
2020: IF p_parent_entity_name = 'HZ_PARTY_SITE_USES'
2021: THEN
2022: --updating the OKL_LEASE_OPPS_ALL_B table for column references USAGE_LOCATION_ID
2023: UPDATE OKL_LEASE_OPPS_ALL_B TAB
2024: SET TAB.USAGE_LOCATION_ID = p_to_fk_id

Line 3582: FROM HZ_PARTY_SITE_USES

3578: IS_ID_LIST(I) := GET_NEW_PARTY_SITE_USE(IS_OLD_ID_LIST(I), NUM_COL1_NEW_LIST(I));
3579: IF(IS_ID_LIST(I) IS NULL)
3580: THEN
3581: SELECT PARTY_SITE_ID INTO l_party_site_id
3582: FROM HZ_PARTY_SITE_USES
3583: WHERE PARTY_SITE_USE_ID = IS_OLD_ID_LIST(I);
3584: l_new_party_site_id := GET_NEW_PARTY_SITE(l_party_site_id, NUM_COL1_NEW_LIST(I));
3585: IF(l_new_party_site_id IS NULL)
3586: THEN

Line 3680: FROM HZ_PARTY_SITE_USES

3676: UL_ID_LIST(I) := GET_NEW_PARTY_SITE_USE(UL_OLD_ID_LIST(I), NUM_COL1_NEW_LIST(I));
3677: IF(UL_ID_LIST(I) IS NULL)
3678: THEN
3679: SELECT PARTY_SITE_ID INTO l_party_site_id
3680: FROM HZ_PARTY_SITE_USES
3681: WHERE PARTY_SITE_USE_ID = UL_OLD_ID_LIST(I);
3682: l_new_party_site_id := GET_NEW_PARTY_SITE(l_party_site_id, NUM_COL1_NEW_LIST(I));
3683: IF(l_new_party_site_id IS NULL)
3684: THEN