APPS.POS_PARTY_MERGE_PKG SQL Statements

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

Line: 9

        SELECT 1
          FROM hz_code_assignments
          WHERE owner_table_name = 'HZ_PARTIES'
          AND owner_table_id = p_party_id
          AND class_category = 'POS_PARTICIPANT_TYPE'
          AND class_code     = 'ENTERPRISE'
          AND status = 'A'
          AND ROWNUM < 2;

Line: 35

        SELECT 1
        FROM pos_address_requests par, pos_supplier_mappings psm
        WHERE psm.party_id = p_party_id
        AND psm.mapping_id = par.mapping_id
        AND par.request_status = 'PENDING';

Line: 42

        SELECT 1
        FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm
        WHERE psm.party_id = p_party_id
        AND psm.mapping_id = pbcr.mapping_id
        AND pbcr.request_status = 'PENDING';

Line: 49

        SELECT 1
        FROM pos_contact_requests pcr, pos_supplier_mappings psm
        WHERE psm.party_id = p_party_id
        AND psm.mapping_id = pcr.mapping_id
        AND pcr.request_status = 'PENDING';

Line: 56

        SELECT 1
        FROM pos_cont_addr_requests pcar, pos_supplier_mappings psm
        WHERE psm.party_id = p_party_id
        AND psm.mapping_id = pcar.mapping_id
        AND pcar.request_status = 'PENDING';

Line: 63

        SELECT 1
        FROM pos_product_service_requests ppsr, pos_supplier_mappings psm
        WHERE psm.party_id = p_party_id
        AND psm.mapping_id = ppsr.mapping_id
        AND ppsr.request_status = 'PENDING';

Line: 71

        SELECT 1
        from POS_ACNT_GEN_REQ req, IBY_TEMP_EXT_BANK_ACCTS temp, POS_SUPPLIER_MAPPINGS pmap
        where req.mapping_id = pmap.mapping_id
        and pmap.party_id = p_party_id
        and temp.status in ('CORRECTED', 'NEW', 'IN_VERIFICATION', 'CHANGE_PENDING')
        and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id
        and rownum = 1

        UNION

        select 1
        from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps
        where req.request_status = 'PENDING'
        and req.request_type = 'ADDRESS'
        and req.mapping_id = pmap.mapping_id
        and hps.party_site_id = req.party_site_id
        and hps.status = 'A'
        and pmap.party_id = p_party_id
        and rownum = 1

        UNION

        select 1
        from pos_acnt_addr_req req, pos_supplier_mappings pmap
        where req.request_status = 'PENDING'
        and req.request_type = 'SUPPLIER'
        and req.mapping_id = pmap.mapping_id
        and req.party_site_id is null
        and pmap.party_id = p_party_id
        and rownum = 1;

Line: 168

        SELECT party_type, party_name
          FROM hz_parties
          WHERE party_id = p_party_id;

Line: 241

PROCEDURE update_supplier_mapping(
    p_old_party_id     IN NUMBER,
    p_new_party_id     IN NUMBER,
    x_return_status    IN OUT nocopy VARCHAR2
    )
IS

BEGIN

   UPDATE pos_supplier_mappings
      SET party_id = p_new_party_id,
          last_updated_by = FND_GLOBAL.user_id,
          last_update_date = SYSDATE,
          last_update_login = FND_GLOBAL.login_id
    WHERE mapping_id IN
          (SELECT mapping_id
	     FROM pos_supplier_mappings
            WHERE party_id = p_old_party_id
	   );

Line: 263

END update_supplier_mapping;

Line: 282

        SELECT party_id
          FROM hz_party_sites
          WHERE party_site_id = p_party_site_id;

Line: 291

        SELECT party_id
          FROM hz_party_sites
          WHERE party_site_id = p_party_site_id;

Line: 296

        SELECT party_id
          FROM hz_parties
          WHERE party_id = p_party_id;

Line: 437

   update_supplier_mapping(p_from_fk_id, p_to_fk_id, l_return_status);