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.

APPS.PN_VARIABLE_TERM_PKG dependencies on PN_PAYMENT_TERMS

Line 173: FROM pn_payment_terms_all

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

Line 191: l_term_temp_id pn_payment_terms.term_template_id%TYPE;

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

Line 361: FROM pn_payment_terms_all

357:
358: term_count := 0;
359:
360: SELECT count(*) INTO term_count
361: FROM pn_payment_terms_all
362: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id
363: AND var_rent_type = 'FORECASTED';
364:
365: IF term_count > 0 THEN

Line 459: FROM pn_payment_terms_all

455:
456: term_count := 0;
457:
458: SELECT count(*) INTO term_count
459: FROM pn_payment_terms_all
460: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
461: AND var_rent_type = 'VARIANCE';
462:
463: IF term_count > 0 THEN

Line 568: FROM pn_payment_terms_all

564:
565: term_count := 0;
566:
567: SELECT count(*) INTO term_count
568: FROM pn_payment_terms_all
569: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
570: AND var_rent_type = 'ACTUAL';
571:
572: IF term_count > 0 THEN

Line 679: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;

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

Line 686: l_frequency pn_payment_terms.frequency_code%type;

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

Line 687: l_schedule_day pn_payment_terms.schedule_day%type;

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

Line 690: l_area pn_payment_terms.area%TYPE;

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

Line 691: l_area_type_code pn_payment_terms.area_type_code%TYPE;

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

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

874: p_area_type_code => l_area_type_code);
875:
876: END IF;
877:
878: l_context := 'Inserting into pn_payment_terms';
879:
880: FOR rec IN currency_code_cur LOOP
881: l_currency_code := rec.currency_code;
882: END LOOP;

Line 1040: FROM pn_payment_terms_all

1036:
1037: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1038: SELECT count(*)
1039: INTO term_count
1040: FROM pn_payment_terms_all
1041: WHERE var_rent_inv_id = p_var_rent_inv_id
1042: AND var_rent_type = 'ACTUAL';
1043:
1044: IF term_count > 0 THEN

Line 1082: FROM pn_payment_terms_all

1078:
1079: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1080: SELECT count(*)
1081: INTO term_count
1082: FROM pn_payment_terms_all
1083: WHERE var_rent_inv_id = p_var_rent_inv_id
1084: AND var_rent_type = 'ACTUAL';
1085:
1086: IF term_count > 0 THEN

Line 1813: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;

1809: ) IS
1810:
1811:
1812: l_distribution_id pn_distributions.distribution_id%TYPE;
1813: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
1814: l_rowid ROWID;
1815: l_distribution_count NUMBER := 0;
1816: l_context varchar2(2000);
1817:

Line 1827: FROM pn_payment_terms_all

1823:
1824: CURSOR payment_term_cur
1825: IS
1826: SELECT *
1827: FROM pn_payment_terms_all
1828: WHERE payment_term_id = p_payment_term_id;
1829:
1830: term_count NUMBER := 0;
1831:

Line 1991: FROM pn_payment_terms_all

1987:
1988: IF p_var_rent_type <> 'ADJUSTMENT' THEN
1989: SELECT count(*)
1990: INTO term_count
1991: FROM pn_payment_terms_all
1992: WHERE var_rent_inv_id = p_var_rent_inv_id
1993: AND var_rent_type = 'ACTUAL';
1994:
1995: IF term_count > 0 THEN

Line 2034: FROM pn_payment_terms_all

2030:
2031: IF p_var_rent_type <> 'ADJUSTMENT' THEN
2032: SELECT count(*)
2033: INTO term_count
2034: FROM pn_payment_terms_all
2035: WHERE var_rent_inv_id = p_var_rent_inv_id
2036: AND var_rent_type = 'ACTUAL';
2037:
2038: IF term_count > 0 THEN