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.

[Home] [Help]

APPS.PN_VARIABLE_TERM_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 114: FROM pn_var_rent_inv_all

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

Line 135: FROM pn_var_rent_inv_all

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

Line 155: FROM pn_var_rent_inv_all inv

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

Line 175: FROM pn_var_rent_inv_all

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

Line 366: UPDATE pn_var_rent_inv_all

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

Line 374: UPDATE pn_var_rent_inv_all

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

Line 464: UPDATE pn_var_rent_inv_all

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

Line 471: UPDATE pn_var_rent_inv_all

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

Line 478: UPDATE pn_var_rent_inv_all

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

Line 485: UPDATE pn_var_rent_inv_all

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

Line 573: UPDATE pn_var_rent_inv_all

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

Line 580: UPDATE pn_var_rent_inv_all

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

Line 587: UPDATE pn_var_rent_inv_all

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

Line 594: UPDATE pn_var_rent_inv_all

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

Line 605: UPDATE pn_var_rent_inv_all

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

Line 1046: UPDATE pn_var_rent_inv_all

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

Line 1050: UPDATE pn_var_rent_inv_all

1046: UPDATE pn_var_rent_inv_all
1047: SET actual_term_status='Y'
1048: WHERE var_rent_inv_id = p_var_rent_inv_id;
1049:
1050: UPDATE pn_var_rent_inv_all
1051: SET true_up_status = 'Y'
1052: WHERE var_rent_inv_id = p_var_rent_inv_id
1053: AND true_up_status IS NOT NULL;
1054:

Line 1056: UPDATE pn_var_rent_inv_all

1052: WHERE var_rent_inv_id = p_var_rent_inv_id
1053: AND true_up_status IS NOT NULL;
1054:
1055: ELSE
1056: UPDATE pn_var_rent_inv_all
1057: SET actual_term_status='N'
1058: WHERE var_rent_inv_id = p_var_rent_inv_id;
1059:
1060: UPDATE pn_var_rent_inv_all

Line 1060: UPDATE pn_var_rent_inv_all

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

Line 1088: UPDATE pn_var_rent_inv_all

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

Line 1092: UPDATE pn_var_rent_inv_all

1088: UPDATE pn_var_rent_inv_all
1089: SET actual_term_status='Y'
1090: WHERE var_rent_inv_id = p_var_rent_inv_id;
1091: ELSE
1092: UPDATE pn_var_rent_inv_all
1093: SET actual_term_status='N'
1094: WHERE var_rent_inv_id = p_var_rent_inv_id;
1095: END IF;
1096: END IF;

Line 1997: UPDATE pn_var_rent_inv_all

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

Line 2001: UPDATE pn_var_rent_inv_all

1997: UPDATE pn_var_rent_inv_all
1998: SET actual_term_status='Y'
1999: WHERE var_rent_inv_id = p_var_rent_inv_id;
2000:
2001: UPDATE pn_var_rent_inv_all
2002: SET true_up_status = 'Y'
2003: WHERE var_rent_inv_id = p_var_rent_inv_id
2004: AND true_up_status IS NOT NULL;
2005:

Line 2007: UPDATE pn_var_rent_inv_all

2003: WHERE var_rent_inv_id = p_var_rent_inv_id
2004: AND true_up_status IS NOT NULL;
2005:
2006: ELSE
2007: UPDATE pn_var_rent_inv_all
2008: SET actual_term_status='N'
2009: WHERE var_rent_inv_id = p_var_rent_inv_id;
2010:
2011: UPDATE pn_var_rent_inv_all

Line 2011: UPDATE pn_var_rent_inv_all

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

Line 2040: UPDATE pn_var_rent_inv_all

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

Line 2044: UPDATE pn_var_rent_inv_all

2040: UPDATE pn_var_rent_inv_all
2041: SET actual_term_status='Y'
2042: WHERE var_rent_inv_id = p_var_rent_inv_id;
2043: ELSE
2044: UPDATE pn_var_rent_inv_all
2045: SET actual_term_status='N'
2046: WHERE var_rent_inv_id = p_var_rent_inv_id;
2047: END IF;
2048: END IF;