APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_LEASE_APPS_ALL_B

Line 1723: -- Description : Updating the table: OKL_LEASE_APPS_ALL_B for column:

1719:
1720: ----------------------------------------------------------------------------------------------------------
1721: -- Start of comments
1722: -- Procedure Name : LAP_PARTY_MERGE
1723: -- Description : Updating the table: OKL_LEASE_APPS_ALL_B for column:
1724: -- PROSPECT_ID and PROSPECT_ADDRESS_ID
1725: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_APPS_ALL_B
1726: -- and col: PROSPECT_ID and PROSPECT_ADDRESS_ID
1727: -- Parameters :

Line 1725: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_APPS_ALL_B

1721: -- Start of comments
1722: -- Procedure Name : LAP_PARTY_MERGE
1723: -- Description : Updating the table: OKL_LEASE_APPS_ALL_B for column:
1724: -- PROSPECT_ID and PROSPECT_ADDRESS_ID
1725: -- Business Rules : performing PARTY MERGE for table: OKL_LEASE_APPS_ALL_B
1726: -- and col: PROSPECT_ID and PROSPECT_ADDRESS_ID
1727: -- Parameters :
1728: -- Version : 1.0
1729: -- End of comments

Line 1791: arp_message.set_token('TABLE_NAME','OKL_LEASE_APPS_ALL_B',FALSE);

1787: if p_from_fk_id <> p_to_fk_id
1788: then
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

Line 1795: --updating the OKL_LEASE_APPS_ALL_B table for column references PROSPECT_ID

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

Line 1796: UPDATE OKL_LEASE_APPS_ALL_B TAB

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
1798: , TAB.object_version_number = TAB.object_version_number + 1
1799: , TAB.last_update_date = SYSDATE
1800: , TAB.last_updated_by = arp_standard.profile.user_id

Line 1805: --updating the OKL_LEASE_APPS_ALL_B table for column references PROSPECT_ADDRESS_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
1808: , TAB.object_version_number = TAB.object_version_number + 1
1809: , TAB.last_update_date = SYSDATE

Line 1806: UPDATE OKL_LEASE_APPS_ALL_B TAB

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
1808: , TAB.object_version_number = TAB.object_version_number + 1
1809: , TAB.last_update_date = SYSDATE
1810: , TAB.last_updated_by = arp_standard.profile.user_id

Line 1822: 'OKL_LEASE_APPS_ALL_B for = '|| p_from_id));

1818: when others
1819: then
1820: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1821: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1822: 'OKL_LEASE_APPS_ALL_B for = '|| p_from_id));
1823: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1824: x_return_status := FND_API.G_RET_STS_ERROR;
1825: END;
1826: END IF;