APPS.POS_SEARCH_DUP_PARTY_PKG SQL Statements

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

Line: 42

    SELECT address_line1, city, state, postal_code, country
    FROM POS_ADDRESS_REQUESTS
    WHERE mapping_id = (select mapping_id
                        from pos_supplier_mappings
                        where supplier_reg_id = p_sup_reg_id);

Line: 49

    SELECT (first_name || ' ' || last_name) contact_name,
       email_address, phone_number
    FROM pos_contact_requests
    WHERE  do_not_delete = 'Y' and
           mapping_id = (select mapping_id
                        from pos_supplier_mappings
                        where supplier_reg_id = p_sup_reg_id);

Line: 205

           SELECT HZ_PARTY_NUMBER_S.Nextval
           INTO l_party_rec.party_number
           FROM DUAL;

Line: 283

PROCEDURE update_supp_party_id(
        p_supp_reg_id		IN NUMBER,
        p_party_id		IN NUMBER,
        x_return_status		OUT NOCOPY VARCHAR2
)
AS

	l_step			VARCHAR2(100):= null;

Line: 297

	l_method	:= 'update_supp_party_id';

Line: 298

	l_step		:= 'update pos_supplier_registrations with partyid';

Line: 309

	UPDATE pos_supplier_registrations
	SET vendor_party_id = l_party_id,
	    last_updated_by = fnd_global.user_id,
	    last_update_date = Sysdate,
	    last_update_login = fnd_global.login_id
	WHERE supplier_reg_id = l_supp_reg_id;

Line: 331

END update_supp_party_id;

Line: 334

PROCEDURE pos_update_organization(
    p_supp_name                 IN     VARCHAR2,
    p_supp_name_alt             IN     VARCHAR2,
    p_tax_payer_id              IN     VARCHAR2,
    p_tax_reg_no                IN     VARCHAR2,
    p_duns_number               IN     VARCHAR2,
    p_sic_code                  IN     VARCHAR2,
    p_party_id                  IN     NUMBER,
--    p_party_obj_version_no	IN     NUMBER,
    x_profile_id		OUT    NOCOPY NUMBER,
    x_return_status             OUT    NOCOPY VARCHAR2,
    x_msg_count                 OUT    NOCOPY NUMBER,
    x_msg_data                  OUT    NOCOPY VARCHAR2
  )
  AS
    l_org_rec                      HZ_PARTY_V2PUB.organization_rec_type;

Line: 365

    l_method           := 'update_organization';

Line: 366

    l_step             := 'Before Calling hz_party_v2pub.update_organization';

Line: 367

    l_api_name         := 'Update_Organization';

Line: 370

     select object_version_number
     into l_party_obj_version
     from hz_parties
     where party_id = p_party_id;

Line: 377

/* Commenting below as we cannor update application Id while updating Party Rec */
    --l_org_rec.APPLICATION_ID      :=  200;

Line: 390

    hz_party_v2pub.update_organization(
                p_init_msg_list => FND_API.G_FALSE,
                p_organization_rec => l_org_rec,
                p_party_object_version_number => l_party_obj_version,
                x_profile_id => l_profile_id,
                x_return_status => l_org_return_status,
                x_msg_count => l_org_msg_count,
                x_msg_data => l_org_msg_data
                );

Line: 404

    l_step := 'After Calling hz_party_v2pub.update_Organization';

Line: 412

            , 'Error in hz_party_v2pub.update_organization ' || x_msg_data);

Line: 418

END pos_update_organization;

Line: 548

  SELECT party_name, jgzz_fiscal_code, tax_reference
  INTO   l_vendor_name, l_taxpayer_id, l_taxreg_num
  FROM hz_parties
  WHERE party_id = l_party_id;