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_VAR_RENT_CALC_PKG dependencies on PN_VAR_ABATEMENTS_ALL

Line 9006: select * from pn_var_abatements_all

9002: AND vinv.var_rent_inv_id=p_inv_id;
9003:
9004: /*Cursor to get all abtmt terms for a particular invoice*/
9005: CURSOR get_abtmt_terms_inv(p_inv_id IN NUMBER) IS
9006: select * from pn_var_abatements_all
9007: where var_rent_inv_id=p_inv_id;
9008:
9009: /*Cursor to get abtmt terms for 1st invoice from setup*/
9010: CURSOR get_var_abtmt_id(p_vrent_id IN NUMBER) IS

Line 9012: FROM pn_var_abatements_all

9008:
9009: /*Cursor to get abtmt terms for 1st invoice from setup*/
9010: CURSOR get_var_abtmt_id(p_vrent_id IN NUMBER) IS
9011: SELECT var_abatement_id,payment_term_id
9012: FROM pn_var_abatements_all
9013: WHERE var_rent_inv_id = -1
9014: AND var_rent_id=p_vrent_id;
9015:
9016:

Line 9062: update pn_var_abatements_all

9058: l_min_pmt_term_id := abtmt_exists_rec.payment_term_id;
9059:
9060: --pnp_debug_pkg.log('prior to update');
9061: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9062: update pn_var_abatements_all
9063: set var_rent_inv_id = l_fst_inv_id
9064: where var_abatement_id = l_min_var_abt_id;
9065:
9066: END LOOP;

Line 9189: SELECT * FROM pn_var_abatements_all

9185: AND adjust_num=0;
9186:
9187: /*Cursor to get all abtmt terms for a particular invoice*/
9188: CURSOR get_abtmt_terms_inv(p_inv_id IN NUMBER) IS
9189: SELECT * FROM pn_var_abatements_all
9190: WHERE var_rent_inv_id=p_inv_id;
9191:
9192: -- Check whether a given combination of (payment_term_id,var_rent_inv_id)
9193: -- exists in pn_var_abatements_all

Line 9193: -- exists in pn_var_abatements_all

9189: SELECT * FROM pn_var_abatements_all
9190: WHERE var_rent_inv_id=p_inv_id;
9191:
9192: -- Check whether a given combination of (payment_term_id,var_rent_inv_id)
9193: -- exists in pn_var_abatements_all
9194: CURSOR check_abtmt_exists(p_inv_id IN NUMBER,p_pmt_id IN NUMBER)
9195: IS
9196: SELECT 'Y' abt_exists
9197: FROM dual

Line 9199: FROM pn_var_abatements_all

9195: IS
9196: SELECT 'Y' abt_exists
9197: FROM dual
9198: WHERE EXISTS ( SELECT NULL
9199: FROM pn_var_abatements_all
9200: WHERE var_rent_inv_id=p_inv_id
9201: AND payment_term_id = p_pmt_id );
9202: -- Get the invoice_date for an invoice with a given grp_end_dt
9203: CURSOR get_inv_date(p_var_rent_id IN NUMBER,p_prd_id IN NUMBER,p_end_dt IN DATE)

Line 9370: select * from pn_var_abatements_all

9366: AND vinv.var_rent_inv_id=p_inv_id;
9367:
9368: /*Cursor to get all abtmt terms for a particular invoice*/
9369: CURSOR get_abtmt_terms_inv(p_inv_id IN NUMBER) IS
9370: select * from pn_var_abatements_all
9371: where var_rent_inv_id=p_inv_id;
9372:
9373: /*Cursor to get abtmt terms for 1st invoice from setup*/
9374: CURSOR get_var_abtmt_id(p_var_rent_id IN NUMBER) IS

Line 9376: FROM pn_var_abatements_all

9372:
9373: /*Cursor to get abtmt terms for 1st invoice from setup*/
9374: CURSOR get_var_abtmt_id(p_var_rent_id IN NUMBER) IS
9375: SELECT var_abatement_id , payment_term_id
9376: FROM pn_var_abatements_all
9377: WHERE var_rent_inv_id = -1
9378: AND var_rent_id=p_var_rent_id;
9379:
9380: -- Get the invoice id for combination of a given invoice_date and period_id

Line 9433: UPDATE pn_var_abatements_all

9429: l_min_pmt_term_id:= abtmt_exists_rec.payment_term_id;
9430: --pnp_debug_pkg.log('prior to update');
9431:
9432: PN_VAR_ABATEMENTS_PKG.LOCK_ROW(p_var_rent_id,-1,l_min_pmt_term_id);
9433: UPDATE pn_var_abatements_all
9434: SET var_rent_inv_id=l_inv_id
9435: WHERE var_abatement_id = l_min_var_abt_id;
9436:
9437: END LOOP;

Line 9506: SELECT * from pn_var_abatements_all

9502: PROCEDURE include_increases_firstyr(p_var_rent_id IN NUMBER) IS
9503:
9504: /*Cursor to get all abtmt terms with include_incr='Y' for a particular invoice*/
9505: CURSOR get_abtmt_terms_inv(p_inv_id IN NUMBER,p_var_rent_id IN NUMBER) IS
9506: SELECT * from pn_var_abatements_all
9507: WHERE var_rent_inv_id = p_inv_id
9508: AND var_rent_id = p_var_rent_id
9509: AND include_increases = 'Y';
9510:

Line 9540: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all

9536: -- Check if abatement exists for this pmt term and invoice id combination
9537: CURSOR check_abtmt_exists(pmt_term_id IN NUMBER,invoice_id IN NUMBER) IS
9538: SELECT 'N'
9539: FROM dual
9540: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all
9541: WHERE payment_term_id=pmt_term_id
9542: AND var_rent_inv_id=invoice_id);
9543:
9544: CURSOR org_cur(p_var_rent_id IN NUMBER) IS

Line 9632: SELECT * from pn_var_abatements_all

9628: PROCEDURE include_increases(p_var_rent_id IN NUMBER) IS
9629:
9630: /*Cursor to get all abtmt terms with include_incr='Y' for a particular invoice*/
9631: CURSOR get_abtmt_terms_inv(p_inv_id IN NUMBER,p_var_rent_id IN NUMBER) IS
9632: SELECT * from pn_var_abatements_all
9633: WHERE var_rent_inv_id = p_inv_id AND
9634: var_rent_id = p_var_rent_id AND
9635: include_increases = 'Y';
9636:

Line 9669: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all

9665: -- Get the details of
9666: CURSOR check_abtmt_exists(pmt_term_id IN NUMBER,invoice_id IN NUMBER) IS
9667: SELECT 'N'
9668: FROM dual
9669: WHERE NOT EXISTS ( SELECT NULL FROM pn_var_abatements_all
9670: WHERE payment_term_id=pmt_term_id
9671: AND var_rent_inv_id=invoice_id);
9672:
9673: CURSOR check_inv_exists(p_var_rent_id IN NUMBER,p_inv_dt IN DATE,p_prd_id IN NUMBER) IS