eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PARTY_MERGE_PUB dependencies on HZ_PARTY_SITES

Line 38: x_party_site_number hz_party_sites.party_site_number%TYPE;

34: IS
35: l_api_name VARCHAR2(30) := 'CREATE_PARTY_SITE';
36: l_return_status VARCHAR2(1);
37:
38: x_party_site_number hz_party_sites.party_site_number%TYPE;
39: p_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
40: l_prof_value VARCHAR2(1);
41: BEGIN
42: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 81: FROM hz_party_sites

77: , p_party_site_rec.party_site_name
78: , p_party_site_rec.language
79: , p_party_site_rec.addressee
80: , p_party_site_rec.global_location_number
81: FROM hz_party_sites
82: WHERE party_site_id = p_old_party_site_id;
83:
84: --Obtain the Party of the given Customer Account
85: SELECT PARTY_ID INTO p_party_site_rec.party_id

Line 394: FROM HZ_PARTY_SITES HPS

390: AS
391: new_party_site_id NUMBER;
392: CURSOR new_party_site_csr(l_old_party_site_id NUMBER, l_new_cust_acct_id NUMBER) IS
393: SELECT HPSN.PARTY_SITE_ID
394: FROM HZ_PARTY_SITES HPS
395: , HZ_CUST_ACCOUNTS_ALL HCA
396: , HZ_PARTY_SITES HPSN
397: WHERE HPS.PARTY_SITE_ID = l_old_party_site_id
398: AND HCA.CUST_ACCOUNT_ID = l_new_cust_acct_id

Line 396: , HZ_PARTY_SITES HPSN

392: CURSOR new_party_site_csr(l_old_party_site_id NUMBER, l_new_cust_acct_id NUMBER) IS
393: SELECT HPSN.PARTY_SITE_ID
394: FROM HZ_PARTY_SITES HPS
395: , HZ_CUST_ACCOUNTS_ALL HCA
396: , HZ_PARTY_SITES HPSN
397: WHERE HPS.PARTY_SITE_ID = l_old_party_site_id
398: AND HCA.CUST_ACCOUNT_ID = l_new_cust_acct_id
399: AND HCA.PARTY_ID = HPSN.PARTY_ID
400: AND HPSN.LOCATION_ID = HPS.LOCATION_ID

Line 431: FROM HZ_PARTY_SITES HPS

427: AS
428: new_party_site_use_id NUMBER;
429: CURSOR new_party_site_use_csr(l_old_party_site_use_id NUMBER, l_new_cust_acct_id NUMBER) IS
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

Line 433: , HZ_PARTY_SITES HPSN

429: CURSOR new_party_site_use_csr(l_old_party_site_use_id NUMBER, l_new_cust_acct_id NUMBER) IS
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

Line 489: TYPE PS_ID_LIST_TYPE IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE

485: INDEX BY BINARY_INTEGER;
486: IS_ID_LIST IS_ID_LIST_TYPE;
487: NEW_IS_ID_LIST IS_ID_LIST_TYPE;
488:
489: TYPE PS_ID_LIST_TYPE IS TABLE OF HZ_PARTY_SITES.PARTY_SITE_ID%TYPE
490: INDEX BY BINARY_INTEGER;
491: PS_ID_LIST PS_ID_LIST_TYPE;
492: NEW_PS_ID_LIST PS_ID_LIST_TYPE;
493:

Line 504: , HZ_PARTY_SITES HPS

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'
508: AND LSQ.PARENT_OBJECT_ID = LAP.ID

Line 521: , HZ_PARTY_SITES HPS

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'
525: AND LSQ.PARENT_OBJECT_ID = LOP.ID

Line 1803: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'

1799: , TAB.last_update_date = SYSDATE
1800: , TAB.last_updated_by = arp_standard.profile.user_id
1801: , TAB.last_update_login = arp_standard.profile.last_update_login
1802: WHERE TAB.PROSPECT_ID = p_from_fk_id;
1803: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
1804: THEN
1805: --updating the OKL_LEASE_APPS_ALL_B table for column references PROSPECT_ADDRESS_ID
1806: UPDATE OKL_LEASE_APPS_ALL_B TAB
1807: SET TAB.PROSPECT_ADDRESS_ID = p_to_fk_id

Line 1911: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'

1907: , TAB.last_update_date = SYSDATE
1908: , TAB.last_updated_by = arp_standard.profile.user_id
1909: , TAB.last_update_login = arp_standard.profile.last_update_login
1910: WHERE TAB.PROSPECT_ID = p_from_fk_id ;
1911: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
1912: THEN
1913: --updating the OKL_LEASE_OPPS_ALL_B table for column references PROSPECT_ADDRESS_ID
1914: UPDATE OKL_LEASE_OPPS_ALL_B TAB
1915: SET TAB.PROSPECT_ADDRESS_ID = p_to_fk_id

