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_TRX_CONTRACTS_ALL

Line 2486: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_NEW

2482: ----------------------------------------------------------------------------------------------------------
2483: -- Start of comments
2484:
2485: -- Procedure Name : TCN_PARTY_REL_ID2_NEW
2486: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_NEW
2487: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_NEW
2488: -- Parameters :
2489: -- Version : 1.0
2490: -- End of comments

Line 2487: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_NEW

2483: -- Start of comments
2484:
2485: -- Procedure Name : TCN_PARTY_REL_ID2_NEW
2486: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_NEW
2487: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_NEW
2488: -- Parameters :
2489: -- Version : 1.0
2490: -- End of comments
2491: -----------------------------------------------------------------------------------------------------------

Line 2552: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);

2548:
2549: if p_from_fk_id <> p_to_fk_id then
2550: begin
2551: arp_message.set_name('AR','AR_UPDATING_TABLE');
2552: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
2553:
2554: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_NEW
2555:
2556: UPDATE OKL_TRX_CONTRACTS_ALL TAB

Line 2554: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_NEW

2550: begin
2551: arp_message.set_name('AR','AR_UPDATING_TABLE');
2552: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
2553:
2554: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_NEW
2555:
2556: UPDATE OKL_TRX_CONTRACTS_ALL TAB
2557: SET TAB.PARTY_REL_ID2_NEW = p_to_fk_id
2558: ,TAB.object_version_number = TAB.object_version_number + 1

Line 2556: UPDATE OKL_TRX_CONTRACTS_ALL TAB

2552: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
2553:
2554: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_NEW
2555:
2556: UPDATE OKL_TRX_CONTRACTS_ALL TAB
2557: SET TAB.PARTY_REL_ID2_NEW = p_to_fk_id
2558: ,TAB.object_version_number = TAB.object_version_number + 1
2559: ,TAB.last_update_date = SYSDATE
2560: ,TAB.last_updated_by = arp_standard.profile.user_id

Line 5847: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_NEW

5843:
5844: ----------------------------------------------------------------------------------------------------------
5845: -- Start of comments
5846: -- Procedure Name : TCN_PARTY_REL_ID1_NEW
5847: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_NEW
5848: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_NEW
5849: -- Parameters :
5850: -- Version : 1.0
5851: -- End of comments

Line 5848: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_NEW

5844: ----------------------------------------------------------------------------------------------------------
5845: -- Start of comments
5846: -- Procedure Name : TCN_PARTY_REL_ID1_NEW
5847: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_NEW
5848: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_NEW
5849: -- Parameters :
5850: -- Version : 1.0
5851: -- End of comments
5852: -----------------------------------------------------------------------------------------------------------

Line 5913: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);

5909:
5910: if p_from_fk_id <> p_to_fk_id then
5911: begin
5912: arp_message.set_name('AR','AR_UPDATING_TABLE');
5913: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
5914:
5915: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_NEW
5916:
5917: UPDATE OKL_TRX_CONTRACTS_ALL TAB

Line 5915: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_NEW

5911: begin
5912: arp_message.set_name('AR','AR_UPDATING_TABLE');
5913: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
5914:
5915: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_NEW
5916:
5917: UPDATE OKL_TRX_CONTRACTS_ALL TAB
5918: SET TAB.PARTY_REL_ID1_NEW = p_to_fk_id
5919: ,TAB.object_version_number = TAB.object_version_number + 1

Line 5917: UPDATE OKL_TRX_CONTRACTS_ALL TAB

5913: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
5914:
5915: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_NEW
5916:
5917: UPDATE OKL_TRX_CONTRACTS_ALL TAB
5918: SET TAB.PARTY_REL_ID1_NEW = p_to_fk_id
5919: ,TAB.object_version_number = TAB.object_version_number + 1
5920: ,TAB.last_update_date = SYSDATE
5921: ,TAB.last_updated_by = arp_standard.profile.user_id

Line 5946: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_OLD

5942:
5943: ----------------------------------------------------------------------------------------------------------
5944: -- Start of comments
5945: -- Procedure Name : TCN_PARTY_REL_ID1_OLD
5946: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_OLD
5947: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_OLD
5948: -- Parameters :
5949: -- Version : 1.0
5950: -- End of comments

