PACKAGE: APPS.PN_R12_UTIL_PKG

Source

1 PACKAGE pn_r12_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: PNUTL12S.pls 120.7 2006/06/21 04:50:00 hrodda noship $ */
3 
4 FUNCTION get_tcc (
5             p_tax_code_id        pn_payment_terms.tax_code_id%TYPE,
6             p_lease_class_code   pn_leases.lease_class_code%TYPE,
7             p_as_of_date         pn_payment_terms.start_date%TYPE)
8 RETURN VARCHAR2;
9 
10 FUNCTION get_tcc_name (
11             p_tcc                pn_payment_terms.tax_classification_code%TYPE,
12             p_lease_class_code   pn_leases.lease_class_code%TYPE,
13             p_org_id             pn_term_templates.org_id%TYPE)
14 RETURN VARCHAR2;
15 
16 FUNCTION validate_term_template_tax(
17            p_term_temp_id   IN    NUMBER,
18            p_lease_cls_code IN    VARCHAR2)
19 RETURN BOOLEAN;
20 
21 FUNCTION is_le_compatible(
22            p_ccid             IN pn_distributions.account_id%TYPE,
23            p_payment_term_id  IN pn_payment_terms.payment_term_id%TYPE DEFAULT NULL,
24            p_term_template_id IN pn_payment_terms.term_template_id%TYPE DEFAULT NULL,
25            p_vendor_site_id   IN pn_payment_terms.vendor_site_id%TYPE,
26            p_org_id           IN pn_payment_terms.org_id%TYPE,
27            p_distribution_id  IN pn_distributions.distribution_id%TYPE DEFAULT NULL,
28            p_mode             IN VARCHAR2)
29 RETURN BOOLEAN;
30 
31 FUNCTION is_r12
32 RETURN BOOLEAN;
33 
34 FUNCTION get_le_for_ar(
35            p_customer_id         pn_payment_terms.customer_id%TYPE
36           ,p_transaction_type_id pn_payment_terms.cust_trx_type_id%TYPE
37           ,p_org_id              pn_payment_terms.org_id%TYPE)
38 RETURN NUMBER;
39 
40 FUNCTION get_le_for_ap(
41            p_code_combination_id pn_distributions.account_id%TYPE
42           ,p_location_id         pn_payment_terms.vendor_site_id%TYPE
43           ,p_org_id              pn_payment_terms.org_id%TYPE)
44 RETURN NUMBER;
45 
46 FUNCTION get_tax_flag(p_vendor_id      IN NUMBER,
47                       p_vendor_site_id IN NUMBER)
48 RETURN VARCHAR2;
49 
50 FUNCTION get_ap_tax_code_name(p_tax_id IN NUMBER)
51 RETURN VARCHAR2;
52 
53 FUNCTION get_ar_tax_code_name (p_tax_id IN NUMBER)
54 RETURN VARCHAR2;
55 
56 FUNCTION get_tax_group ( p_tax_group_id   NUMBER)
57 RETURN VARCHAR2;
58 
59 FUNCTION check_tax_upgrade (p_tax_code_id  pn_payment_terms.tax_code_id%TYPE,
60                             p_tax_group_id pn_payment_terms.tax_group_id%TYPE,
61                             p_run_mode     pn_leases.lease_class_code%TYPE)
62 RETURN VARCHAR2;
63 
64 FUNCTION check_tax_upgrade (p_term_template_id pn_term_templates.term_template_id%TYPE)
65 RETURN VARCHAR2;
66 
67 END pn_r12_util_pkg;