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_VARIABLE_TERM_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 117: FROM pn_var_rent_inv_all

113: var_rent_inv_id,
114: invoice_date,
115: for_per_rent,
116: period_id
117: FROM pn_var_rent_inv_all
118: WHERE period_id = ip_period_id
119: AND adjust_num = 0
120: AND nvl(for_per_rent,0) <> 0
121: AND forecasted_exp_code = 'N'

Line 138: FROM pn_var_rent_inv_all

134: adjust_num,
135: actual_invoiced_amount,
136: period_id,
137: credit_flag
138: FROM pn_var_rent_inv_all
139: WHERE period_id = ip_period_id
140: AND actual_exp_code = 'N'
141: AND nvl(actual_invoiced_amount,0) <> 0
142: AND actual_term_status = decode(p_period_id,null,'N','Y')

Line 158: FROM pn_var_rent_inv_all inv

154: inv.invoice_date,
155: inv.period_id,
156: decode(inv.adjust_num,0,(inv.actual_invoiced_amount-NVL(inv.for_per_rent,0)),
157: inv.actual_invoiced_amount) act_for_amt
158: FROM pn_var_rent_inv_all inv
159: WHERE inv.period_id = ip_period_id
160: AND inv.variance_exp_code = 'N'
161: AND nvl(decode(inv.adjust_num,0,(inv.actual_invoiced_amount-NVL(inv.for_per_rent,0)),
162: inv.actual_invoiced_amount),0) <> 0

Line 178: FROM pn_var_rent_inv_all

174: CURSOR payment_cur(p_invoice_date DATE,p_var_rent_id NUMBER) IS
175: SELECT payment_term_id
176: FROM pn_payment_terms_all
177: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
178: FROM pn_var_rent_inv_all
179: WHERE invoice_date = p_invoice_date
180: AND var_rent_id = p_var_rent_id);
181:
182:

Line 370: UPDATE pn_var_rent_inv_all

366: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id
367: AND var_rent_type = 'FORECASTED';
368:
369: IF term_count > 0 THEN
370: UPDATE pn_var_rent_inv_all
371: SET forecasted_term_status='Y',
372: last_update_date = SYSDATE,
373: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
374: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 378: UPDATE pn_var_rent_inv_all

374: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
375: WHERE var_rent_inv_id = rec_for_inv.var_rent_inv_id;
376: ELSE
377: pn_variable_amount_pkg.put_log('term not found ...');
378: UPDATE pn_var_rent_inv_all
379: SET forecasted_term_status='N',
380: last_update_date = SYSDATE,
381: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
382: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 468: UPDATE pn_var_rent_inv_all

464: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
465: AND var_rent_type = 'VARIANCE';
466:
467: IF term_count > 0 THEN
468: UPDATE pn_var_rent_inv_all
469: SET variance_term_status='Y',
470: last_update_date = SYSDATE,
471: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
472: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 475: UPDATE pn_var_rent_inv_all

471: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
472: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
473: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id;
474:
475: UPDATE pn_var_rent_inv_all
476: SET true_up_status = 'Y'
477: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
478: AND true_up_status IS NOT NULL;
479:

Line 482: UPDATE pn_var_rent_inv_all

478: AND true_up_status IS NOT NULL;
479:
480: ELSE
481: pn_variable_amount_pkg.put_log('term not found ...');
482: UPDATE pn_var_rent_inv_all
483: SET variance_term_status='N',
484: last_update_date = SYSDATE,
485: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
486: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 489: UPDATE pn_var_rent_inv_all

485: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
486: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
487: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id;
488:
489: UPDATE pn_var_rent_inv_all
490: SET true_up_status = 'N'
491: WHERE var_rent_inv_id = rec_var_inv.var_rent_inv_id
492: AND true_up_status IS NOT NULL;
493:

Line 577: UPDATE pn_var_rent_inv_all

573: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
574: AND var_rent_type = 'ACTUAL';
575:
576: IF term_count > 0 THEN
577: UPDATE pn_var_rent_inv_all
578: SET actual_term_status='Y',
579: last_update_date = SYSDATE,
580: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
581: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 584: UPDATE pn_var_rent_inv_all

580: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
581: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
582: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id;
583:
584: UPDATE pn_var_rent_inv_all
585: SET true_up_status = 'Y'
586: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
587: AND true_up_status IS NOT NULL;
588:

Line 591: UPDATE pn_var_rent_inv_all

587: AND true_up_status IS NOT NULL;
588:
589: ELSE
590: pn_variable_amount_pkg.put_log('term not found ...');
591: UPDATE pn_var_rent_inv_all
592: SET actual_term_status='N',
593: last_update_date = SYSDATE,
594: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
595: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 598: UPDATE pn_var_rent_inv_all

594: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
595: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
596: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id;
597:
598: UPDATE pn_var_rent_inv_all
599: SET true_up_status = 'N'
600: WHERE var_rent_inv_id = rec_act_inv.var_rent_inv_id
601: AND true_up_status IS NOT NULL;
602: END IF;

Line 609: UPDATE pn_var_rent_inv_all

605: FOR payment_rec IN payment_cur(rec_act_inv.invoice_date,rec_act_inv.var_rent_id) LOOP
606: pn_variable_term_pkg.create_reversal_terms(p_payment_term_id => payment_rec.payment_term_id
607: ,p_var_rent_inv_id => rec_act_inv.var_rent_inv_id
608: ,p_var_rent_type => 'ADJUSTMENT');
609: UPDATE pn_var_rent_inv_all
610: SET actual_term_status='Y',
611: last_update_date = SYSDATE,
612: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
613: last_updated_by = NVL(fnd_profile.value('USER_ID'),0)

