APPS.OKL_PARTY_MERGE_PUB dependencies on OKL_TERMNT_INTF_PTY

Line 2778: -- Description : Updating the table: OKL_TERMNT_INTF_PTY for column: PARTY_OBJECT_ID1

2774: ----------------------------------------------------------------------------------------------------------
2775: -- Start of comments
2776:
2777: -- Procedure Name : TIN_PARTY_OBJECT_ID1
2778: -- Description : Updating the table: OKL_TERMNT_INTF_PTY for column: PARTY_OBJECT_ID1
2779: -- Business Rules : performing PARTY MERGE for table: OKL_TERMNT_INTF_PTY and col: PARTY_OBJECT_ID1
2780: -- Parameters :
2781: -- Version : 1.0
2782: -- End of comments

Line 2779: -- Business Rules : performing PARTY MERGE for table: OKL_TERMNT_INTF_PTY and col: PARTY_OBJECT_ID1

2775: -- Start of comments
2776:
2777: -- Procedure Name : TIN_PARTY_OBJECT_ID1
2778: -- Description : Updating the table: OKL_TERMNT_INTF_PTY for column: PARTY_OBJECT_ID1
2779: -- Business Rules : performing PARTY MERGE for table: OKL_TERMNT_INTF_PTY and col: PARTY_OBJECT_ID1
2780: -- Parameters :
2781: -- Version : 1.0
2782: -- End of comments
2783: -----------------------------------------------------------------------------------------------------------

Line 2842: arp_message.set_token('TABLE_NAME','OKL_TERMNT_INTF_PTY',FALSE);

2838: -- not transfer and return the id of the duplicate record as the Merged To Id
2839: if p_from_fk_id <> p_to_fk_id then
2840: begin
2841: arp_message.set_name('AR','AR_UPDATING_TABLE');
2842: arp_message.set_token('TABLE_NAME','OKL_TERMNT_INTF_PTY',FALSE);
2843:
2844: --updating the OKL_TERMNT_INTF_PTY table for column references PARTY_OBJECT_ID1
2845:
2846: UPDATE OKL_TERMNT_INTF_PTY TAB

Line 2844: --updating the OKL_TERMNT_INTF_PTY table for column references PARTY_OBJECT_ID1

2840: begin
2841: arp_message.set_name('AR','AR_UPDATING_TABLE');
2842: arp_message.set_token('TABLE_NAME','OKL_TERMNT_INTF_PTY',FALSE);
2843:
2844: --updating the OKL_TERMNT_INTF_PTY table for column references PARTY_OBJECT_ID1
2845:
2846: UPDATE OKL_TERMNT_INTF_PTY TAB
2847: SET TAB.PARTY_OBJECT_ID1 = p_to_fk_id
2848: ,TAB.last_update_date = SYSDATE

Line 2846: UPDATE OKL_TERMNT_INTF_PTY TAB

2842: arp_message.set_token('TABLE_NAME','OKL_TERMNT_INTF_PTY',FALSE);
2843:
2844: --updating the OKL_TERMNT_INTF_PTY table for column references PARTY_OBJECT_ID1
2845:
2846: UPDATE OKL_TERMNT_INTF_PTY TAB
2847: SET TAB.PARTY_OBJECT_ID1 = p_to_fk_id
2848: ,TAB.last_update_date = SYSDATE
2849: ,TAB.last_updated_by = arp_standard.profile.user_id
2850: ,TAB.last_update_login = arp_standard.profile.last_update_login