APPS.PRP_PARTY_MERGE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 59

  CURSOR c1 IS SELECT 1 FROM prp_proposals
    WHERE party_id = p_from_fk_id
    OR contact_party_id = p_from_fk_id
    FOR UPDATE NOWAIT;

Line: 126

      UPDATE prp_proposals SET
        party_id = DECODE(party_id, p_from_fk_id, p_to_fk_id, party_id),
        contact_party_id = DECODE(contact_party_id, p_from_fk_id, p_to_fk_id,
                                  contact_party_id),
        last_update_date = hz_utility_pub.last_update_date,
        last_updated_by  = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login,
        program_id = hz_utility_pub.program_id,
        program_login_id = hz_utility_pub.last_update_login,
        program_application_id = hz_utility_pub.program_application_id,
        request_id = hz_utility_pub.request_id
        WHERE party_id = p_from_fk_id
        OR contact_party_id = p_from_fk_id;

Line: 144

      arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 209

  CURSOR c1 IS SELECT 1 FROM prp_email_recipients
    WHERE party_id = p_from_fk_id
    FOR UPDATE NOWAIT;

Line: 275

      UPDATE prp_email_recipients SET
        party_id = p_to_fk_id,
        last_update_date = hz_utility_pub.last_update_date,
        last_updated_by  = hz_utility_pub.user_id,
        last_update_login = hz_utility_pub.last_update_login,
        program_id = hz_utility_pub.program_id,
        program_login_id = hz_utility_pub.last_update_login,
        program_application_id = hz_utility_pub.program_application_id,
        request_id = hz_utility_pub.request_id
        WHERE party_id = p_from_fk_id;

Line: 290

      arp_message.set_name('AR', 'AR_ROWS_UPDATED');