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_OPEX_EST_PAYMENTS_ALL

Line 41: FROM pn_opex_est_payments_all

37:
38: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
39: IS
40: SELECT *
41: FROM pn_opex_est_payments_all
42: WHERE est_payment_id = est_pay_trm_id;
43:
44: CURSOR term_template_cur (term_temp_id IN NUMBER)
45: IS

Line 641: FROM pn_opex_est_payments_all

637:
638: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
639: IS
640: SELECT *
641: FROM pn_opex_est_payments_all
642: WHERE est_payment_id = est_pay_trm_id;
643:
644: CURSOR term_template_cur (term_temp_id IN NUMBER)
645: IS

Line 1056: FROM pn_opex_est_payments_all

1052:
1053: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
1054: IS
1055: SELECT *
1056: FROM pn_opex_est_payments_all
1057: WHERE est_payment_id = est_pay_trm_id;
1058:
1059: CURSOR pay_sch_cur(p1_lease_id IN NUMBER , pl_contract_sch_date IN DATE) IS
1060: SELECT payment_schedule_id

Line 1122: FROM pn_opex_est_payments_all

1118:
1119: -- Getting the payment term that has to be contracted.
1120: BEGIN
1121: SELECT payment_term_id INTO prev_pay_term_id
1122: FROM pn_opex_est_payments_all
1123: WHERE est_payment_id <> p_est_payment_id
1124: AND AGREEMENT_ID = opex_est_pay_rec.agreement_id
1125: AND END_DATE = (
1126: SELECT MAX(END_DATE) FROM pn_opex_est_payments_all

Line 1126: SELECT MAX(END_DATE) FROM pn_opex_est_payments_all

1122: FROM pn_opex_est_payments_all
1123: WHERE est_payment_id <> p_est_payment_id
1124: AND AGREEMENT_ID = opex_est_pay_rec.agreement_id
1125: AND END_DATE = (
1126: SELECT MAX(END_DATE) FROM pn_opex_est_payments_all
1127: WHERE AGREEMENT_ID = opex_est_pay_rec.agreement_id
1128: AND est_payment_id <> p_est_payment_id)
1129: AND ROWNUM = 1;
1130: EXCEPTION

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 1220: UPDATE pn_opex_est_payments_all

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
1221: SET END_DATE = prev_trm_end_date
1222: Where payment_term_id = prev_pay_term_id;
1223:
1224: UPDATE pn_payment_terms_all

Line 1284: pn_opex_est_payments_all est

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
1287: AND sch.payment_status_lookup_code = 'APPROVED'
1288: AND sch.lease_id = p_lease_id;

Line 1299: FROM pn_opex_est_payments_all

1295:
1296: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
1297: IS
1298: SELECT payment_term_id
1299: FROM pn_opex_est_payments_all
1300: WHERE est_payment_id = est_pay_trm_id;
1301:
1302: CURSOR last_sch_day_cur( c_lease_id IN NUMBER , c_pay_term_id IN NUMBER) IS
1303: SELECT

Line 1444: FROM pn_opex_est_payments_all

1440:
1441: ELSE
1442: BEGIN
1443: SELECT EST_PMT_AMOUNT INTO amount
1444: FROM pn_opex_est_payments_all
1445: WHERE agreement_id = agr_id
1446: AND END_DATE IN
1447: (SELECT MAX(END_DATE) FROM
1448: pn_opex_est_payments_all

Line 1448: pn_opex_est_payments_all

1444: FROM pn_opex_est_payments_all
1445: WHERE agreement_id = agr_id
1446: AND END_DATE IN
1447: (SELECT MAX(END_DATE) FROM
1448: pn_opex_est_payments_all
1449: WHERE agreement_id = agr_id)
1450: AND ROWNUM = 1;
1451: EXCEPTION
1452: WHEN NO_DATA_FOUND THEN

Line 1490: FROM pn_opex_est_payments_all

1486: IS
1487: max_id NUMBER := -1;
1488: CURSOR csr_max_dt_est_term(p_agr_id NUMBER) IS
1489: SELECT est_payment_id
1490: FROM pn_opex_est_payments_all
1491: WHERE agreement_id = p_agr_id
1492: AND END_DATE IN
1493: (SELECT MAX(END_DATE) FROM
1494: pn_opex_est_payments_all

Line 1494: pn_opex_est_payments_all

1490: FROM pn_opex_est_payments_all
1491: WHERE agreement_id = p_agr_id
1492: AND END_DATE IN
1493: (SELECT MAX(END_DATE) FROM
1494: pn_opex_est_payments_all
1495: WHERE agreement_id = p_agr_id);
1496:
1497:
1498: BEGIN

Line 1754: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL

1750:
1751: DELETE FROM PN_OPEX_PRORAT_BASIS_DTLS_ALL
1752: WHERE agreement_id = p_agreement_id;
1753:
1754: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL
1755: WHERE agreement_id = p_agreement_id;
1756:
1757: -- Deleting reconciliation tables
1758:

Line 1786: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL

1782:
1783: DELETE FROM PN_OPEX_RECON_ALL
1784: WHERE agreement_id = p_agreement_id;
1785:
1786: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL
1787: WHERE agreement_id = p_agreement_id;
1788:
1789: ELSE
1790: pnp_debug_pkg.debug ('Agreemnt cannot be deleted');