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_OPEX_TERMS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 23: l_frequency pn_payment_terms_all.frequency_code%type;

19: l_distribution_count NUMBER := 0;
20: l_inv_start_date DATE;
21: l_payment_start_date DATE;
22: l_payment_end_date DATE;
23: l_frequency pn_payment_terms_all.frequency_code%type;
24: l_schedule_day pn_payment_terms_all.schedule_day%type;
25: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
26: l_context varchar2(2000);
27: l_area pn_payment_terms_all.area%TYPE;

Line 24: l_schedule_day pn_payment_terms_all.schedule_day%type;

20: l_inv_start_date DATE;
21: l_payment_start_date DATE;
22: l_payment_end_date DATE;
23: l_frequency pn_payment_terms_all.frequency_code%type;
24: l_schedule_day pn_payment_terms_all.schedule_day%type;
25: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
26: l_context varchar2(2000);
27: l_area pn_payment_terms_all.area%TYPE;
28: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;

Line 27: l_area pn_payment_terms_all.area%TYPE;

23: l_frequency pn_payment_terms_all.frequency_code%type;
24: l_schedule_day pn_payment_terms_all.schedule_day%type;
25: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
26: l_context varchar2(2000);
27: l_area pn_payment_terms_all.area%TYPE;
28: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;
29: l_org_id NUMBER;
30: l_schedule_day_char VARCHAR2(8);
31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

Line 28: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;

24: l_schedule_day pn_payment_terms_all.schedule_day%type;
25: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
26: l_context varchar2(2000);
27: l_area pn_payment_terms_all.area%TYPE;
28: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;
29: l_org_id NUMBER;
30: l_schedule_day_char VARCHAR2(8);
31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
32: i_cnt number;

Line 33: l_est_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;

29: l_org_id NUMBER;
30: l_schedule_day_char VARCHAR2(8);
31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
32: i_cnt number;
33: l_est_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
34: l_catch_up_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
35: l_currency_code pn_payment_terms_all.currency_code%TYPE;
36:
37:

Line 34: l_catch_up_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;

30: l_schedule_day_char VARCHAR2(8);
31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
32: i_cnt number;
33: l_est_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
34: l_catch_up_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
35: l_currency_code pn_payment_terms_all.currency_code%TYPE;
36:
37:
38: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)

Line 35: l_currency_code pn_payment_terms_all.currency_code%TYPE;

31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
32: i_cnt number;
33: l_est_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
34: l_catch_up_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
35: l_currency_code pn_payment_terms_all.currency_code%TYPE;
36:
37:
38: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
39: IS

Line 72: SELECT * FROM pn_payment_terms_all

68: -- Used to default the previous terms values and
69: -- could be used in case contraction is to be done.
70: CURSOR prev_pay_term_cur (arg_id IN NUMBER)
71: IS
72: SELECT * FROM pn_payment_terms_all
73: WHERE payment_term_id =
74: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all
75: WHERE opex_agr_id = arg_id
76: AND opex_type = 'ESTPMT');

Line 74: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all

70: CURSOR prev_pay_term_cur (arg_id IN NUMBER)
71: IS
72: SELECT * FROM pn_payment_terms_all
73: WHERE payment_term_id =
74: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all
75: WHERE opex_agr_id = arg_id
76: AND opex_type = 'ESTPMT');
77:
78: template_rec pn_term_templates_all%ROWTYPE;

Line 376: -- Updating the opex columns in the pn_payment_terms_all

372: ,x_area => l_area
373: ,x_area_type_code => l_area_type_code
374: );
375:
376: -- Updating the opex columns in the pn_payment_terms_all
377:
378: UPDATE pn_payment_terms_all
379: SET opex_agr_id = agreement_rec.agreement_id,
380: opex_type = 'ESTPMT'

Line 378: UPDATE pn_payment_terms_all

374: );
375:
376: -- Updating the opex columns in the pn_payment_terms_all
377:
378: UPDATE pn_payment_terms_all
379: SET opex_agr_id = agreement_rec.agreement_id,
380: opex_type = 'ESTPMT'
381: WHERE payment_term_id = l_est_payment_term_id;
382:

Line 484: -- Updating the opex columns in the pn_payment_terms_all

