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 1820: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

1816: l_flag BOOLEAN;
1817: l_inventory_item_id NUMBER;
1818: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1819: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1820: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
1821: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1822:
1823: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';
1824:

Line 1855: FROM ZX_PARTY_TAX_PROFILE

1851: l_ship_from_party_id := p_party_id_tbl(ship_from_tx_id_tab(i));
1852: ELSE
1853: SELECT party_id
1854: INTO l_ship_from_party_id
1855: FROM ZX_PARTY_TAX_PROFILE
1856: WHERE party_tax_profile_id = ship_from_tx_id_tab(i);
1857:
1858: p_party_id_tbl(ship_from_tx_id_tab(i)) := l_ship_from_party_id;
1859: END IF;

Line 2106: zx_party_tax_profile ptp

2102: BEGIN
2103: SELECT pty.party_number
2104: INTO arp_customer_code_tab(i)
2105: FROM hz_parties pty,
2106: zx_party_tax_profile ptp
2107: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2108: AND ptp.party_id = pty.party_id;
2109: EXCEPTION WHEN OTHERS THEN
2110: arp_customer_code_tab(i) := NULL;

Line 2138: zx_party_tax_profile ptp

2134: BEGIN
2135: SELECT pty.party_number
2136: INTO arp_customer_code_tab(i)
2137: FROM hz_parties pty,
2138: zx_party_tax_profile ptp
2139: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2140: AND ptp.party_id = pty.party_id;
2141: EXCEPTION WHEN OTHERS THEN
2142: arp_customer_code_tab(i) := NULL;

Line 2160: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

2156:
2157: PROCEDURE DERIVE_CUSTOMER_CLASS
2158: IS
2159:
2160: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2161: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2162: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_CLASS';
2163:
2164: BEGIN

Line 2161: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2157: PROCEDURE DERIVE_CUSTOMER_CLASS
2158: IS
2159:
2160: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2161: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2162: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_CLASS';
2163:
2164: BEGIN
2165: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2176: FROM zx_party_tax_profile

2172: l_party_id := p_party_id_tbl(l_ptp_id);
2173: ELSE
2174: SELECT party_id
2175: INTO l_party_id
2176: FROM zx_party_tax_profile
2177: WHERE party_tax_profile_id = l_ptp_id;
2178: p_party_id_tbl(l_ptp_id) := l_party_id;
2179: END IF;
2180: END IF; --- Bug 6024643