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_INDEX_AMOUNT_PKG dependencies on PN_INDEX_LEASE_TERMS

Line 39: -- | 06-DEC-01 achauhan In approve_index_pay_term added code to update pn_index_lease_terms

35: -- | variable v_index_percent_change as null
36: -- | 05-dEC-01 achauhan Fix for aggregation - Made changes to create_aggr_payment_terms for
37: -- | aggregation functionality and also to sum_payment_items, for
38: -- | calculation of annualized basis.
39: -- | 06-DEC-01 achauhan In approve_index_pay_term added code to update pn_index_lease_terms
40: -- | 12-DEC-01 achauhan Added the condition to pick up approved rent increase terms, in the
41: -- | sum_payment_items routine.
42: -- | 15-JAN-02 mmisra Added dbdrv command.
43: -- | 01-FEB-02 achauhan Commented out NOCOPY the calls to print_payment_terms and print_basis_periods

Line 2839: l_index_lease_term_id pn_index_lease_terms.index_lease_term_id%type;

2835: i NUMBER;
2836: l_term_contribution NUMBER;
2837: l_total_inter_term NUMBER;
2838: l_sum_of_terms_loop NUMBER := 0;
2839: l_index_lease_term_id pn_index_lease_terms.index_lease_term_id%type;
2840:
2841: cursor cur_total_inter_term ( ip_payment_term_id NUMBER) IS
2842: SELECT SUM(amount) total_inter_term
2843: FROM pn_index_lease_terms_all

Line 2843: FROM pn_index_lease_terms_all

2839: l_index_lease_term_id pn_index_lease_terms.index_lease_term_id%type;
2840:
2841: cursor cur_total_inter_term ( ip_payment_term_id NUMBER) IS
2842: SELECT SUM(amount) total_inter_term
2843: FROM pn_index_lease_terms_all
2844: WHERE index_period_id = ip_index_period_id
2845: AND lease_term_id = ip_payment_term_id
2846: AND index_term_indicator = ip_index_term_indicator;
2847:

Line 2892: PN_INDEX_LEASE_TERMS_PKG.INSERT_ROW

2888:
2889:
2890: l_index_lease_term_id := NULL;
2891:
2892: PN_INDEX_LEASE_TERMS_PKG.INSERT_ROW
2893: (
2894: X_INDEX_LEASE_TERM_ID => l_index_lease_term_id
2895: ,X_INDEX_LEASE_ID => ip_index_lease_id
2896: ,X_INDEX_PERIOD_ID => ip_index_period_id

Line 6232: /* Delete from the Intermediate table PN_INDEX_LEASE_TERMS_ALL */

6228:
6229: END IF; -- v_uncontrained_index_amount
6230:
6231:
6232: /* Delete from the Intermediate table PN_INDEX_LEASE_TERMS_ALL */
6233:
6234:
6235: DELETE FROM pn_index_lease_terms_all ilt
6236: WHERE ilt.index_period_id = c_rec.index_period_id

Line 6235: DELETE FROM pn_index_lease_terms_all ilt

6231:
6232: /* Delete from the Intermediate table PN_INDEX_LEASE_TERMS_ALL */
6233:
6234:
6235: DELETE FROM pn_index_lease_terms_all ilt
6236: WHERE ilt.index_period_id = c_rec.index_period_id
6237: AND ilt.approved_flag <> c_payment_term_status_approved ;
6238:
6239: DELETE FROM pn_distributions_all

Line 7140: -- update status of records in pn_index_lease_terms

7136: ,approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7137: WHERE payment_term_id = ip_index_pay_term_id;
7138:
7139: --
7140: -- update status of records in pn_index_lease_terms
7141: --
7142: UPDATE pn_index_lease_terms_all
7143: SET APPROVED_FLAG = c_payment_term_status_approved
7144: ,last_update_date = SYSDATE

Line 7142: UPDATE pn_index_lease_terms_all

7138:
7139: --
7140: -- update status of records in pn_index_lease_terms
7141: --
7142: UPDATE pn_index_lease_terms_all
7143: SET APPROVED_FLAG = c_payment_term_status_approved
7144: ,last_update_date = SYSDATE
7145: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
7146: WHERE rent_increase_term_id = ip_index_pay_term_id;