480: ,x_area => l_area
481: ,x_area_type_code => l_area_type_code
482: );
483:
484: -- Updating the opex columns in the pn_payment_terms_all
485:
486: UPDATE pn_payment_terms_all
487: SET opex_agr_id = agreement_rec.agreement_id,
488: opex_type = 'CATCHUP'

Line 486: UPDATE pn_payment_terms_all

482: );
483:
484: -- Updating the opex columns in the pn_payment_terms_all
485:
486: UPDATE pn_payment_terms_all
487: SET opex_agr_id = agreement_rec.agreement_id,
488: opex_type = 'CATCHUP'
489: WHERE payment_term_id = l_catch_up_payment_term_id;
490:

Line 624: l_frequency pn_payment_terms_all.frequency_code%type;

620: l_distribution_count NUMBER := 0;
621: l_inv_start_date DATE;
622: l_payment_start_date DATE;
623: l_payment_end_date DATE;
624: l_frequency pn_payment_terms_all.frequency_code%type;
625: l_schedule_day pn_payment_terms_all.schedule_day%type;
626: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
627: l_context varchar2(2000);
628: l_area pn_payment_terms_all.area%TYPE;

Line 625: l_schedule_day pn_payment_terms_all.schedule_day%type;

621: l_inv_start_date DATE;
622: l_payment_start_date DATE;
623: l_payment_end_date DATE;
624: l_frequency pn_payment_terms_all.frequency_code%type;
625: l_schedule_day pn_payment_terms_all.schedule_day%type;
626: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
627: l_context varchar2(2000);
628: l_area pn_payment_terms_all.area%TYPE;
629: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;

Line 628: l_area pn_payment_terms_all.area%TYPE;

624: l_frequency pn_payment_terms_all.frequency_code%type;
625: l_schedule_day pn_payment_terms_all.schedule_day%type;
626: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
627: l_context varchar2(2000);
628: l_area pn_payment_terms_all.area%TYPE;
629: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;
630: l_org_id NUMBER;
631: l_schedule_day_char VARCHAR2(8);
632: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

Line 629: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;

625: l_schedule_day pn_payment_terms_all.schedule_day%type;
626: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
627: l_context varchar2(2000);
628: l_area pn_payment_terms_all.area%TYPE;
629: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;
630: l_org_id NUMBER;
631: l_schedule_day_char VARCHAR2(8);
632: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
633: i_cnt number;

Line 634: l_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;

630: l_org_id NUMBER;
631: l_schedule_day_char VARCHAR2(8);
632: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
633: i_cnt number;
634: l_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
635: l_currency_code pn_payment_terms_all.currency_code%TYPE;
636:
637:
638: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)

Line 635: l_currency_code pn_payment_terms_all.currency_code%TYPE;

631: l_schedule_day_char VARCHAR2(8);
632: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
633: i_cnt number;
634: l_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
635: l_currency_code pn_payment_terms_all.currency_code%TYPE;
636:
637:
638: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
639: IS

Line 671: SELECT * FROM pn_payment_terms_all

667: -- Using the last estimated payment term to default the values in case present.
668:
669: CURSOR prev_pay_term_cur (arg_id IN NUMBER)
670: IS
671: SELECT * FROM pn_payment_terms_all
672: WHERE payment_term_id =
673: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all
674: WHERE opex_agr_id = arg_id
675: AND opex_type = 'ESTPMT');

Line 673: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all

669: CURSOR prev_pay_term_cur (arg_id IN NUMBER)
670: IS
671: SELECT * FROM pn_payment_terms_all
672: WHERE payment_term_id =
673: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all
674: WHERE opex_agr_id = arg_id
675: AND opex_type = 'ESTPMT');
676:
677:

Line 966: -- Updating the opex columns in the pn_payment_terms_all

962: ,x_term_template_id => CASE WHEN pay_term_rec.payment_term_id IS NULL THEN template_rec.term_template_id ELSE pay_term_rec.term_template_id END
963: ,x_area => l_area
964: ,x_area_type_code => l_area_type_code
965: );
966: -- Updating the opex columns in the pn_payment_terms_all
967:
968: UPDATE pn_payment_terms_all
969: SET opex_recon_id = p_recon_id,
970: opex_agr_id = p_agreement_id,

Line 968: UPDATE pn_payment_terms_all

