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_QUOTE_PARTIES

Line 2586: -- Description : Updating the table: OKL_QUOTE_PARTIES for column: PARTY_OBJECT1_ID1

2582: ----------------------------------------------------------------------------------------------------------
2583: -- Start of comments
2584:
2585: -- Procedure Name : QPY_PARTY_OBJECT1_ID1
2586: -- Description : Updating the table: OKL_QUOTE_PARTIES for column: PARTY_OBJECT1_ID1
2587: -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: PARTY_OBJECT1_ID1
2588: -- Parameters :
2589: -- Version : 1.0
2590: -- End of comments

Line 2587: -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: PARTY_OBJECT1_ID1

2583: -- Start of comments
2584:
2585: -- Procedure Name : QPY_PARTY_OBJECT1_ID1
2586: -- Description : Updating the table: OKL_QUOTE_PARTIES for column: PARTY_OBJECT1_ID1
2587: -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: PARTY_OBJECT1_ID1
2588: -- Parameters :
2589: -- Version : 1.0
2590: -- End of comments
2591: -----------------------------------------------------------------------------------------------------------

Line 2650: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);

2646: -- not transfer and return the id of the duplicate record as the Merged To Id
2647: if p_from_fk_id <> p_to_fk_id then
2648: begin
2649: arp_message.set_name('AR','AR_UPDATING_TABLE');
2650: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);
2651:
2652: --updating the OKL_QUOTE_PARTIES table for column references PARTY_OBJECT1_ID1
2653:
2654: UPDATE OKL_QUOTE_PARTIES TAB

Line 2652: --updating the OKL_QUOTE_PARTIES table for column references PARTY_OBJECT1_ID1

2648: begin
2649: arp_message.set_name('AR','AR_UPDATING_TABLE');
2650: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);
2651:
2652: --updating the OKL_QUOTE_PARTIES table for column references PARTY_OBJECT1_ID1
2653:
2654: UPDATE OKL_QUOTE_PARTIES TAB
2655: SET TAB.PARTY_OBJECT1_ID1 = p_to_fk_id
2656: ,TAB.object_version_number = TAB.object_version_number + 1

Line 2654: UPDATE OKL_QUOTE_PARTIES TAB

2650: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);
2651:
2652: --updating the OKL_QUOTE_PARTIES table for column references PARTY_OBJECT1_ID1
2653:
2654: UPDATE OKL_QUOTE_PARTIES TAB
2655: SET TAB.PARTY_OBJECT1_ID1 = p_to_fk_id
2656: ,TAB.object_version_number = TAB.object_version_number + 1
2657: ,TAB.last_update_date = SYSDATE
2658: ,TAB.last_updated_by = arp_standard.profile.user_id

Line 2682: -- Description : Updating the table: OKL_QUOTE_PARTIES for column: CONTACT_OBJECT1_ID1

2678: ----------------------------------------------------------------------------------------------------------
2679: -- Start of comments
2680:
2681: -- Procedure Name : QPY_CONTACT_OBJECT1_ID1
2682: -- Description : Updating the table: OKL_QUOTE_PARTIES for column: CONTACT_OBJECT1_ID1
2683: -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: CONTACT_OBJECT1_ID1
2684: -- Parameters :
2685: -- Version : 1.0
2686: -- End of comments

Line 2683: -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: CONTACT_OBJECT1_ID1

2679: -- Start of comments
2680:
2681: -- Procedure Name : QPY_CONTACT_OBJECT1_ID1
2682: -- Description : Updating the table: OKL_QUOTE_PARTIES for column: CONTACT_OBJECT1_ID1
2683: -- Business Rules : performing PARTY MERGE for table: OKL_QUOTE_PARTIES and col: CONTACT_OBJECT1_ID1
2684: -- Parameters :
2685: -- Version : 1.0
2686: -- End of comments
2687: -----------------------------------------------------------------------------------------------------------

Line 2746: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);

2742: -- not transfer and return the id of the duplicate record as the Merged To Id
2743: if p_from_fk_id <> p_to_fk_id then
2744: begin
2745: arp_message.set_name('AR','AR_UPDATING_TABLE');
2746: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);
2747:
2748: --updating the OKL_QUOTE_PARTIES table for column references CONTACT_OBJECT1_ID1
2749:
2750: UPDATE OKL_QUOTE_PARTIES TAB

Line 2748: --updating the OKL_QUOTE_PARTIES table for column references CONTACT_OBJECT1_ID1

2744: begin
2745: arp_message.set_name('AR','AR_UPDATING_TABLE');
2746: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);
2747:
2748: --updating the OKL_QUOTE_PARTIES table for column references CONTACT_OBJECT1_ID1
2749:
2750: UPDATE OKL_QUOTE_PARTIES TAB
2751: SET TAB.CONTACT_OBJECT1_ID1 = p_to_fk_id
2752: ,TAB.object_version_number = TAB.object_version_number + 1

Line 2750: UPDATE OKL_QUOTE_PARTIES TAB

2746: arp_message.set_token('TABLE_NAME','OKL_QUOTE_PARTIES',FALSE);
2747:
2748: --updating the OKL_QUOTE_PARTIES table for column references CONTACT_OBJECT1_ID1
2749:
2750: UPDATE OKL_QUOTE_PARTIES TAB
2751: SET TAB.CONTACT_OBJECT1_ID1 = p_to_fk_id
2752: ,TAB.object_version_number = TAB.object_version_number + 1
2753: ,TAB.last_update_date = SYSDATE
2754: ,TAB.last_updated_by = arp_standard.profile.user_id