Line 1050: UPDATE pn_var_rent_inv_all

1046: AND var_rent_type = 'ACTUAL';
1047:
1048: IF term_count > 0 THEN
1049: pnp_debug_pkg.debug('setting actual term status ...');
1050: UPDATE pn_var_rent_inv_all
1051: SET actual_term_status='Y'
1052: WHERE var_rent_inv_id = p_var_rent_inv_id;
1053:
1054: UPDATE pn_var_rent_inv_all

Line 1054: UPDATE pn_var_rent_inv_all

1050: UPDATE pn_var_rent_inv_all
1051: SET actual_term_status='Y'
1052: WHERE var_rent_inv_id = p_var_rent_inv_id;
1053:
1054: UPDATE pn_var_rent_inv_all
1055: SET true_up_status = 'Y'
1056: WHERE var_rent_inv_id = p_var_rent_inv_id
1057: AND true_up_status IS NOT NULL;
1058:

Line 1060: UPDATE pn_var_rent_inv_all

1056: WHERE var_rent_inv_id = p_var_rent_inv_id
1057: AND true_up_status IS NOT NULL;
1058:
1059: ELSE
1060: UPDATE pn_var_rent_inv_all
1061: SET actual_term_status='N'
1062: WHERE var_rent_inv_id = p_var_rent_inv_id;
1063:
1064: UPDATE pn_var_rent_inv_all

Line 1064: UPDATE pn_var_rent_inv_all

1060: UPDATE pn_var_rent_inv_all
1061: SET actual_term_status='N'
1062: WHERE var_rent_inv_id = p_var_rent_inv_id;
1063:
1064: UPDATE pn_var_rent_inv_all
1065: SET true_up_status = 'N'
1066: WHERE var_rent_inv_id = p_var_rent_inv_id
1067: AND true_up_status IS NOT NULL;
1068:

Line 1092: UPDATE pn_var_rent_inv_all

1088: AND var_rent_type = 'ACTUAL';
1089:
1090: IF term_count > 0 THEN
1091: pnp_debug_pkg.debug('setting actual term status ...');
1092: UPDATE pn_var_rent_inv_all
1093: SET actual_term_status='Y'
1094: WHERE var_rent_inv_id = p_var_rent_inv_id;
1095: ELSE
1096: UPDATE pn_var_rent_inv_all

Line 1096: UPDATE pn_var_rent_inv_all

1092: UPDATE pn_var_rent_inv_all
1093: SET actual_term_status='Y'
1094: WHERE var_rent_inv_id = p_var_rent_inv_id;
1095: ELSE
1096: UPDATE pn_var_rent_inv_all
1097: SET actual_term_status='N'
1098: WHERE var_rent_inv_id = p_var_rent_inv_id;
1099: END IF;
1100: END IF;

Line 2001: UPDATE pn_var_rent_inv_all

1997: AND var_rent_type = 'ACTUAL';
1998:
1999: IF term_count > 0 THEN
2000: pnp_debug_pkg.debug('setting actual term status ...');
2001: UPDATE pn_var_rent_inv_all
2002: SET actual_term_status='Y'
2003: WHERE var_rent_inv_id = p_var_rent_inv_id;
2004:
2005: UPDATE pn_var_rent_inv_all

Line 2005: UPDATE pn_var_rent_inv_all

2001: UPDATE pn_var_rent_inv_all
2002: SET actual_term_status='Y'
2003: WHERE var_rent_inv_id = p_var_rent_inv_id;
2004:
2005: UPDATE pn_var_rent_inv_all
2006: SET true_up_status = 'Y'
2007: WHERE var_rent_inv_id = p_var_rent_inv_id
2008: AND true_up_status IS NOT NULL;
2009:

Line 2011: UPDATE pn_var_rent_inv_all

2007: WHERE var_rent_inv_id = p_var_rent_inv_id
2008: AND true_up_status IS NOT NULL;
2009:
2010: ELSE
2011: UPDATE pn_var_rent_inv_all
2012: SET actual_term_status='N'
2013: WHERE var_rent_inv_id = p_var_rent_inv_id;
2014:
2015: UPDATE pn_var_rent_inv_all

Line 2015: UPDATE pn_var_rent_inv_all

2011: UPDATE pn_var_rent_inv_all
2012: SET actual_term_status='N'
2013: WHERE var_rent_inv_id = p_var_rent_inv_id;
2014:
2015: UPDATE pn_var_rent_inv_all
2016: SET true_up_status = 'N'
2017: WHERE var_rent_inv_id = p_var_rent_inv_id
2018: AND true_up_status IS NOT NULL;
2019:

Line 2044: UPDATE pn_var_rent_inv_all

2040: AND var_rent_type = 'ACTUAL';
2041:
2042: IF term_count > 0 THEN
2043: pnp_debug_pkg.debug('setting actual term status ...');
2044: UPDATE pn_var_rent_inv_all
2045: SET actual_term_status='Y'
2046: WHERE var_rent_inv_id = p_var_rent_inv_id;
2047: ELSE
2048: UPDATE pn_var_rent_inv_all

Line 2048: UPDATE pn_var_rent_inv_all

2044: UPDATE pn_var_rent_inv_all
2045: SET actual_term_status='Y'
2046: WHERE var_rent_inv_id = p_var_rent_inv_id;
2047: ELSE
2048: UPDATE pn_var_rent_inv_all
2049: SET actual_term_status='N'
2050: WHERE var_rent_inv_id = p_var_rent_inv_id;
2051: END IF;
2052: END IF;