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 OKL_LEASE_OPPS_ALL_B

Line 1832: -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:

1828:
1829: ----------------------------------------------------------------------------------------------------------
1830: -- Start of comments
1831: -- Procedure Name : LOP_PARTY_MERGE
1832: -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:
1833: -- PROSPECT_ID, PROSPECT_ADDRESS_ID, INSTALL_SITE_ID and USAGE_LOCATION_ID
1834: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B
1835: -- and col: PROSPECT_ID, PROSPECT_ADDRESS_ID, INSTALL_SITE_ID and USAGE_LOCATION_ID
1836: -- Parameters :

Line 1834: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B

1830: -- Start of comments
1831: -- Procedure Name : LOP_PARTY_MERGE
1832: -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:
1833: -- PROSPECT_ID, PROSPECT_ADDRESS_ID, INSTALL_SITE_ID and USAGE_LOCATION_ID
1834: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B
1835: -- and col: PROSPECT_ID, PROSPECT_ADDRESS_ID, INSTALL_SITE_ID and USAGE_LOCATION_ID
1836: -- Parameters :
1837: -- Version : 1.0
1838: -- End of comments

Line 1899: arp_message.set_token('TABLE_NAME','OKL_LEASE_OPPS_ALL_B',FALSE);

1895: if p_from_fk_id <> p_to_fk_id
1896: then
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

Line 1903: --updating the OKL_LEASE_OPPS_ALL_B table for column references PROSPECT_ID

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
1906: , TAB.object_version_number = TAB.object_version_number + 1
1907: , TAB.last_update_date = SYSDATE

Line 1904: UPDATE OKL_LEASE_OPPS_ALL_B TAB

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
1906: , TAB.object_version_number = TAB.object_version_number + 1
1907: , TAB.last_update_date = SYSDATE
1908: , TAB.last_updated_by = arp_standard.profile.user_id

Line 1913: --updating the OKL_LEASE_OPPS_ALL_B table for column references PROSPECT_ADDRESS_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
1916: , TAB.object_version_number = TAB.object_version_number + 1
1917: , TAB.last_update_date = SYSDATE

Line 1914: UPDATE OKL_LEASE_OPPS_ALL_B TAB

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
1916: , TAB.object_version_number = TAB.object_version_number + 1
1917: , TAB.last_update_date = SYSDATE
1918: , TAB.last_updated_by = arp_standard.profile.user_id

Line 1923: --updating the OKL_LEASE_OPPS_ALL_B table for column references INSTALL_SITE_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
1926: , TAB.object_version_number = TAB.object_version_number + 1
1927: , TAB.last_update_date = SYSDATE

Line 1924: UPDATE OKL_LEASE_OPPS_ALL_B TAB

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
1926: , TAB.object_version_number = TAB.object_version_number + 1
1927: , TAB.last_update_date = SYSDATE
1928: , TAB.last_updated_by = arp_standard.profile.user_id

Line 1941: 'OKL_LEASE_OPPS_ALL_B for = '|| p_from_id));

1937: when others
1938: then
1939: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1940: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1941: 'OKL_LEASE_OPPS_ALL_B for = '|| p_from_id));
1942: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: END;
1945: END IF;

Line 1951: -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:

1947:
1948: ----------------------------------------------------------------------------------------------------------
1949: -- Start of comments
1950: -- Procedure Name : LOP_USAGE_LOCATION
1951: -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:
1952: -- USAGE_LOCATION_ID
1953: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B
1954: -- and col: USAGE_LOCATION_ID
1955: -- Parameters :

Line 1953: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B

1949: -- Start of comments
1950: -- Procedure Name : LOP_USAGE_LOCATION
1951: -- Description : Updating the table: OKL_LEASE_OPPS_ALL_B for column:
1952: -- USAGE_LOCATION_ID
1953: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_OPPS_ALL_B
1954: -- and col: USAGE_LOCATION_ID
1955: -- Parameters :
1956: -- Version : 1.0
1957: -- End of comments

Line 2018: arp_message.set_token('TABLE_NAME','OKL_LEASE_OPPS_ALL_B',FALSE);

2014: if p_from_fk_id <> p_to_fk_id
2015: then
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

Line 2022: --updating the OKL_LEASE_OPPS_ALL_B table for column references USAGE_LOCATION_ID

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
2025: , TAB.object_version_number = TAB.object_version_number + 1
2026: , TAB.last_update_date = SYSDATE

Line 2023: UPDATE OKL_LEASE_OPPS_ALL_B TAB

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
2025: , TAB.object_version_number = TAB.object_version_number + 1
2026: , TAB.last_update_date = SYSDATE
2027: , TAB.last_updated_by = arp_standard.profile.user_id

Line 2040: 'OKL_LEASE_OPPS_ALL_B for = '|| p_from_id));

2036: when others
2037: then
2038: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
2039: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
2040: 'OKL_LEASE_OPPS_ALL_B for = '|| p_from_id));
2041: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: END;
2044: END IF;