DBA Data[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on PN_PAYMENT_TERMS

Line 5: p_tax_code_id pn_payment_terms.tax_code_id%TYPE,

1: PACKAGE pn_r12_util_pkg 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:

Line 7: p_as_of_date pn_payment_terms.start_date%TYPE)

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,

Line 11: p_tcc pn_payment_terms.tax_classification_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:

Line 23: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE DEFAULT NULL,

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,

Line 24: p_term_template_id IN pn_payment_terms.term_template_id%TYPE DEFAULT NULL,

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)

Line 25: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,

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;

Line 26: p_org_id IN pn_payment_terms.org_id%TYPE,

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:

Line 35: p_customer_id pn_payment_terms.customer_id%TYPE

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:

Line 36: ,p_transaction_type_id pn_payment_terms.cust_trx_type_id%TYPE

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(

Line 37: ,p_org_id pn_payment_terms.org_id%TYPE)

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

Line 42: ,p_location_id pn_payment_terms.vendor_site_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,

Line 43: ,p_org_id pn_payment_terms.org_id%TYPE)

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)

Line 59: FUNCTION check_tax_upgrade (p_tax_code_id pn_payment_terms.tax_code_id%TYPE,

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:

Line 60: p_tax_group_id pn_payment_terms.tax_group_id%TYPE,

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)