964: ,x_area_type_code => l_area_type_code
965: );
966: -- Updating the opex columns in the pn_payment_terms_all
967:
968: UPDATE pn_payment_terms_all
969: SET opex_recon_id = p_recon_id,
970: opex_agr_id = p_agreement_id,
971: opex_type = 'RECON'
972: WHERE payment_term_id = l_payment_term_id;

Line 1079: FROM pn_payment_terms_all pmt,

1075: SELECT
1076: pmt.lease_id,
1077: ADD_MONTHS(TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy'),
1078: DECODE(max(pmt.frequency_code),'MON', 0, 'QTR', 2, 'SA', 5 , 'YR', 11)) as last_sch_date
1079: FROM pn_payment_terms_all pmt,
1080: pn_payment_schedules_all sch
1081: WHERE sch.payment_status_lookup_code = 'APPROVED'
1082: AND pmt.payment_term_id = c_pay_term_id
1083: AND sch.lease_id = c_lease_id

Line 1092: FROM pn_payment_terms_all pmt,

1088: /*CURSOR last_sch_day_cur( c_lease_id IN NUMBER , c_pay_term_id IN NUMBER) IS
1089: SELECT
1090: pmt.lease_id,
1091: (TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy')) as last_sch_date
1092: FROM pn_payment_terms_all pmt,
1093: pn_payment_schedules_all sch
1094: WHERE sch.payment_status_lookup_code = 'APPROVED'
1095: AND pmt.payment_term_id = c_pay_term_id
1096: AND sch.lease_id = c_lease_id

Line 1103: pn_payment_terms_all

1099:
1100:
1101: CURSOR payment_cur(pay_term_id IN NUMBER) IS
1102: SELECT * FROM
1103: pn_payment_terms_all
1104: WHERE payment_term_id = pay_term_id;
1105:
1106: last_sch_day_rec last_sch_day_cur%ROWTYPE;
1107: payment_rec payment_cur%ROWTYPE;

Line 1216: pnp_debug_pkg.put_log_msg('Updating pn_opex_est_payments_all and pn_payment_terms_all with date ' || prev_trm_end_date );

1212: END LOOP; /*sch cursor */
1213:
1214:
1215:
1216: pnp_debug_pkg.put_log_msg('Updating pn_opex_est_payments_all and pn_payment_terms_all with date ' || prev_trm_end_date );
1217:
1218: IF (prev_trm_end_date IS NOT NULL) THEN
1219:
1220: UPDATE pn_opex_est_payments_all

Line 1224: UPDATE pn_payment_terms_all

1220: UPDATE pn_opex_est_payments_all
1221: SET END_DATE = prev_trm_end_date
1222: Where payment_term_id = prev_pay_term_id;
1223:
1224: UPDATE pn_payment_terms_all
1225: SET END_DATE = prev_trm_end_date
1226: Where payment_term_id = prev_pay_term_id;
1227: END IF;
1228:

Line 1282: FROM pn_payment_terms_all pmt,

1278:
1279:
1280: CURSOR schedule_end_date_cur IS
1281: SELECT (to_date((substr(to_char(max(pmt.start_date),'dd-mm-yyyy'),1,2) || substr(to_char(max(sch.schedule_date),'dd-mm-yyyy'),3)), 'dd-mm-yyyy')) schedule_date
1282: FROM pn_payment_terms_all pmt,
1283: pn_payment_schedules_all sch,
1284: pn_opex_est_payments_all est
1285: WHERE pmt.payment_term_id = est.payment_term_id
1286: AND est.est_payment_id = p_payment_term_id

Line 1292: FROM pn_payment_terms_all pmt

1288: AND sch.lease_id = p_lease_id;
1289:
1290: CURSOR frequency_cur(p_pay_trm_id IN NUMBER) IS
1291: SELECT DECODE(pmt.FREQUENCY_CODE, 'MON', 1, 'QTR', 3, 'SA', 6 , 'YR', 12) frequency
1292: FROM pn_payment_terms_all pmt
1293: WHERE pmt.payment_term_id = p_pay_trm_id;
1294:
1295:
1296: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)

Line 1307: FROM pn_payment_terms_all pmt,