Line 5947: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_OLD

5943: ----------------------------------------------------------------------------------------------------------
5944: -- Start of comments
5945: -- Procedure Name : TCN_PARTY_REL_ID1_OLD
5946: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID1_OLD
5947: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID1_OLD
5948: -- Parameters :
5949: -- Version : 1.0
5950: -- End of comments
5951: -----------------------------------------------------------------------------------------------------------

Line 6012: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);

6008:
6009: if p_from_fk_id <> p_to_fk_id then
6010: begin
6011: arp_message.set_name('AR','AR_UPDATING_TABLE');
6012: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
6013:
6014: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_OLD
6015:
6016: UPDATE OKL_TRX_CONTRACTS_ALL TAB

Line 6014: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_OLD

6010: begin
6011: arp_message.set_name('AR','AR_UPDATING_TABLE');
6012: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
6013:
6014: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_OLD
6015:
6016: UPDATE OKL_TRX_CONTRACTS_ALL TAB
6017: SET TAB.PARTY_REL_ID1_OLD = p_to_fk_id
6018: ,TAB.object_version_number = TAB.object_version_number + 1

Line 6016: UPDATE OKL_TRX_CONTRACTS_ALL TAB

6012: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
6013:
6014: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID1_OLD
6015:
6016: UPDATE OKL_TRX_CONTRACTS_ALL TAB
6017: SET TAB.PARTY_REL_ID1_OLD = p_to_fk_id
6018: ,TAB.object_version_number = TAB.object_version_number + 1
6019: ,TAB.last_update_date = SYSDATE
6020: ,TAB.last_updated_by = arp_standard.profile.user_id

Line 6045: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_OLD

6041:
6042: ----------------------------------------------------------------------------------------------------------
6043: -- Start of comments
6044: -- Procedure Name : TCN_PARTY_REL_ID2_OLD
6045: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_OLD
6046: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_OLD
6047: -- Parameters :
6048: -- Version : 1.0
6049: -- End of comments

Line 6046: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_OLD

6042: ----------------------------------------------------------------------------------------------------------
6043: -- Start of comments
6044: -- Procedure Name : TCN_PARTY_REL_ID2_OLD
6045: -- Description : Updating the table: OKL_TRX_CONTRACTS_ALL for column: PARTY_REL_ID2_OLD
6046: -- Business Rules : performing PARTY MERGE for table: OKL_TRX_CONTRACTS_ALL and col: PARTY_REL_ID2_OLD
6047: -- Parameters :
6048: -- Version : 1.0
6049: -- End of comments
6050: -----------------------------------------------------------------------------------------------------------

Line 6111: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);

6107:
6108: if p_from_fk_id <> p_to_fk_id then
6109: begin
6110: arp_message.set_name('AR','AR_UPDATING_TABLE');
6111: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
6112:
6113: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_OLD
6114:
6115: UPDATE OKL_TRX_CONTRACTS_ALL TAB

Line 6113: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_OLD

6109: begin
6110: arp_message.set_name('AR','AR_UPDATING_TABLE');
6111: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
6112:
6113: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_OLD
6114:
6115: UPDATE OKL_TRX_CONTRACTS_ALL TAB
6116: SET TAB.PARTY_REL_ID2_OLD = p_to_fk_id
6117: ,TAB.object_version_number = TAB.object_version_number + 1

Line 6115: UPDATE OKL_TRX_CONTRACTS_ALL TAB

6111: arp_message.set_token('TABLE_NAME','OKL_TRX_CONTRACTS_ALL',FALSE);
6112:
6113: --updating the OKL_TRX_CONTRACTS_ALL table for column references PARTY_REL_ID2_OLD
6114:
6115: UPDATE OKL_TRX_CONTRACTS_ALL TAB
6116: SET TAB.PARTY_REL_ID2_OLD = p_to_fk_id
6117: ,TAB.object_version_number = TAB.object_version_number + 1
6118: ,TAB.last_update_date = SYSDATE
6119: ,TAB.last_updated_by = arp_standard.profile.user_id