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_VARIABLE_TERM_PKG dependencies on PN_PAYMENT_TERMS

Line 176: FROM pn_payment_terms_all

172: ORDER BY inv.invoice_date;
173:
174: CURSOR payment_cur(p_invoice_date DATE,p_var_rent_id NUMBER) IS
175: SELECT payment_term_id
176: FROM pn_payment_terms_all
177: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
178: FROM pn_var_rent_inv_all
179: WHERE invoice_date = p_invoice_date
180: AND var_rent_id = p_var_rent_id);

Line 194: l_term_temp_id pn_payment_terms.term_template_id%TYPE;

190: l_pre_var_rent_id pn_var_rents.var_rent_id%type;
191: l_context VARCHAR2(2000);
192: l_errmsg VARCHAR2(2000);
193: l_org_id pn_leases.org_id%type;
194: l_term_temp_id pn_payment_terms.term_template_id%TYPE;
195: l_lease_cls_code pn_leases.lease_class_code%TYPE;
196: l_err_flag VARCHAR2(1);
197: l_inv_sch_date DATE;
198: l_inv_start_date DATE;

Line 365: FROM pn_payment_terms_all

361:
362: term_count := 0;
363:
364: SELECT count(*) INTO term_count
365: FROM pn_payment_terms_all
366: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id
367: AND var_rent_type = 'FORECASTED';
368:
369: IF term_count > 0 THEN

Line 463: FROM pn_payment_terms_all

459:
460: term_count := 0;
461:
462: SELECT count(*) INTO term_count
463: FROM pn_payment_terms_all
464: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
465: AND var_rent_type = 'VARIANCE';
466:
467: IF term_count > 0 THEN

Line 572: FROM pn_payment_terms_all

568:
569: term_count := 0;
570:
571: SELECT count(*) INTO term_count
572: FROM pn_payment_terms_all
573: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
574: AND var_rent_type = 'ACTUAL';
575:
576: IF term_count > 0 THEN

Line 683: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;

679: ) IS
680:
681: l_lease_class_code pn_leases.lease_class_code%TYPE;
682: l_distribution_id pn_distributions.distribution_id%TYPE;
683: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
684: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
685: l_rowid ROWID;
686: l_distribution_count NUMBER := 0;
687: l_inv_start_date DATE;

Line 690: l_frequency pn_payment_terms.frequency_code%type;

686: l_distribution_count NUMBER := 0;
687: l_inv_start_date DATE;
688: l_payment_start_date DATE;
689: l_payment_end_date DATE;
690: l_frequency pn_payment_terms.frequency_code%type;
691: l_schedule_day pn_payment_terms.schedule_day%type;
692: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
693: l_context varchar2(2000);
694: l_area pn_payment_terms.area%TYPE;

Line 691: l_schedule_day pn_payment_terms.schedule_day%type;

687: l_inv_start_date DATE;
688: l_payment_start_date DATE;
689: l_payment_end_date DATE;
690: l_frequency pn_payment_terms.frequency_code%type;
691: l_schedule_day pn_payment_terms.schedule_day%type;
692: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
693: l_context varchar2(2000);
694: l_area pn_payment_terms.area%TYPE;
695: l_area_type_code pn_payment_terms.area_type_code%TYPE;

Line 694: l_area pn_payment_terms.area%TYPE;

690: l_frequency pn_payment_terms.frequency_code%type;
691: l_schedule_day pn_payment_terms.schedule_day%type;
692: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
693: l_context varchar2(2000);
694: l_area pn_payment_terms.area%TYPE;
695: l_area_type_code pn_payment_terms.area_type_code%TYPE;
696: l_org_id NUMBER;
697: l_schedule_day_char VARCHAR2(8);
698: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

Line 695: l_area_type_code pn_payment_terms.area_type_code%TYPE;

691: l_schedule_day pn_payment_terms.schedule_day%type;
692: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
693: l_context varchar2(2000);
694: l_area pn_payment_terms.area%TYPE;
695: l_area_type_code pn_payment_terms.area_type_code%TYPE;
696: l_org_id NUMBER;
697: l_schedule_day_char VARCHAR2(8);
698: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
699: i_cnt number;

Line 882: l_context := 'Inserting into pn_payment_terms';

878: p_area_type_code => l_area_type_code);
879:
880: END IF;
881:
882: l_context := 'Inserting into pn_payment_terms';
883:
884: FOR rec IN currency_code_cur LOOP
885: l_currency_code := rec.currency_code;
886: END LOOP;

Line 1044: FROM pn_payment_terms_all

1040:
1041: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1042: SELECT count(*)
1043: INTO term_count
1044: FROM pn_payment_terms_all
1045: WHERE var_rent_inv_id = p_var_rent_inv_id
1046: AND var_rent_type = 'ACTUAL';
1047:
1048: IF term_count > 0 THEN

Line 1086: FROM pn_payment_terms_all

1082:
1083: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1084: SELECT count(*)
1085: INTO term_count
1086: FROM pn_payment_terms_all
1087: WHERE var_rent_inv_id = p_var_rent_inv_id
1088: AND var_rent_type = 'ACTUAL';
1089:
1090: IF term_count > 0 THEN

Line 1817: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;

1813: ) IS
1814:
1815:
1816: l_distribution_id pn_distributions.distribution_id%TYPE;
1817: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
1818: l_rowid ROWID;
1819: l_distribution_count NUMBER := 0;
1820: l_context varchar2(2000);
1821:

Line 1831: FROM pn_payment_terms_all

1827:
1828: CURSOR payment_term_cur
1829: IS
1830: SELECT *
1831: FROM pn_payment_terms_all
1832: WHERE payment_term_id = p_payment_term_id;
1833:
1834: term_count NUMBER := 0;
1835:

Line 1995: FROM pn_payment_terms_all

1991:
1992: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1993: SELECT count(*)
1994: INTO term_count
1995: FROM pn_payment_terms_all
1996: WHERE var_rent_inv_id = p_var_rent_inv_id
1997: AND var_rent_type = 'ACTUAL';
1998:
1999: IF term_count > 0 THEN

Line 2038: FROM pn_payment_terms_all

2034:
2035: IF p_var_rent_type <> 'ADJUSTMENT' THEN
2036: SELECT count(*)
2037: INTO term_count
2038: FROM pn_payment_terms_all
2039: WHERE var_rent_inv_id = p_var_rent_inv_id
2040: AND var_rent_type = 'ACTUAL';
2041:
2042: IF term_count > 0 THEN