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

1850: l_sfr_in_out_flag VARCHAR2(1);
1851: l_flag BOOLEAN;
1852: l_inventory_item_id NUMBER;
1853: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1854: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
1855:
1856: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';
1857:
1858: BEGIN

Line 1870: FROM ZX_PARTY_TAX_PROFILE

1866: l_ship_from_party_id := p_party_id_tbl(ship_from_tx_id_tab(i));
1867: ELSE
1868: SELECT party_id
1869: INTO l_ship_from_party_id
1870: FROM ZX_PARTY_TAX_PROFILE
1871: WHERE party_tax_profile_id = ship_from_tx_id_tab(i);
1872:
1873: p_party_id_tbl(ship_from_tx_id_tab(i)) := l_ship_from_party_id;
1874: END IF;

Line 2043: zx_party_tax_profile ptp

2039: BEGIN
2040: SELECT pty.party_number
2041: INTO arp_customer_code_tab(i)
2042: FROM hz_parties pty,
2043: zx_party_tax_profile ptp
2044: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2045: AND ptp.party_id = pty.party_id;
2046: EXCEPTION WHEN OTHERS THEN
2047: arp_customer_code_tab(i) := NULL;

Line 2075: zx_party_tax_profile ptp

2071: BEGIN
2072: SELECT pty.party_number
2073: INTO arp_customer_code_tab(i)
2074: FROM hz_parties pty,
2075: zx_party_tax_profile ptp
2076: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2077: AND ptp.party_id = pty.party_id;
2078: EXCEPTION WHEN OTHERS THEN
2079: arp_customer_code_tab(i) := NULL;

Line 2098: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;

2094:
2095: PROCEDURE DERIVE_CUSTOMER_NAME
2096: IS
2097:
2098: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2099: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2100: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_NAME';
2101:
2102: BEGIN

Line 2099: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

2095: PROCEDURE DERIVE_CUSTOMER_NAME
2096: IS
2097:
2098: l_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
2099: l_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
2100: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_CUSTOMER_NAME';
2101:
2102: BEGIN
2103: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2122: zx_party_tax_profile ptp

2118: BEGIN
2119: SELECT pty.party_name
2120: INTO arp_customer_name_tab(i)
2121: FROM hz_parties pty,
2122: zx_party_tax_profile ptp
2123: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2124: AND ptp.party_id = pty.party_id;
2125: EXCEPTION WHEN OTHERS THEN
2126: arp_customer_name_tab(i) := NULL;

Line 2150: zx_party_tax_profile ptp

2146: BEGIN
2147: SELECT pty.party_name
2148: INTO arp_customer_name_tab(i)
2149: FROM hz_parties pty,
2150: zx_party_tax_profile ptp
2151: WHERE ptp.party_tax_profile_id = bill_to_party_tax_id_tab(i)
2152: AND ptp.party_id = pty.party_id;
2153: EXCEPTION WHEN OTHERS THEN
2154: arp_customer_name_tab(i) := NULL;