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

Line 1021: FROM pn_var_rent_inv_all inv_rent

1017: inv_rent.forecasted_term_status,
1018: inv_rent.forecasted_exp_code,
1019: inv_rent.actual_exp_code,
1020: inv_rent.variance_exp_code
1021: FROM pn_var_rent_inv_all inv_rent
1022: WHERE inv_rent.period_id = ip_period_id
1023: AND inv_rent.invoice_date = ip_invoice_date
1024: AND inv_rent.adjust_num = (SELECT MAX(inv.adjust_num)
1025: FROM pn_var_rent_inv_all inv

Line 1025: FROM pn_var_rent_inv_all inv

1021: FROM pn_var_rent_inv_all inv_rent
1022: WHERE inv_rent.period_id = ip_period_id
1023: AND inv_rent.invoice_date = ip_invoice_date
1024: AND inv_rent.adjust_num = (SELECT MAX(inv.adjust_num)
1025: FROM pn_var_rent_inv_all inv
1026: WHERE inv.invoice_date = inv_rent.invoice_date
1027: AND inv.period_id = inv_rent.period_id);
1028:
1029: CURSOR csr_cum_vol (ip_period_id NUMBER,

Line 1211: UPDATE pn_var_rent_inv_all

1207: WHERE var_rent_inv_id = l_var_rent_inv_id
1208: AND status <> c_payment_term_status_approved
1209: AND var_rent_TYPE = l_rent_TYPE;
1210:
1211: UPDATE pn_var_rent_inv_all
1212: SET for_per_rent = l_forecast_rent,
1213: act_per_rent = l_actual_rent,
1214: constr_actual_rent = l_constr_act_rent,
1215: tot_act_vol = ROUND(l_actual_volume,g_precision), -- bug # 6007571

Line 1267: FROM pn_var_rent_inv_all inv

1263: inv.negative_rent,
1264: inv.rec_abatement,
1265: inv.rec_abatement_override,
1266: inv.invoice_date
1267: FROM pn_var_rent_inv_all inv
1268: WHERE inv.var_rent_id = p_var_rent_id
1269: AND inv.constr_actual_rent is not null
1270: AND decode(g_invoice_on,'ACTUAL',inv.actual_exp_code,'FORECASTED',inv.variance_exp_code)='N'
1271: ORDER BY inv.period_id,inv.invoice_date,inv.adjust_num;

Line 1289: FROM pn_var_rent_inv_all inv

1285:
1286: CURSOR csr_get_abt_appl(ip_var_rent_id NUMBER)
1287: IS
1288: SELECT SUM(inv.abatement_appl)
1289: FROM pn_var_rent_inv_all inv
1290: WHERE inv.adjust_num =(SELECT MAX(inv1.adjust_num)
1291: FROM pn_var_rent_inv_all inv1
1292: WHERE inv1.invoice_date = inv.invoice_date
1293: AND inv1.var_rent_id = inv.var_rent_id

Line 1291: FROM pn_var_rent_inv_all inv1

1287: IS
1288: SELECT SUM(inv.abatement_appl)
1289: FROM pn_var_rent_inv_all inv
1290: WHERE inv.adjust_num =(SELECT MAX(inv1.adjust_num)
1291: FROM pn_var_rent_inv_all inv1
1292: WHERE inv1.invoice_date = inv.invoice_date
1293: AND inv1.var_rent_id = inv.var_rent_id
1294: AND decode(g_invoice_on,'ACTUAL',inv1.actual_exp_code,
1295: 'FORECASTED',inv1.variance_exp_code)='Y')

Line 1309: FROM pn_var_rent_inv_all inv

1305:
1306: CURSOR csr_neg_avail (ip_var_rent_id NUMBER,
1307: ip_invoice_date DATE) IS
1308: SELECT ABS(NVL(SUM(constr_actual_rent),0)) l_negative_avialable
1309: FROM pn_var_rent_inv_all inv
1310: WHERE inv.var_rent_id = ip_var_rent_id
1311: AND inv.invoice_date < ip_invoice_date
1312: AND inv.adjust_num = (select MAX(inv1.adjust_num)
1313: from pn_var_rent_inv_all inv1

Line 1313: from pn_var_rent_inv_all inv1

1309: FROM pn_var_rent_inv_all inv
1310: WHERE inv.var_rent_id = ip_var_rent_id
1311: AND inv.invoice_date < ip_invoice_date
1312: AND inv.adjust_num = (select MAX(inv1.adjust_num)
1313: from pn_var_rent_inv_all inv1
1314: where inv1.var_rent_id = inv.var_rent_id
1315: AND inv1.invoice_date = inv.invoice_date)
1316: AND inv.constr_actual_rent < 0;
1317:

Line 1321: FROM pn_var_rent_inv_all inv

1317:
1318: CURSOR csr_neg_appl (ip_var_rent_id NUMBER,
1319: ip_invoice_date DATE) IS
1320: SELECT NVL(SUM(negative_rent),0)
1321: FROM pn_var_rent_inv_all inv
1322: WHERE inv.var_rent_id = ip_var_rent_id
1323: AND inv.invoice_date < ip_invoice_date
1324: AND inv.adjust_num = (select MAX(inv1.adjust_num)
1325: from pn_var_rent_inv_all inv1

Line 1325: from pn_var_rent_inv_all inv1

1321: FROM pn_var_rent_inv_all inv
1322: WHERE inv.var_rent_id = ip_var_rent_id
1323: AND inv.invoice_date < ip_invoice_date
1324: AND inv.adjust_num = (select MAX(inv1.adjust_num)
1325: from pn_var_rent_inv_all inv1
1326: where inv1.var_rent_id = inv.var_rent_id
1327: AND inv1.invoice_date = inv.invoice_date);
1328:
1329: CURSOR csr_prev_inv_amt (ip_var_rent_id NUMBER,

Line 1333: FROM pn_var_rent_inv_all inv

1329: CURSOR csr_prev_inv_amt (ip_var_rent_id NUMBER,
1330: ip_invoice_date DATE,
1331: ip_adjust_num NUMBER) IS
1332: SELECT NVL(SUM(actual_invoiced_amount),0)
1333: FROM pn_var_rent_inv_all inv
1334: WHERE inv.var_rent_id = ip_var_rent_id
1335: AND inv.invoice_date = ip_invoice_date
1336: AND inv.adjust_num < ip_adjust_num;
1337:

Line 1502: UPDATE pn_var_rent_inv_all

1498: WHERE status <> c_payment_term_status_approved
1499: AND var_rent_inv_id = rec_get_inv.var_rent_inv_id
1500: AND var_rent_TYPE = decode(g_invoice_on,'ACTUAL','ACTUAL','FORECASTED','VARIANCE');
1501:
1502: UPDATE pn_var_rent_inv_all
1503: SET abatement_appl = l_abatement_applied,
1504: actual_invoiced_amount = l_actual_invoice_amt,
1505: negative_rent = l_negative_rent,
1506: actual_term_status = 'N',

Line 2042: FROM pn_var_rent_inv_all inv

2038: p_period_id NUMBER) IS
2039: SELECT 'Y' term_exists
2040: FROM dual
2041: WHERE EXISTS (SELECT null
2042: FROM pn_var_rent_inv_all inv
2043: WHERE inv.forecasted_exp_code = decode(p_var_rent_TYPE,'FORECASTED','N',inv.forecasted_exp_code)
2044: AND inv.actual_exp_code = decode(p_var_rent_TYPE,'ACTUAL','N',inv.actual_exp_code)
2045: AND inv.variance_exp_code = decode(p_var_rent_TYPE,'VARIANCE','N',inv.variance_exp_code)
2046: AND inv.invoice_date < ( SELECT inv1.invoice_date

Line 2047: FROM pn_var_rent_inv_all inv1

2043: WHERE inv.forecasted_exp_code = decode(p_var_rent_TYPE,'FORECASTED','N',inv.forecasted_exp_code)
2044: AND inv.actual_exp_code = decode(p_var_rent_TYPE,'ACTUAL','N',inv.actual_exp_code)
2045: AND inv.variance_exp_code = decode(p_var_rent_TYPE,'VARIANCE','N',inv.variance_exp_code)
2046: AND inv.invoice_date < ( SELECT inv1.invoice_date
2047: FROM pn_var_rent_inv_all inv1
2048: WHERE inv1.var_rent_inv_id = p_var_rent_inv_id)
2049: AND inv.period_id = nvl(p_period_id,inv.period_id)
2050: AND inv.var_rent_id = p_var_rent_id);
2051:

Line 2061: FROM pn_var_rent_inv_all inv

2057: p_period_id NUMBER) IS
2058: SELECT 'Y' term_exists
2059: FROM dual
2060: WHERE EXISTS (SELECT null
2061: FROM pn_var_rent_inv_all inv
2062: WHERE inv.actual_exp_code = 'N'
2063: AND inv.forecasted_exp_code = 'N'
2064: AND inv.variance_exp_code = 'N'
2065: AND inv.invoice_date < ( SELECT inv1.invoice_date

Line 2066: FROM pn_var_rent_inv_all inv1

2062: WHERE inv.actual_exp_code = 'N'
2063: AND inv.forecasted_exp_code = 'N'
2064: AND inv.variance_exp_code = 'N'
2065: AND inv.invoice_date < ( SELECT inv1.invoice_date
2066: FROM pn_var_rent_inv_all inv1
2067: WHERE inv1.var_rent_inv_id = p_var_rent_inv_id)
2068: AND inv.period_id = nvl(p_period_id,inv.period_id)
2069: AND inv.var_rent_id = p_var_rent_id);
2070:

Line 2084: FROM pn_var_rent_inv_all

2080:
2081: -- Get the details of
2082: CURSOR period_cur IS
2083: SELECT period_id
2084: FROM pn_var_rent_inv_all
2085: WHERE var_rent_inv_id = p_var_rent_inv_id;
2086:
2087: l_period_id NUMBER;
2088: l_cur_period_id NUMBER := NULL;

Line 2138: FROM pn_var_rent_inv_all inv

2134: CURSOR csr_prev_inv_amt (ip_var_rent_id NUMBER,
2135: ip_invoice_date DATE,
2136: ip_adjust_num NUMBER) IS
2137: SELECT SUM(actual_invoiced_amount)
2138: FROM pn_var_rent_inv_all inv
2139: WHERE inv.var_rent_id = ip_var_rent_id
2140: AND inv.invoice_date = ip_invoice_date
2141: AND inv.adjust_num < ip_adjust_num;
2142:

Line 2618: FROM pn_var_rent_inv_all inv

2614: inv.forecasted_exp_code,
2615: inv.variance_exp_code,
2616: inv.rowid,
2617: inv.var_rent_inv_id
2618: FROM pn_var_rent_inv_all inv
2619: WHERE inv.period_id = ip_period_id
2620: AND inv.invoice_date = ip_invoice_date
2621: AND inv.adjust_num =(Select MAX(inv1.adjust_num)
2622: from pn_var_rent_inv_all inv1

Line 2622: from pn_var_rent_inv_all inv1

2618: FROM pn_var_rent_inv_all inv
2619: WHERE inv.period_id = ip_period_id
2620: AND inv.invoice_date = ip_invoice_date
2621: AND inv.adjust_num =(Select MAX(inv1.adjust_num)
2622: from pn_var_rent_inv_all inv1
2623: where inv1.period_id = ip_period_id
2624: AND inv1.invoice_date = ip_invoice_date);
2625:
2626: l_any_vol_exists VARCHAR2(1) := 'N';

Line 2702: DELETE from pn_var_rent_inv_all

2698: AND var_rent_TYPE = l_rent_TYPE
2699: AND status <> c_payment_term_status_approved;
2700:
2701: /* Delete from pn_var_rent_inv */
2702: DELETE from pn_var_rent_inv_all
2703: WHERE rowid = l_rowid;
2704: END IF;
2705: END IF;
2706:

Line 2879: FROM pn_var_rent_inv_all

2875: p_variance_flag OUT NOCOPY VARCHAR2)
2876: IS
2877: CURSOR get_aprvd_cur(ip_period_id NUMBER,ip_invoice_date DATE) IS
2878: SELECT actual_exp_code,forecasted_exp_code,variance_exp_code
2879: FROM pn_var_rent_inv_all
2880: WHERE period_id = ip_period_id
2881: AND invoice_date = ip_invoice_date
2882: AND true_up_amt IS NULL
2883: AND adjust_num = (select max(adjust_num) FROM pn_var_rent_inv_all

Line 2883: AND adjust_num = (select max(adjust_num) FROM pn_var_rent_inv_all

2879: FROM pn_var_rent_inv_all
2880: WHERE period_id = ip_period_id
2881: AND invoice_date = ip_invoice_date
2882: AND true_up_amt IS NULL
2883: AND adjust_num = (select max(adjust_num) FROM pn_var_rent_inv_all
2884: WHERE period_id = ip_period_id
2885: AND invoice_date = ip_invoice_date
2886: AND true_up_amt IS NULL -- Bug # 5991106
2887: );

Line 2890: FROM pn_var_rent_inv_all

2886: AND true_up_amt IS NULL -- Bug # 5991106
2887: );
2888: CURSOR get_aprvd_cur_tu(ip_period_id NUMBER,ip_invoice_date DATE) IS
2889: SELECT actual_exp_code,forecasted_exp_code,variance_exp_code
2890: FROM pn_var_rent_inv_all
2891: WHERE period_id = ip_period_id
2892: AND invoice_date = ip_invoice_date
2893: AND true_up_amt IS NOT NULL
2894: AND adjust_num = (select max(adjust_num) FROM pn_var_rent_inv_all

Line 2894: AND adjust_num = (select max(adjust_num) FROM pn_var_rent_inv_all

2890: FROM pn_var_rent_inv_all
2891: WHERE period_id = ip_period_id
2892: AND invoice_date = ip_invoice_date
2893: AND true_up_amt IS NOT NULL
2894: AND adjust_num = (select max(adjust_num) FROM pn_var_rent_inv_all
2895: WHERE period_id = ip_period_id
2896: AND invoice_date = ip_invoice_date
2897: AND true_up_amt IS NOT NULL -- Bug # 5991106
2898: );