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 1060: FROM pn_opex_est_payments_all

1056:
1057: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
1058: IS
1059: SELECT *
1060: FROM pn_opex_est_payments_all
1061: WHERE est_payment_id = est_pay_trm_id;
1062:
1063: CURSOR pay_sch_cur(p1_lease_id IN NUMBER , pl_contract_sch_date IN DATE) IS
1064: SELECT payment_schedule_id

Line 1127: FROM pn_opex_est_payments_all

1123:
1124: -- Getting the payment term that has to be contracted.
1125: BEGIN
1126: SELECT payment_term_id INTO prev_pay_term_id
1127: FROM pn_opex_est_payments_all
1128: WHERE est_payment_id <> p_est_payment_id
1129: AND AGREEMENT_ID = opex_est_pay_rec.agreement_id
1130: AND END_DATE = (
1131: SELECT MAX(END_DATE) FROM pn_opex_est_payments_all

Line 1131: SELECT MAX(END_DATE) FROM pn_opex_est_payments_all

1127: FROM pn_opex_est_payments_all
1128: WHERE est_payment_id <> p_est_payment_id
1129: AND AGREEMENT_ID = opex_est_pay_rec.agreement_id
1130: AND END_DATE = (
1131: SELECT MAX(END_DATE) FROM pn_opex_est_payments_all
1132: WHERE AGREEMENT_ID = opex_est_pay_rec.agreement_id
1133: AND est_payment_id <> p_est_payment_id)
1134: AND ROWNUM = 1;
1135: EXCEPTION

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 1235: delete from pn_opex_est_payments_all

1231:
1232: IF l_approved_item_count = 0
1233: THEN
1234:
1235: delete from pn_opex_est_payments_all
1236: where payment_term_id = prev_pay_term_id;
1237:
1238: delete from pn_distributions_all
1239: where payment_term_id = prev_pay_term_id;

Line 1245: UPDATE pn_opex_est_payments_all

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
1246: SET END_DATE = prev_trm_end_date
1247: Where payment_term_id = prev_pay_term_id;
1248:
1249: UPDATE pn_payment_terms_all

Line 1313: pn_opex_est_payments_all est

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

Line 1328: FROM pn_opex_est_payments_all

1324:
1325: CURSOR opex_est_pay_cur(est_pay_trm_id IN NUMBER)
1326: IS
1327: SELECT payment_term_id
1328: FROM pn_opex_est_payments_all
1329: WHERE est_payment_id = est_pay_trm_id;
1330:
1331: CURSOR last_sch_day_cur( c_lease_id IN NUMBER , c_pay_term_id IN NUMBER) IS
1332: SELECT

Line 1473: FROM pn_opex_est_payments_all

1469:
1470: ELSE
1471: BEGIN
1472: SELECT EST_PMT_AMOUNT INTO amount
1473: FROM pn_opex_est_payments_all
1474: WHERE agreement_id = agr_id
1475: AND END_DATE IN
1476: (SELECT MAX(END_DATE) FROM
1477: pn_opex_est_payments_all

Line 1477: pn_opex_est_payments_all

1473: FROM pn_opex_est_payments_all
1474: WHERE agreement_id = agr_id
1475: AND END_DATE IN
1476: (SELECT MAX(END_DATE) FROM
1477: pn_opex_est_payments_all
1478: WHERE agreement_id = agr_id)
1479: AND ROWNUM = 1;
1480: EXCEPTION
1481: WHEN NO_DATA_FOUND THEN

Line 1519: FROM pn_opex_est_payments_all

1515: IS
1516: max_id NUMBER := -1;
1517: CURSOR csr_max_dt_est_term(p_agr_id NUMBER) IS
1518: SELECT est_payment_id
1519: FROM pn_opex_est_payments_all
1520: WHERE agreement_id = p_agr_id
1521: AND END_DATE IN
1522: (SELECT MAX(END_DATE) FROM
1523: pn_opex_est_payments_all

Line 1523: pn_opex_est_payments_all

1519: FROM pn_opex_est_payments_all
1520: WHERE agreement_id = p_agr_id
1521: AND END_DATE IN
1522: (SELECT MAX(END_DATE) FROM
1523: pn_opex_est_payments_all
1524: WHERE agreement_id = p_agr_id);
1525:
1526:
1527: BEGIN

Line 1783: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL

1779:
1780: DELETE FROM PN_OPEX_PRORAT_BASIS_DTLS_ALL
1781: WHERE agreement_id = p_agreement_id;
1782:
1783: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL
1784: WHERE agreement_id = p_agreement_id;
1785:
1786: -- Deleting reconciliation tables
1787:

Line 1815: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL

1811:
1812: DELETE FROM PN_OPEX_RECON_ALL
1813: WHERE agreement_id = p_agreement_id;
1814:
1815: DELETE FROM PN_OPEX_EST_PAYMENTS_ALL
1816: WHERE agreement_id = p_agreement_id;
1817:
1818: ELSE
1819: pnp_debug_pkg.debug ('Agreemnt cannot be deleted');