eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on HZ_CUST_SITE_USES

Line 43: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

39: -- Forward declarations
40: --
41:
42: FUNCTION get_site_tax(
43: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
44: p_trx_date IN ra_customer_trx.trx_date%TYPE)
45: RETURN VARCHAR2;
46:
47: FUNCTION get_customer_tax(

Line 48: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

44: p_trx_date IN ra_customer_trx.trx_date%TYPE)
45: RETURN VARCHAR2;
46:
47: FUNCTION get_customer_tax(
48: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
49: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
50: p_trx_date IN ra_customer_trx.trx_date%TYPE )
51: RETURN VARCHAR2;
52:

Line 63: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

59: /*******
60: -- Bug#3945805
61: FUNCTION get_location_tax(
62: p_product IN VARCHAR2,
63: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
64: p_party_flag IN VARCHAR2,
65: p_party_location_id IN hz_locations.location_id%type default null)
66: RETURN VARCHAR2;
67:

Line 1499: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1495: | 21-Jun-04 Sudhir Sekuri Bug 3611046 |
1496: *----------------------------------------------------------------------------*/
1497:
1498: FUNCTION get_site_tax (
1499: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1500: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1501: RETURN VARCHAR2 IS
1502:
1503: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;

Line 1506: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;

1502:
1503: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;
1504: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1505: l_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1506: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;
1507: l_ret_record_level VARCHAR2(30);
1508: l_return_status VARCHAR2(80);
1509: l_error_buffer VARCHAR2(100);
1510:

Line 1515: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,

1511: l_parent_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1512: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;
1513:
1514: CURSOR get_site_tax_info
1515: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,
1516: c_org_id NUMBER,
1517: c_trx_date date)
1518: IS
1519: SELECT su.tax_code

Line 1520: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l

1516: c_org_id NUMBER,
1517: c_trx_date date)
1518: IS
1519: SELECT su.tax_code
1520: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l
1521: WHERE su.site_use_id = c_site_use_id
1522: AND su.org_id = c_org_id
1523: AND l.lookup_code = su.tax_code
1524: AND l.org_id IN (c_org_id, -99)

Line 1622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1618: | clause to have RA_CUSTORMER preceding AR_VAT_TAX. |
1619: *----------------------------------------------------------------------------*/
1620:
1621: FUNCTION get_customer_tax (
1622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1623: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1624: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1625: RETURN VARCHAR2 IS
1626:

Line 1636: (c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)

1632: l_error_buffer VARCHAR2(100);
1633:
1634:
1635: CURSOR get_customer_id
1636: (c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1637: IS
1638: SELECT CUST_ACCT.cust_account_id
1639: FROM HZ_CUST_ACCOUNTS CUST_ACCT,
1640: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,

Line 1641: HZ_CUST_SITE_USES CUST_SITE_USES

1637: IS
1638: SELECT CUST_ACCT.cust_account_id
1639: FROM HZ_CUST_ACCOUNTS CUST_ACCT,
1640: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,
1641: HZ_CUST_SITE_USES CUST_SITE_USES
1642: WHERE CUST_ACCT.cust_account_id = CUST_ACCT_SITES.cust_account_id
1643: AND CUST_ACCT_SITES.cust_acct_site_id = CUST_SITE_USES.cust_acct_site_id
1644: AND CUST_SITE_USES.site_use_id = c_site_use_id;
1645:

Line 1926: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1922: -- Bug#3945805
1923: /******************************
1924: FUNCTION get_location_tax (
1925: p_product IN VARCHAR2,
1926: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1927: p_party_flag IN VARCHAR2,
1928: p_party_location_id IN hz_locations.location_id%type) RETURN VARCHAR2 IS
1929:
1930: l_country hz_locations.country%TYPE := null;

Line 1936: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)

1932:
1933: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1934:
1935: CURSOR sel_addr_country(
1936: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1937: IS
1938: SELECT loc.country
1939: FROM HZ_CUST_ACCT_SITES acct_site,
1940: HZ_PARTY_SITES party_site,

Line 1942: HZ_CUST_SITE_USES site_uses

1938: SELECT loc.country
1939: FROM HZ_CUST_ACCT_SITES acct_site,
1940: HZ_PARTY_SITES party_site,
1941: HZ_LOCATIONS loc,
1942: HZ_CUST_SITE_USES site_uses
1943: WHERE site_uses.site_use_id = c_site_use_id
1944: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
1945: AND acct_site.party_site_id = party_site.party_site_id
1946: AND loc.location_id = party_site.location_id;