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 1513: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1509: | 21-Jun-04 Sudhir Sekuri Bug 3611046 |
1510: *----------------------------------------------------------------------------*/
1511:
1512: FUNCTION get_site_tax (
1513: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1514: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1515: RETURN VARCHAR2 IS
1516:
1517: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;

Line 1520: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;

1516:
1517: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;
1518: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1519: l_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1520: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;
1521: l_ret_record_level VARCHAR2(30);
1522: l_return_status VARCHAR2(80);
1523: l_error_buffer VARCHAR2(100);
1524:

Line 1529: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,

1525: l_parent_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1526: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;
1527:
1528: CURSOR get_site_tax_info
1529: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,
1530: c_org_id NUMBER,
1531: c_trx_date date)
1532: IS
1533: SELECT su.tax_code

Line 1534: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l

1530: c_org_id NUMBER,
1531: c_trx_date date)
1532: IS
1533: SELECT su.tax_code
1534: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l
1535: WHERE su.site_use_id = c_site_use_id
1536: AND su.org_id = c_org_id
1537: AND l.lookup_code = su.tax_code
1538: AND l.org_id IN (c_org_id, -99)

Line 1636: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1632: | clause to have RA_CUSTORMER preceding AR_VAT_TAX. |
1633: *----------------------------------------------------------------------------*/
1634:
1635: FUNCTION get_customer_tax (
1636: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1637: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1638: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1639: RETURN VARCHAR2 IS
1640:

Line 1650: (c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)

1646: l_error_buffer VARCHAR2(100);
1647:
1648:
1649: CURSOR get_customer_id
1650: (c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1651: IS
1652: SELECT CUST_ACCT.cust_account_id
1653: FROM HZ_CUST_ACCOUNTS CUST_ACCT,
1654: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,

Line 1655: HZ_CUST_SITE_USES CUST_SITE_USES

1651: IS
1652: SELECT CUST_ACCT.cust_account_id
1653: FROM HZ_CUST_ACCOUNTS CUST_ACCT,
1654: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,
1655: HZ_CUST_SITE_USES CUST_SITE_USES
1656: WHERE CUST_ACCT.cust_account_id = CUST_ACCT_SITES.cust_account_id
1657: AND CUST_ACCT_SITES.cust_acct_site_id = CUST_SITE_USES.cust_acct_site_id
1658: AND CUST_SITE_USES.site_use_id = c_site_use_id;
1659:

Line 1940: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

1936: -- Bug#3945805
1937: /******************************
1938: FUNCTION get_location_tax (
1939: p_product IN VARCHAR2,
1940: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1941: p_party_flag IN VARCHAR2,
1942: p_party_location_id IN hz_locations.location_id%type) RETURN VARCHAR2 IS
1943:
1944: l_country hz_locations.country%TYPE := null;

Line 1950: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)

1946:
1947: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1948:
1949: CURSOR sel_addr_country(
1950: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1951: IS
1952: SELECT loc.country
1953: FROM HZ_CUST_ACCT_SITES acct_site,
1954: HZ_PARTY_SITES party_site,

Line 1956: HZ_CUST_SITE_USES site_uses

1952: SELECT loc.country
1953: FROM HZ_CUST_ACCT_SITES acct_site,
1954: HZ_PARTY_SITES party_site,
1955: HZ_LOCATIONS loc,
1956: HZ_CUST_SITE_USES site_uses
1957: WHERE site_uses.site_use_id = c_site_use_id
1958: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
1959: AND acct_site.party_site_id = party_site.party_site_id
1960: AND loc.location_id = party_site.location_id;