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 1084: FROM pn_payment_terms_all pmt,

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

Line 1097: FROM pn_payment_terms_all pmt,

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

Line 1108: pn_payment_terms_all

1104:
1105:
1106: CURSOR payment_cur(pay_term_id IN NUMBER) IS
1107: SELECT * FROM
1108: pn_payment_terms_all
1109: WHERE payment_term_id = pay_term_id;
1110:
1111: last_sch_day_rec last_sch_day_cur%ROWTYPE;
1112: payment_rec payment_cur%ROWTYPE;

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

1224: END LOOP; /*sch cursor */
1225:
1226:
1227:
1228: pnp_debug_pkg.put_log_msg('Updating pn_opex_est_payments_all and pn_payment_terms_all with date ' || prev_trm_end_date );
1229:
1230: IF (prev_trm_end_date IS NOT NULL) THEN
1231:
1232: IF l_approved_item_count = 0

Line 1241: delete from pn_payment_terms_all

1237:
1238: delete from pn_distributions_all
1239: where payment_term_id = prev_pay_term_id;
1240:
1241: delete from pn_payment_terms_all
1242: where payment_term_id = prev_pay_term_id;
1243:
1244: ELSE
1245: UPDATE pn_opex_est_payments_all

Line 1249: UPDATE pn_payment_terms_all

1245: UPDATE pn_opex_est_payments_all
1246: SET END_DATE = prev_trm_end_date
1247: Where payment_term_id = prev_pay_term_id;
1248:
1249: UPDATE pn_payment_terms_all
1250: SET END_DATE = prev_trm_end_date
1251: Where payment_term_id = prev_pay_term_id;
1252: END IF;
1253: END IF;

Line 1311: FROM pn_payment_terms_all pmt,

1307:
1308:
1309: CURSOR schedule_end_date_cur IS
1310: 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
1311: FROM pn_payment_terms_all pmt,
1312: pn_payment_schedules_all sch,
1313: pn_opex_est_payments_all est
1314: WHERE pmt.payment_term_id = est.payment_term_id
1315: AND est.est_payment_id = p_payment_term_id

Line 1321: FROM pn_payment_terms_all pmt

1317: AND sch.lease_id = p_lease_id;
1318:
1319: CURSOR frequency_cur(p_pay_trm_id IN NUMBER) IS
1320: SELECT DECODE(pmt.FREQUENCY_CODE, 'MON', 1, 'QTR', 3, 'SA', 6 , 'YR', 12) frequency
1321: FROM pn_payment_terms_all pmt
1322: WHERE pmt.payment_term_id = p_pay_trm_id;
1323:
1324:
1325: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)

Line 1336: FROM pn_payment_terms_all pmt,

1332: SELECT
1333: pmt.lease_id,
1334: ADD_MONTHS(TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy'),
1335: DECODE(max(pmt.frequency_code),'MON', 0, 'QTR', 2, 'SA', 5 , 'YR', 11)) as last_sch_date
1336: FROM pn_payment_terms_all pmt,
1337: pn_payment_schedules_all sch
1338: WHERE sch.payment_status_lookup_code = 'APPROVED'
1339: AND pmt.payment_term_id = c_pay_term_id
1340: AND sch.lease_id = c_lease_id

Line 1416: FROM pn_payment_terms_all pmt,

1412:
1413:
1414: CURSOR schedule_end_date_cur IS
1415: 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
1416: FROM pn_payment_terms_all pmt,
1417: pn_payment_schedules_all sch
1418: WHERE pmt.payment_term_id = p_payment_term_id
1419: AND sch.payment_status_lookup_code = 'APPROVED'
1420: AND sch.lease_id = p_lease_id;

Line 1424: FROM pn_payment_terms_all pmt

1420: AND sch.lease_id = p_lease_id;
1421:
1422: CURSOR frequency_cur IS
1423: SELECT DECODE(pmt.FREQUENCY_CODE, 'MON', 1, 'QTR', 3, 'SA', 6 , 'YR', 12) frequency
1424: FROM pn_payment_terms_all pmt
1425: WHERE pmt.payment_term_id = p_payment_term_id;
1426:
1427:
1428:

Line 1758: FROM pn_payment_terms_all

1754: BEGIN
1755: SELECT 'N' INTO l_deletion_allowed
1756: FROM DUAL WHERE EXISTS
1757: (SELECT payment_term_id
1758: FROM pn_payment_terms_all
1759: WHERE opex_agr_id = p_agreement_id
1760: AND status = 'APPROVED');
1761:
1762: EXCEPTION

Line 1806: DELETE FROM PN_PAYMENT_TERMS_ALL

1802: DELETE FROM PN_OPEX_NOTES_ALL
1803: WHERE recon_id = i.recon_id;
1804: END LOOP;
1805:
1806: DELETE FROM PN_PAYMENT_TERMS_ALL
1807: WHERE opex_agr_id = p_agreement_id;
1808:
1809: DELETE FROM PN_OPEX_AGREEMENTS_ALL
1810: WHERE agreement_id = p_agreement_id;

Line 2093: UPDATE pn_payment_terms_all

2089: --
2090: -- update status of payment term record
2091: --
2092:
2093: UPDATE pn_payment_terms_all
2094: SET status = 'APPROVED'
2095: ,last_update_date = SYSDATE
2096: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2097: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

Line 2177: pn_payment_terms_all ppt,

2173: loc.location_code,
2174: popex.created_by
2175: FROM pn_leases_all pl,
2176: pn_opex_agreements_all popex,
2177: pn_payment_terms_all ppt,
2178: pn_properties_all prop,
2179: pn_locations_all loc,
2180: pn_tenancies_all ten
2181: WHERE pl.lease_id = popex.lease_id

Line 2207: l_day pn_payment_terms_all.schedule_day%TYPE;

2203: l_errmsg VARCHAR2(2000);
2204: l_errmsg1 VARCHAR2(2000);
2205: l_return_status VARCHAR2 (2) := NULL;
2206: l_nxt_schdate DATE;
2207: l_day pn_payment_terms_all.schedule_day%TYPE;
2208: l_info VARCHAR2(1000);
2209: l_message VARCHAR2(2000) := NULL;
2210: l_appr_count NUMBER := 0;
2211: l_batch_size NUMBER := 1000;

Line 2351: pn_payment_terms_all term,

2347: CURSOR amt_cur(c_recon_id IN NUMBER) IS
2348:
2349: SELECT SUM(item.actual_amount) act_amt
2350: FROM pn_payment_items_all item,
2351: pn_payment_terms_all term,
2352: pn_opex_recon_all recon
2353: WHERE item.payment_item_type_lookup_code = 'CASH'
2354: AND item.payment_term_id = term.payment_term_id
2355: AND term.opex_recon_id = recon.recon_id