1303: SELECT
1304: pmt.lease_id,
1305: ADD_MONTHS(TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy'),
1306: DECODE(max(pmt.frequency_code),'MON', 0, 'QTR', 2, 'SA', 5 , 'YR', 11)) as last_sch_date
1307: FROM pn_payment_terms_all pmt,
1308: pn_payment_schedules_all sch
1309: WHERE sch.payment_status_lookup_code = 'APPROVED'
1310: AND pmt.payment_term_id = c_pay_term_id
1311: AND sch.lease_id = c_lease_id

Line 1387: FROM pn_payment_terms_all pmt,

1383:
1384:
1385: CURSOR schedule_end_date_cur IS
1386: SELECT (to_date((substr(to_char(max(pmt.start_date),'dd-mm-yyyy'),1,2) || substr(to_char(max(sch.schedule_date),'dd-mm-yyyy'),3)), 'dd-mm-yyyy')) schedule_date
1387: FROM pn_payment_terms_all pmt,
1388: pn_payment_schedules_all sch
1389: WHERE pmt.payment_term_id = p_payment_term_id
1390: AND sch.payment_status_lookup_code = 'APPROVED'
1391: AND sch.lease_id = p_lease_id;

Line 1395: FROM pn_payment_terms_all pmt

1391: AND sch.lease_id = p_lease_id;
1392:
1393: CURSOR frequency_cur IS
1394: SELECT DECODE(pmt.FREQUENCY_CODE, 'MON', 1, 'QTR', 3, 'SA', 6 , 'YR', 12) frequency
1395: FROM pn_payment_terms_all pmt
1396: WHERE pmt.payment_term_id = p_payment_term_id;
1397:
1398:
1399:

Line 1729: FROM pn_payment_terms_all

1725: BEGIN
1726: SELECT 'N' INTO l_deletion_allowed
1727: FROM DUAL WHERE EXISTS
1728: (SELECT payment_term_id
1729: FROM pn_payment_terms_all
1730: WHERE opex_agr_id = p_agreement_id
1731: AND status = 'APPROVED');
1732:
1733: EXCEPTION

Line 1777: DELETE FROM PN_PAYMENT_TERMS_ALL

1773: DELETE FROM PN_OPEX_NOTES_ALL
1774: WHERE recon_id = i.recon_id;
1775: END LOOP;
1776:
1777: DELETE FROM PN_PAYMENT_TERMS_ALL
1778: WHERE opex_agr_id = p_agreement_id;
1779:
1780: DELETE FROM PN_OPEX_AGREEMENTS_ALL
1781: WHERE agreement_id = p_agreement_id;

Line 2062: UPDATE pn_payment_terms_all

2058: --
2059: -- update status of payment term record
2060: --
2061:
2062: UPDATE pn_payment_terms_all
2063: SET status = 'APPROVED'
2064: ,last_update_date = SYSDATE
2065: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2066: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

Line 2146: pn_payment_terms_all ppt,

2142: loc.location_code,
2143: popex.created_by
2144: FROM pn_leases_all pl,
2145: pn_opex_agreements_all popex,
2146: pn_payment_terms_all ppt,
2147: pn_properties_all prop,
2148: pn_locations_all loc,
2149: pn_tenancies_all ten
2150: WHERE pl.lease_id = popex.lease_id

Line 2176: l_day pn_payment_terms_all.schedule_day%TYPE;

2172: l_errmsg VARCHAR2(2000);
2173: l_errmsg1 VARCHAR2(2000);
2174: l_return_status VARCHAR2 (2) := NULL;
2175: l_nxt_schdate DATE;
2176: l_day pn_payment_terms_all.schedule_day%TYPE;
2177: l_info VARCHAR2(1000);
2178: l_message VARCHAR2(2000) := NULL;
2179: l_appr_count NUMBER := 0;
2180: l_batch_size NUMBER := 1000;

Line 2320: pn_payment_terms_all term,

2316: CURSOR amt_cur(c_recon_id IN NUMBER) IS
2317:
2318: SELECT SUM(item.actual_amount) act_amt
2319: FROM pn_payment_items_all item,
2320: pn_payment_terms_all term,
2321: pn_opex_recon_all recon
2322: WHERE item.payment_item_type_lookup_code = 'CASH'
2323: AND item.payment_term_id = term.payment_term_id
2324: AND term.opex_recon_id = recon.recon_id