APPS.ZX_VTX_USER_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 22: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

18: g_string VARCHAR2(80);
19: l_view_name VARCHAR2(200);
20: i PLS_INTEGER;
21: l_in_out_flag VARCHAR2(1); -- Bug 5506031
22: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
23:
24: TYPE party_id_tbl_type is table of NUMBER index by VARCHAR2(100);
25: p_party_id_tbl party_id_tbl_type;
26:

Line 1970: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

1966: l_flag BOOLEAN;
1967: l_inventory_item_id NUMBER;
1968: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1969: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1970: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
1971: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1972:
1973: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';
1974:

Line 2005: FROM ZX_PARTY_TAX_PROFILE

2001: l_ship_from_party_id := p_party_id_tbl(ship_from_tx_id_tab(i));
2002: ELSE
2003: SELECT party_id
2004: INTO l_ship_from_party_id
2005: FROM ZX_PARTY_TAX_PROFILE
2006: WHERE party_tax_profile_id = ship_from_tx_id_tab(i);
2007:
2008: p_party_id_tbl(ship_from_tx_id_tab(i)) := l_ship_from_party_id;
2009: END IF;

Line 2266: zx_party_tax_profile ptp

2262: BEGIN
2263: SELECT pty.party_number
2264: INTO arp_customer_code_tab(i)
2265: FROM hz_parties pty,
2266: zx_party_tax_profile ptp
2267: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2268: AND ptp.party_id = pty.party_id;
2269: EXCEPTION WHEN OTHERS THEN
2270: arp_customer_code_tab(i) := NULL;

Line 2298: zx_party_tax_profile ptp

2294: BEGIN
2295: SELECT pty.party_number
2296: INTO arp_customer_code_tab(i)
2297: FROM hz_parties pty,
2298: zx_party_tax_profile ptp
2299: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2300: AND ptp.party_id = pty.party_id;
2301: EXCEPTION WHEN OTHERS THEN
2302: arp_customer_code_tab(i) := NULL;

Line 2320: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

2316:
2317: PROCEDURE DERIVE_CUSTOMER_CLASS
2318: IS
2319:
2320: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2321: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2322: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_CLASS';
2323:
2324: BEGIN

Line 2321: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2317: PROCEDURE DERIVE_CUSTOMER_CLASS
2318: IS
2319:
2320: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2321: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2322: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_CLASS';
2323:
2324: BEGIN
2325: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2336: FROM zx_party_tax_profile

2332: l_party_id := p_party_id_tbl(l_ptp_id);
2333: ELSE
2334: SELECT party_id
2335: INTO l_party_id
2336: FROM zx_party_tax_profile
2337: WHERE party_tax_profile_id = l_ptp_id;
2338: p_party_id_tbl(l_ptp_id) := l_party_id;
2339: END IF;
2340: END IF; --- Bug 6024643