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_PARTIES

Line 1147: ,opi.party_name = (select party_name from hz_parties where party_id = p_to_fk_id)

1143: arp_message.set_token('TABLE_NAME','OKL_OPEN_INT_ALL',FALSE);
1144:
1145: UPDATE OKL_OPEN_INT_ALL opi
1146: SET opi.party_ID = p_to_fk_id
1147: ,opi.party_name = (select party_name from hz_parties where party_id = p_to_fk_id)
1148: ,opi.party_type = (select party_type from hz_parties where party_id = p_to_fk_id)
1149: ,opi.object_version_number = opi.object_version_number + 1
1150: ,opi.last_update_date = SYSDATE
1151: ,opi.last_updated_by = arp_standard.profile.user_id

Line 1148: ,opi.party_type = (select party_type from hz_parties where party_id = p_to_fk_id)

1144:
1145: UPDATE OKL_OPEN_INT_ALL opi
1146: SET opi.party_ID = p_to_fk_id
1147: ,opi.party_name = (select party_name from hz_parties where party_id = p_to_fk_id)
1148: ,opi.party_type = (select party_type from hz_parties where party_id = p_to_fk_id)
1149: ,opi.object_version_number = opi.object_version_number + 1
1150: ,opi.last_update_date = SYSDATE
1151: ,opi.last_updated_by = arp_standard.profile.user_id
1152: ,opi.last_update_login = arp_standard.profile.last_update_login

Line 1793: IF p_parent_entity_name = 'HZ_PARTIES'

1789: begin
1790: arp_message.set_name('AR','AR_UPDATING_TABLE');
1791: arp_message.set_token('TABLE_NAME','OKL_LEASE_APPS_ALL_B',FALSE);
1792:
1793: IF p_parent_entity_name = 'HZ_PARTIES'
1794: THEN
1795: --updating the OKL_LEASE_APPS_ALL_B table for column references PROSPECT_ID
1796: UPDATE OKL_LEASE_APPS_ALL_B TAB
1797: SET TAB.PROSPECT_ID = p_to_fk_id

Line 1901: IF p_parent_entity_name = 'HZ_PARTIES'

1897: begin
1898: arp_message.set_name('AR','AR_UPDATING_TABLE');
1899: arp_message.set_token('TABLE_NAME','OKL_LEASE_OPPS_ALL_B',FALSE);
1900:
1901: IF p_parent_entity_name = 'HZ_PARTIES'
1902: THEN
1903: --updating the OKL_LEASE_OPPS_ALL_B table for column references PROSPECT_ID
1904: UPDATE OKL_LEASE_OPPS_ALL_B TAB
1905: SET TAB.PROSPECT_ID = p_to_fk_id

Line 2117: IF p_parent_entity_name = 'HZ_PARTIES'

2113: begin
2114: arp_message.set_name('AR','AR_UPDATING_TABLE');
2115: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
2116:
2117: IF p_parent_entity_name = 'HZ_PARTIES'
2118: THEN
2119: --updating the OKL_TAX_SOURCES table for column references BILL_TO_PARTY_ID
2120: UPDATE OKL_TAX_SOURCES TAB
2121: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id

Line 2226: IF p_parent_entity_name = 'HZ_PARTIES'

2222: begin
2223: arp_message.set_name('AR','AR_UPDATING_TABLE');
2224: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES',FALSE);
2225:
2226: IF p_parent_entity_name = 'HZ_PARTIES'
2227: THEN
2228: --updating the OKL_TAX_SOURCES table for column references SHIP_TO_PARTY_ID
2229: UPDATE OKL_TAX_SOURCES TAB
2230: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id

Line 2336: IF p_parent_entity_name = 'HZ_PARTIES'

2332: begin
2333: arp_message.set_name('AR','AR_UPDATING_TABLE');
2334: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
2335:
2336: IF p_parent_entity_name = 'HZ_PARTIES'
2337: THEN
2338: --updating the OKL_TAX_SOURCES_T table for column references BILL_TO_PARTY_ID
2339: UPDATE OKL_TAX_SOURCES_T TAB
2340: SET TAB.BILL_TO_PARTY_ID = p_to_fk_id

Line 2445: IF p_parent_entity_name = 'HZ_PARTIES'

2441: begin
2442: arp_message.set_name('AR','AR_UPDATING_TABLE');
2443: arp_message.set_token('TABLE_NAME','OKL_TAX_SOURCES_T',FALSE);
2444:
2445: IF p_parent_entity_name = 'HZ_PARTIES'
2446: THEN
2447: --updating the OKL_TAX_SOURCES_T table for column references SHIP_TO_PARTY_ID
2448: UPDATE OKL_TAX_SOURCES_T TAB
2449: SET TAB.SHIP_TO_PARTY_ID = p_to_fk_id

Line 2902: l_src_party_name hz_parties.party_name%type;

2898: l_cplv_rec OKC_CPL_PVT.cplv_rec_type;
2899: l_kplv_rec OKL_KPL_PVT.kplv_rec_type;
2900:
2901: --start NISINHA Bug# 6655434 declaring variables for storing source and destination party names
2902: l_src_party_name hz_parties.party_name%type;
2903: l_des_party_name hz_parties.party_name%type;
2904:
2905: --This cursor is used to get the party name based on the party id.
2906: CURSOR c_get_party_name(p_party_id IN NUMBER) IS

Line 2903: l_des_party_name hz_parties.party_name%type;

2899: l_kplv_rec OKL_KPL_PVT.kplv_rec_type;
2900:
2901: --start NISINHA Bug# 6655434 declaring variables for storing source and destination party names
2902: l_src_party_name hz_parties.party_name%type;
2903: l_des_party_name hz_parties.party_name%type;
2904:
2905: --This cursor is used to get the party name based on the party id.
2906: CURSOR c_get_party_name(p_party_id IN NUMBER) IS
2907: SELECT party_name FROM hz_parties WHERE party_id = p_party_id;

Line 2907: SELECT party_name FROM hz_parties WHERE party_id = p_party_id;

2903: l_des_party_name hz_parties.party_name%type;
2904:
2905: --This cursor is used to get the party name based on the party id.
2906: CURSOR c_get_party_name(p_party_id IN NUMBER) IS
2907: SELECT party_name FROM hz_parties WHERE party_id = p_party_id;
2908: -- end NISINHA Bug#6655434
2909:
2910: --This cursor fetches all those contracts, which have both source and destination
2911: --Parties as the parties to the contract at header or line level

Line 3054: IF p_parent_entity_name = 'HZ_PARTIES'

3050: then
3051: arp_message.set_name('AR','AR_UPDATING_TABLE');
3052: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
3053:
3054: IF p_parent_entity_name = 'HZ_PARTIES'
3055: THEN
3056: --Check if the parties to be merged are part of same type of contract
3057: OPEN chk_vendor_chr_csr(p_from_fk_id, p_to_fk_id);
3058: LOOP