eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on PN_PAYMENT_TERMS

Line 12: p_tax_code_id pn_payment_terms.tax_code_id%TYPE,

8: -- HISTORY
9: -- 09-MAY-05 ftanudja o created.
10: --------------------------------------------------------------------------
11: FUNCTION get_tcc (
12: p_tax_code_id pn_payment_terms.tax_code_id%TYPE,
13: p_lease_class_code pn_leases.lease_class_code%TYPE,
14: p_as_of_date pn_payment_terms.start_date%TYPE)
15: RETURN VARCHAR2
16: IS

Line 14: p_as_of_date pn_payment_terms.start_date%TYPE)

10: --------------------------------------------------------------------------
11: FUNCTION get_tcc (
12: p_tax_code_id pn_payment_terms.tax_code_id%TYPE,
13: p_lease_class_code pn_leases.lease_class_code%TYPE,
14: p_as_of_date pn_payment_terms.start_date%TYPE)
15: RETURN VARCHAR2
16: IS
17: CURSOR tcc_info (p_source VARCHAR2) IS
18: SELECT tax_classification_code

Line 26: l_tcc pn_payment_terms.tax_classification_code%TYPE;

22: AND tax_rate_code_id = p_tax_code_id
23: AND source = p_source;
24:
25: l_source VARCHAR2(30);
26: l_tcc pn_payment_terms.tax_classification_code%TYPE;
27: l_desc VARCHAR2(100);
28:
29: BEGIN
30:

Line 62: p_tcc pn_payment_terms.tax_classification_code%TYPE,

58: -- Rewrote the procedure to fetch TCC Billing/Payment
59: -- from E Tax Views
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

Line 129: l_tcc pn_payment_terms.tax_classification_code%TYPE;

125: p_lease_cls_code IN VARCHAR2)
126: RETURN BOOLEAN IS
127:
128: l_answer BOOLEAN := TRUE;
129: l_tcc pn_payment_terms.tax_classification_code%TYPE;
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

Line 190: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,

186: FUNCTION is_le_compatible(
187: p_ccid1 IN pn_distributions.account_id%TYPE,
188: p_ccid2 IN pn_distributions.account_id%TYPE,
189: p_le_id_old IN NUMBER,
190: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
191: p_org_id IN pn_payment_terms.org_id%TYPE)
192:
193: RETURN BOOLEAN IS
194:

Line 191: p_org_id IN pn_payment_terms.org_id%TYPE)

187: p_ccid1 IN pn_distributions.account_id%TYPE,
188: p_ccid2 IN pn_distributions.account_id%TYPE,
189: p_le_id_old IN NUMBER,
190: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
191: p_org_id IN pn_payment_terms.org_id%TYPE)
192:
193: RETURN BOOLEAN IS
194:
195: l_le_rec_new xle_businessinfo_grp.ptop_le_rec;

Line 272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,

268: -- 16-OCT-05 sdmahesh o Modified cursors to fetch legal_entity_id
269: --------------------------------------------------------------------------
270: FUNCTION is_le_compatible(
271: p_ccid IN pn_distributions.account_id%TYPE,
272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,
273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,
274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
275: p_org_id IN pn_payment_terms.org_id%TYPE,
276: p_distribution_id IN pn_distributions.distribution_id%TYPE,

Line 273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,

269: --------------------------------------------------------------------------
270: FUNCTION is_le_compatible(
271: p_ccid IN pn_distributions.account_id%TYPE,
272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,
273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,
274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
275: p_org_id IN pn_payment_terms.org_id%TYPE,
276: p_distribution_id IN pn_distributions.distribution_id%TYPE,
277: p_mode IN VARCHAR2)

Line 274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,

270: FUNCTION is_le_compatible(
271: p_ccid IN pn_distributions.account_id%TYPE,
272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,
273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,
274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
275: p_org_id IN pn_payment_terms.org_id%TYPE,
276: p_distribution_id IN pn_distributions.distribution_id%TYPE,
277: p_mode IN VARCHAR2)
278: RETURN BOOLEAN IS

Line 275: p_org_id IN pn_payment_terms.org_id%TYPE,

271: p_ccid IN pn_distributions.account_id%TYPE,
272: p_payment_term_id IN pn_payment_terms.payment_term_id%TYPE,
273: p_term_template_id IN pn_payment_terms.term_template_id%TYPE,
274: p_vendor_site_id IN pn_payment_terms.vendor_site_id%TYPE,
275: p_org_id IN pn_payment_terms.org_id%TYPE,
276: p_distribution_id IN pn_distributions.distribution_id%TYPE,
277: p_mode IN VARCHAR2)
278: RETURN BOOLEAN IS
279:

Line 288: pn_payment_terms_all ppt

284: CURSOR chk_other_dist_ins IS
285: SELECT ppt.legal_entity_id le_id,
286: dist.account_id cc_id
287: FROM pn_distributions dist,
288: pn_payment_terms_all ppt
289: WHERE dist.payment_term_id = p_payment_term_id
290: AND ppt.payment_term_id = p_payment_term_id
291: AND rownum < 2;
292:

Line 306: pn_payment_terms_all ppt

