APPS.POS_VENDOR_REG_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 800: FROM zx_party_tax_profile

796: l_user_id NUMBER;
797:
798: CURSOR l_ptp_cur(p_party_id IN NUMBER) IS
799: SELECT party_tax_profile_id
800: FROM zx_party_tax_profile
801: WHERE party_id = p_party_id
802: AND party_type_code = 'THIRD_PARTY'
803: AND ROWNUM = 1;
804:

Line 920: zx_party_tax_profile_pkg.update_row

916: FETCH l_ptp_cur INTO l_party_tax_profile_id;
917: IF l_ptp_cur%found THEN
918: CLOSE l_ptp_cur;
919:
920: zx_party_tax_profile_pkg.update_row
921: (p_party_tax_profile_id => l_party_tax_profile_id,
922: p_collecting_authority_flag => NULL,
923: p_provider_type_code => NULL,
924: p_create_awt_dists_type_code => NULL,

Line 973: x_msg_data := 'call to zx_party_tax_profile_pkg.update_row failed';

969: IF x_return_status IS NULL
970: OR x_return_status <> fnd_api.g_ret_sts_success THEN
971: ROLLBACK TO approve_supplier_reg;
972: x_msg_count := 1;
973: x_msg_data := 'call to zx_party_tax_profile_pkg.update_row failed';
974: RETURN;
975: END IF;
976: ELSE
977: CLOSE l_ptp_cur;

Line 1442: FROM ap_suppliers pv, zx_party_tax_profile zxpr

1438: AND psr.registration_status = 'PENDING_APPROVAL';
1439:
1440: CURSOR po_vendors_cur IS
1441: SELECT pv.vendor_id
1442: FROM ap_suppliers pv, zx_party_tax_profile zxpr
1443: WHERE pv.num_1099 = p_taxpayer_id
1444: AND zxpr.party_id = pv.party_id
1445: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR
1446: (p_country is null));

Line 1563: FROM ap_suppliers pv, zx_party_tax_profile zxpr

1559: AND psr.registration_status = 'PENDING_APPROVAL';
1560:
1561: CURSOR po_vendors_cur IS
1562: SELECT pv.vendor_id
1563: FROM ap_suppliers pv, zx_party_tax_profile zxpr
1564: WHERE zxpr.party_id = pv.party_id
1565: AND zxpr.rep_registration_number = p_taxreg_num
1566: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR
1567: (p_country is null));

Line 1571: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr

1567: (p_country is null));
1568:
1569: CURSOR po_vendor_sites_cur IS
1570: SELECT pvsa.vendor_id
1571: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr
1572: WHERE zxpr.rep_registration_number = p_taxreg_num
1573: AND zxpr.site_flag = 'Y'
1574: AND zxpr.party_id = pvsa.party_site_id
1575: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR