APPS.PN_R12_UTIL_PKG dependencies on PN_TERM_TEMPLATES

Line 64: p_org_id pn_term_templates.org_id%TYPE)

60: --------------------------------------------------------------------------
61: FUNCTION get_tcc_name (
62: p_tcc pn_payment_terms.tax_classification_code%TYPE,
63: p_lease_class_code pn_leases.lease_class_code%TYPE,
64: p_org_id pn_term_templates.org_id%TYPE)
65:
66: RETURN VARCHAR2
67: IS
68:

Line 134: FROM pn_term_templates

130: l_desc VARCHAR2(100);
131:
132: CURSOR term_temp_cur(p_term_temp_id IN NUMBER) IS
133: SELECT tax_code_id, tax_group_id, tax_classification_code
134: FROM pn_term_templates
135: WHERE term_template_id = p_term_temp_id;
136:
137: BEGIN
138:

Line 625: FUNCTION check_tax_upgrade (p_term_template_id pn_term_templates.term_template_id%TYPE)

621: -- NOTES : for R12 release uptake
622: -- HISTORY
623: -- 09-JUN-06 Hareesha o Bug #5305903 Created.
624: -------------------------------------------------------------------------------
625: FUNCTION check_tax_upgrade (p_term_template_id pn_term_templates.term_template_id%TYPE)
626: RETURN VARCHAR2 IS
627:
628: CURSOR get_term_temp_details IS
629: SELECT org_id,

Line 634: FROM pn_term_templates_all

630: tax_code_id,
631: tax_group_id,
632: tax_classification_code,
633: term_template_type
634: FROM pn_term_templates_all
635: WHERE term_template_id = p_term_template_id;
636:
637: l_tcc pn_payment_terms.tax_classification_code%TYPE;
638:

Line 655: UPDATE pn_term_templates_all

651:
652: IF l_tcc IS NULL THEN
653: RETURN 'PN_NO_TCC_FOUND';
654: ELSE
655: UPDATE pn_term_templates_all
656: SET tax_classification_code = l_tcc,
657: tax_code_id = NULL,
658: tax_group_id = NULL
659: WHERE term_template_id = p_term_template_id;