302: CURSOR chk_other_dist_upd IS
303: SELECT ppt.legal_entity_id le_id,
304: dist.account_id cc_id
305: FROM pn_distributions dist,
306: pn_payment_terms_all ppt
307: WHERE dist.payment_term_id = p_payment_term_id
308: AND ppt.payment_term_id = p_payment_term_id
309: AND distribution_id <> p_distribution_id
310: AND rownum < 2;

Line 403: ,p_location_id pn_payment_terms.vendor_site_id%TYPE

399: -- 11-JUL-05 ftanudja o created.
400: --------------------------------------------------------------------------
401: FUNCTION get_le_for_ap(
402: p_code_combination_id pn_distributions.account_id%TYPE
403: ,p_location_id pn_payment_terms.vendor_site_id%TYPE
404: ,p_org_id pn_payment_terms.org_id%TYPE)
405: RETURN NUMBER IS
406:
407: l_le_rec_pay xle_businessinfo_grp.ptop_le_rec;

Line 404: ,p_org_id pn_payment_terms.org_id%TYPE)

400: --------------------------------------------------------------------------
401: FUNCTION get_le_for_ap(
402: p_code_combination_id pn_distributions.account_id%TYPE
403: ,p_location_id pn_payment_terms.vendor_site_id%TYPE
404: ,p_org_id pn_payment_terms.org_id%TYPE)
405: RETURN NUMBER IS
406:
407: l_le_rec_pay xle_businessinfo_grp.ptop_le_rec;
408: l_msg_data VARCHAR2(250);

Line 446: p_customer_id pn_payment_terms.customer_id%TYPE

442: -- 11-JUL-05 ftanudja o created.
443: -- 05-AUG-05 ftanudja o added call to mo_global. #4526616,#4497295.
444: --------------------------------------------------------------------------
445: FUNCTION get_le_for_ar(
446: p_customer_id pn_payment_terms.customer_id%TYPE
447: ,p_transaction_type_id pn_payment_terms.cust_trx_type_id%TYPE
448: ,p_org_id pn_payment_terms.org_id%TYPE)
449: RETURN NUMBER IS
450:

Line 447: ,p_transaction_type_id pn_payment_terms.cust_trx_type_id%TYPE

443: -- 05-AUG-05 ftanudja o added call to mo_global. #4526616,#4497295.
444: --------------------------------------------------------------------------
445: FUNCTION get_le_for_ar(
446: p_customer_id pn_payment_terms.customer_id%TYPE
447: ,p_transaction_type_id pn_payment_terms.cust_trx_type_id%TYPE
448: ,p_org_id pn_payment_terms.org_id%TYPE)
449: RETURN NUMBER IS
450:
451: l_le_rec_rec xle_businessinfo_grp.otoc_le_rec;

Line 448: ,p_org_id pn_payment_terms.org_id%TYPE)

444: --------------------------------------------------------------------------
445: FUNCTION get_le_for_ar(
446: p_customer_id pn_payment_terms.customer_id%TYPE
447: ,p_transaction_type_id pn_payment_terms.cust_trx_type_id%TYPE
448: ,p_org_id pn_payment_terms.org_id%TYPE)
449: RETURN NUMBER IS
450:
451: l_le_rec_rec xle_businessinfo_grp.otoc_le_rec;
452: l_msg_data VARCHAR2(250);

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

588: -- NOTES : for R12 release uptake
589: -- HISTORY
590: -- 09-JUN-06 Hareesha o Bug #5305903 Created.
591: -------------------------------------------------------------------------------
592: FUNCTION check_tax_upgrade (p_tax_code_id pn_payment_terms.tax_code_id%TYPE,
593: p_tax_group_id pn_payment_terms.tax_group_id%TYPE,
594: p_run_mode pn_leases.lease_class_code%TYPE)
595: RETURN VARCHAR2 IS
596:

Line 593: p_tax_group_id pn_payment_terms.tax_group_id%TYPE,

589: -- HISTORY
590: -- 09-JUN-06 Hareesha o Bug #5305903 Created.
591: -------------------------------------------------------------------------------
592: FUNCTION check_tax_upgrade (p_tax_code_id pn_payment_terms.tax_code_id%TYPE,
593: p_tax_group_id pn_payment_terms.tax_group_id%TYPE,
594: p_run_mode pn_leases.lease_class_code%TYPE)
595: RETURN VARCHAR2 IS
596:
597: l_tcc pn_payment_terms.tax_classification_code%TYPE;

Line 597: l_tcc pn_payment_terms.tax_classification_code%TYPE;

593: p_tax_group_id pn_payment_terms.tax_group_id%TYPE,
594: p_run_mode pn_leases.lease_class_code%TYPE)
595: RETURN VARCHAR2 IS
596:
597: l_tcc pn_payment_terms.tax_classification_code%TYPE;
598:
599: BEGIN
600: IF (p_tax_code_id IS NOT NULL OR p_tax_group_id IS NOT NULL)
601: THEN

Line 637: l_tcc pn_payment_terms.tax_classification_code%TYPE;

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:
639: BEGIN
640:
641: FOR rec IN get_term_temp_details LOOP