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 2838: l_index_lease_term_id pn_index_lease_terms.index_lease_term_id%type;

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

Line 2842: FROM pn_index_lease_terms_all

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

Line 2891: PN_INDEX_LEASE_TERMS_PKG.INSERT_ROW

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

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

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

Line 6233: DELETE FROM pn_index_lease_terms_all ilt

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

Line 7138: -- update status of records in pn_index_lease_terms

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

Line 7140: UPDATE pn_index_lease_terms_all

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