[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:
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;
1504: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
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:
1627: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1628: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;
2077: FUNCTION get_natural_acct_tax (
2078: p_ccid IN NUMBER
2079: ,p_internal_organization_id IN NUMBER
2080: ,p_set_of_books_id IN ar_system_parameters.set_of_books_id%TYPE
2081: ,p_trx_date IN ra_customer_trx.trx_date%TYPE
2082: ,p_check_override_only IN VARCHAR2 ) RETURN VARCHAR2 IS
2083:
2084:
2085: -- l_tax_classification_code varchar2(30);