Line 2127: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'

2123: , TAB.last_update_date = SYSDATE
2124: , TAB.last_updated_by = arp_standard.profile.user_id
2125: , TAB.last_update_login = arp_standard.profile.last_update_login
2126: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2127: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2128: THEN
2129: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_SITE_ID
2130: UPDATE OKL_TAX_SOURCES TAB
2131: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id

Line 2236: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'

2232: , TAB.last_update_date = SYSDATE
2233: , TAB.last_updated_by = arp_standard.profile.user_id
2234: , TAB.last_update_login = arp_standard.profile.last_update_login
2235: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2236: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2237: THEN
2238: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_SITE_ID
2239: UPDATE OKL_TAX_SOURCES TAB
2240: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id

Line 2346: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'

2342: , TAB.last_update_date = SYSDATE
2343: , TAB.last_updated_by = arp_standard.profile.user_id
2344: , TAB.last_update_login = arp_standard.profile.last_update_login
2345: WHERE TAB.BILL_TO_PARTY_ID = p_from_fk_id ;
2346: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2347: THEN
2348: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_SITE_ID
2349: UPDATE OKL_TAX_SOURCES_T TAB
2350: SET TAB.BILL_TO_PARTY_SITE_ID = p_to_fk_id

Line 2455: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'

2451: , TAB.last_update_date = SYSDATE
2452: , TAB.last_updated_by = arp_standard.profile.user_id
2453: , TAB.last_update_login = arp_standard.profile.last_update_login
2454: WHERE TAB.SHIP_TO_PARTY_ID = p_from_fk_id ;
2455: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES'
2456: THEN
2457: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_SITE_ID
2458: UPDATE OKL_TAX_SOURCES_T TAB
2459: SET TAB.SHIP_TO_PARTY_SITE_ID = p_to_fk_id

Line 3358: IF p_parent_entity_name = 'HZ_PARTY_SITES'

3354: begin
3355: arp_message.set_name('AR','AR_UPDATING_TABLE');
3356: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
3357:
3358: IF p_parent_entity_name = 'HZ_PARTY_SITES'
3359: THEN
3360: --updating the OKC_K_PARTY_ROLES_B table for column references OBJECT1_ID1
3361: --and JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
3362: UPDATE OKC_K_PARTY_ROLES_B TAB

Line 3440: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

3436: OKL_LEASE_OPPORTUNITIES_B.USAGE_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
3437: UL_ID_LIST UL_ID_LIST_TYPE;
3438: UL_OLD_ID_LIST UL_ID_LIST_TYPE;
3439:
3440: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
3441: l_new_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
3442:
3443: l_profile_val VARCHAR2(30);
3444: CURSOR merged_records IS

Line 3441: l_new_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

3437: UL_ID_LIST UL_ID_LIST_TYPE;
3438: UL_OLD_ID_LIST UL_ID_LIST_TYPE;
3439:
3440: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
3441: l_new_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
3442:
3443: l_profile_val VARCHAR2(30);
3444: CURSOR merged_records IS
3445: SELECT distinct CUSTOMER_MERGE_HEADER_ID

Line 4496: FROM HZ_PARTY_SITES HPS

4492: IS
4493: SELECT HPS.PARTY_ID
4494: , HPS.PARTY_SITE_ID
4495: , HPS.LOCATION_ID
4496: FROM HZ_PARTY_SITES HPS
4497: , HZ_CUST_ACCT_SITES_ALL CAS
4498: , HZ_CUST_SITE_USES_ALL CSU
4499: WHERE CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
4500: AND CAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 4773: FROM HZ_PARTY_SITES HPS

4769: IS
4770: SELECT HPS.PARTY_ID
4771: , HPS.PARTY_SITE_ID
4772: , HPS.LOCATION_ID
4773: FROM HZ_PARTY_SITES HPS
4774: , HZ_CUST_ACCT_SITES_ALL CAS
4775: , HZ_CUST_SITE_USES_ALL CSU
4776: WHERE CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
4777: AND CAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 6212: IF p_parent_entity_name = 'HZ_PARTY_SITES'

6208: begin
6209: arp_message.set_name('AR','AR_UPDATING_TABLE');
6210: arp_message.set_token('TABLE_NAME','OKC_RULES_B',FALSE);
6211:
6212: IF p_parent_entity_name = 'HZ_PARTY_SITES'
6213: THEN
6214: --updating the OKC_RULES_B table for column references OBJECT1_ID1
6215: --and JTOT_OBJECT1_CODE = 'OKL_PARTYSITE'
6216: UPDATE OKC_RULES_B TAB