[Home] [Help]
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(
48: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
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:
53: FUNCTION get_item_tax(
54: p_item_id IN mtl_system_items.inventory_item_id%TYPE,
69: FUNCTION get_natural_acct_tax (
70: p_ccid IN NUMBER,
71: p_internal_organization_id IN NUMBER,
72: p_set_of_books_id IN ar_system_parameters.set_of_books_id%TYPE,
73: p_trx_date IN ra_customer_trx.trx_date%TYPE,
74: p_check_override_only IN VARCHAR2)
75: RETURN VARCHAR2;
76:
77:
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;
1518: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
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:
1641: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1642: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;
2091: FUNCTION get_natural_acct_tax (
2092: p_ccid IN NUMBER
2093: ,p_internal_organization_id IN NUMBER
2094: ,p_set_of_books_id IN ar_system_parameters.set_of_books_id%TYPE
2095: ,p_trx_date IN ra_customer_trx.trx_date%TYPE
2096: ,p_check_override_only IN VARCHAR2 ) RETURN VARCHAR2 IS
2097:
2098:
2099: -- l_tax_classification_code varchar2(30);