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_TXL_ITM_INSTS

Line 1423: -- impacted entity :OKL_TXL_ITM_INSTS

1419: END OKL_TAI_PARTY_MERGE;
1420:
1421: --start merge code pjgomes
1422: --procedure for install at site merge routine for party merge
1423: -- impacted entity :OKL_TXL_ITM_INSTS
1424: Procedure OKL_INSTALL_SITE_MERGE
1425: (p_entity_name IN VARCHAR2,
1426: p_from_id IN NUMBER,
1427: x_to_id OUT NOCOPY NUMBER,

Line 1472: arp_message.set_token('TABLE_NAME','OKL_TXL_ITM_INSTS',FALSE);

1468: -- not transfer and return the id of the duplicate record as the Merged To Id
1469: if p_from_fk_id <> p_to_fk_id then
1470: begin
1471: arp_message.set_name('AR','AR_UPDATING_TABLE');
1472: arp_message.set_token('TABLE_NAME','OKL_TXL_ITM_INSTS',FALSE);
1473:
1474: UPDATE okl_txl_itm_insts iti
1475: SET iti.object_id1_old = p_to_fk_id
1476: , iti.object_version_number = iti.object_version_number + 1

Line 1474: UPDATE okl_txl_itm_insts iti

1470: begin
1471: arp_message.set_name('AR','AR_UPDATING_TABLE');
1472: arp_message.set_token('TABLE_NAME','OKL_TXL_ITM_INSTS',FALSE);
1473:
1474: UPDATE okl_txl_itm_insts iti
1475: SET iti.object_id1_old = p_to_fk_id
1476: , iti.object_version_number = iti.object_version_number + 1
1477: , iti.last_update_date = SYSDATE
1478: , iti.last_updated_by = arp_standard.profile.user_id

Line 1500: -- Description : Updating the table: OKL_TXL_ITM_INSTS for column: OBJECT_ID1_NEW

1496:
1497: ------------------------------------------------------------------------------
1498: -- Start of comments
1499: -- Procedure Name : ITI_OBJECT_ID1_NEW
1500: -- Description : Updating the table: OKL_TXL_ITM_INSTS for column: OBJECT_ID1_NEW
1501: -- Business Rules : performing PARTY MERGE for table: OKL_TXL_ITM_INSTS and col: OBJECT_ID1_NEW
1502: -- Parameters :
1503: -- Version : 1.0
1504: -- End of comments

Line 1501: -- Business Rules : performing PARTY MERGE for table: OKL_TXL_ITM_INSTS and col: OBJECT_ID1_NEW

1497: ------------------------------------------------------------------------------
1498: -- Start of comments
1499: -- Procedure Name : ITI_OBJECT_ID1_NEW
1500: -- Description : Updating the table: OKL_TXL_ITM_INSTS for column: OBJECT_ID1_NEW
1501: -- Business Rules : performing PARTY MERGE for table: OKL_TXL_ITM_INSTS and col: OBJECT_ID1_NEW
1502: -- Parameters :
1503: -- Version : 1.0
1504: -- End of comments
1505: ------------------------------------------------------------------------------

Line 1564: arp_message.set_token('TABLE_NAME','OKL_TXL_ITM_INSTS',FALSE);

1560: if p_from_fk_id <> p_to_fk_id
1561: then
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

Line 1568: --updating the OKL_TXL_ITM_INSTS table for column references PROSPECT_ID

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

Line 1569: UPDATE OKL_TXL_ITM_INSTS TAB

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
1571: , TAB.object_version_number = TAB.object_version_number + 1
1572: , TAB.last_update_date = SYSDATE
1573: , TAB.last_updated_by = arp_standard.profile.user_id

Line 1586: 'OKL_TXL_ITM_INSTS for = '|| p_from_id));

1582: when others
1583: then
1584: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1585: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1586: 'OKL_TXL_ITM_INSTS for = '|| p_from_id));
1587: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: END;
1590: END IF;