APPS.ZX_TAXWARE_USER_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 27: g_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

23: g_string VARCHAR2(80);
24: l_view_name VARCHAR2(200);
25: i PLS_INTEGER;
26: g_in_out_flag VARCHAR2(1); -- Bug 5506031
27: g_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
28: g_org_id RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE;
29: g_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;
30:
31: TYPE party_id_tbl_type is table of NUMBER index by VARCHAR2(100);

Line 438: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

434: l_is_view_name_derived VARCHAR2(1);
435: --l_view_name VARCHAR2(200); --Commented for the bug#6723111
436: l_srv_name VARCHAR2(100);
437: l_is_sales_repid_derived VARCHAR2(1);
438: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
439: --i PLS_INTEGER;
440: j PLS_INTEGER;
441:
442: l_master_org_id oe_system_parameters_all.master_organization_id%type;

Line 589: FROM ZX_PARTY_TAX_PROFILE

585: BEGIN
586: IF ship_from_tx_id_tab(i) IS NOT NULL
587: THEN
588: SELECT party_id INTO l_ship_from_party_id
589: FROM ZX_PARTY_TAX_PROFILE
590: WHERE party_tax_profile_id = ship_from_tx_id_tab(i);
591: END IF;
592:
593: EXCEPTION WHEN NO_DATA_FOUND

Line 2006: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

2002: l_sfr_in_out_flag VARCHAR2(1);
2003: l_flag BOOLEAN;
2004: l_inventory_item_id NUMBER;
2005: l_master_org_id oe_system_parameters_all.master_organization_id%type;
2006: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2007: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
2008:
2009: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';
2010:

Line 2040: FROM ZX_PARTY_TAX_PROFILE

2036: l_ship_from_party_id := p_party_id_tbl(ship_from_tx_id_tab(i));
2037: ELSE
2038: SELECT party_id
2039: INTO l_ship_from_party_id
2040: FROM ZX_PARTY_TAX_PROFILE
2041: WHERE party_tax_profile_id = ship_from_tx_id_tab(i);
2042:
2043: p_party_id_tbl(ship_from_tx_id_tab(i)) := l_ship_from_party_id;
2044: END IF;

Line 2244: zx_party_tax_profile ptp

2240: BEGIN
2241: SELECT pty.party_number
2242: INTO arp_customer_code_tab(i)
2243: FROM hz_parties pty,
2244: zx_party_tax_profile ptp
2245: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2246: AND ptp.party_id = pty.party_id;
2247: EXCEPTION WHEN OTHERS THEN
2248: arp_customer_code_tab(i) := NULL;

Line 2276: zx_party_tax_profile ptp

2272: BEGIN
2273: SELECT pty.party_number
2274: INTO arp_customer_code_tab(i)
2275: FROM hz_parties pty,
2276: zx_party_tax_profile ptp
2277: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2278: AND ptp.party_id = pty.party_id;
2279: EXCEPTION WHEN OTHERS THEN
2280: arp_customer_code_tab(i) := NULL;

Line 2299: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

2295:
2296: PROCEDURE DERIVE_CUSTOMER_NAME
2297: IS
2298:
2299: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2300: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2301: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_NAME';
2302:
2303: BEGIN

Line 2300: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2296: PROCEDURE DERIVE_CUSTOMER_NAME
2297: IS
2298:
2299: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2300: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2301: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_NAME';
2302:
2303: BEGIN
2304: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2323: zx_party_tax_profile ptp

2319: BEGIN
2320: SELECT pty.party_name
2321: INTO arp_customer_name_tab(i)
2322: FROM hz_parties pty,
2323: zx_party_tax_profile ptp
2324: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2325: AND ptp.party_id = pty.party_id;
2326: EXCEPTION WHEN OTHERS THEN
2327: arp_customer_name_tab(i) := NULL;

Line 2351: zx_party_tax_profile ptp

2347: BEGIN
2348: SELECT pty.party_name
2349: INTO arp_customer_name_tab(i)
2350: FROM hz_parties pty,
2351: zx_party_tax_profile ptp
2352: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2353: AND ptp.party_id = pty.party_id;
2354: EXCEPTION WHEN OTHERS THEN
2355: arp_customer_name_tab(i) := NULL;