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

Line 176: TABLE OF pn_var_rent_inv%ROWTYPE

172: TABLE OF csr_get_ded%ROWTYPE
173: INDEX BY BINARY_INTEGER;
174:
175: TYPE invoice_TYPE IS
176: TABLE OF pn_var_rent_inv%ROWTYPE
177: INDEX BY BINARY_INTEGER;
178:
179: /* PL/SQL table to store the breakpoint details */
180: bkpt_range_tbl bkpt_range_TYPE;

Line 853: needed to update pn_var_Rent_inv table for the new amounts */

849: pnp_debug_pkg.log('pn_variable_amount_pkg.process_rent (+) ');
850:
851: /* insert into PL/SQL table invoice_tbl all the invoices dates
852: for the period for which rent has been calculated. Info
853: needed to update pn_var_Rent_inv table for the new amounts */
854:
855: FOR i in 1 .. invoice_tbl.COUNT
856: LOOP
857: if invoice_tbl(i).invoice_date = p_invoice_date AND

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 1047: l_for_term_status pn_var_rent_inv.forecasted_term_status%TYPE:= 'N';

1043: l_adjust_num NUMBER := 0;
1044: l_for_rent NUMBER;
1045: l_abt_appl NUMBER := 0;
1046: l_negative_rent NUMBER := 0;
1047: l_for_term_status pn_var_rent_inv.forecasted_term_status%TYPE:= 'N';
1048: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE:= 'N';
1049: l_actual_exp_code pn_var_rent_inv.actual_exp_code%TYPE :='N';
1050: l_variance_exp_code pn_var_rent_inv.variance_exp_code%TYPE :='N';
1051: l_var_rent_inv_id NUMBER := null;

Line 1048: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE:= 'N';

1044: l_for_rent NUMBER;
1045: l_abt_appl NUMBER := 0;
1046: l_negative_rent NUMBER := 0;
1047: l_for_term_status pn_var_rent_inv.forecasted_term_status%TYPE:= 'N';
1048: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE:= 'N';
1049: l_actual_exp_code pn_var_rent_inv.actual_exp_code%TYPE :='N';
1050: l_variance_exp_code pn_var_rent_inv.variance_exp_code%TYPE :='N';
1051: l_var_rent_inv_id NUMBER := null;
1052: l_rent_TYPE VARCHAR2(30);

Line 1049: l_actual_exp_code pn_var_rent_inv.actual_exp_code%TYPE :='N';

1045: l_abt_appl NUMBER := 0;
1046: l_negative_rent NUMBER := 0;
1047: l_for_term_status pn_var_rent_inv.forecasted_term_status%TYPE:= 'N';
1048: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE:= 'N';
1049: l_actual_exp_code pn_var_rent_inv.actual_exp_code%TYPE :='N';
1050: l_variance_exp_code pn_var_rent_inv.variance_exp_code%TYPE :='N';
1051: l_var_rent_inv_id NUMBER := null;
1052: l_rent_TYPE VARCHAR2(30);
1053: l_rent_inv_id NUMBER := null;

Line 1050: l_variance_exp_code pn_var_rent_inv.variance_exp_code%TYPE :='N';

1046: l_negative_rent NUMBER := 0;
1047: l_for_term_status pn_var_rent_inv.forecasted_term_status%TYPE:= 'N';
1048: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE:= 'N';
1049: l_actual_exp_code pn_var_rent_inv.actual_exp_code%TYPE :='N';
1050: l_variance_exp_code pn_var_rent_inv.variance_exp_code%TYPE :='N';
1051: l_var_rent_inv_id NUMBER := null;
1052: l_rent_TYPE VARCHAR2(30);
1053: l_rent_inv_id NUMBER := null;
1054: l_rowid_out ROWID ;

Line 1056: l_actual_invoiced_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;

1052: l_rent_TYPE VARCHAR2(30);
1053: l_rent_inv_id NUMBER := null;
1054: l_rowid_out ROWID ;
1055: l_insert BOOLEAN := FALSE;
1056: l_actual_invoiced_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1057: l_actual_volume pn_var_rent_inv.tot_act_vol%TYPE;
1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;
1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;
1060:

Line 1057: l_actual_volume pn_var_rent_inv.tot_act_vol%TYPE;

1053: l_rent_inv_id NUMBER := null;
1054: l_rowid_out ROWID ;
1055: l_insert BOOLEAN := FALSE;
1056: l_actual_invoiced_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1057: l_actual_volume pn_var_rent_inv.tot_act_vol%TYPE;
1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;
1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;
1060:
1061: BEGIN

Line 1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;

1054: l_rowid_out ROWID ;
1055: l_insert BOOLEAN := FALSE;
1056: l_actual_invoiced_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1057: l_actual_volume pn_var_rent_inv.tot_act_vol%TYPE;
1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;
1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;
1060:
1061: BEGIN
1062: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (+) ');

Line 1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;

1055: l_insert BOOLEAN := FALSE;
1056: l_actual_invoiced_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1057: l_actual_volume pn_var_rent_inv.tot_act_vol%TYPE;
1058: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE;
1059: l_rec_abatement_override pn_var_rent_inv.rec_abatement_override%TYPE;
1060:
1061: BEGIN
1062: pnp_debug_pkg.log('pn_variable_amount_pkg.Insert_Invoice (+) ');
1063:

Line 1073: /* Insert/Update pn_var_rent_inv only for those invoice dates for

1069: l_rent_TYPE := 'ACTUAL';
1070: end if;
1071:
1072:
1073: /* Insert/Update pn_var_rent_inv only for those invoice dates for
1074: which calculation has been done by checking if that invoice
1075: date AND period id exists in invoice_tbl. This table has been populated
1076: in procedure process_rent */
1077:

Line 1097: /* Get all the neccessary info from pn_var_rent_inv for invoice date AND period_id

1093:
1094: END IF;
1095:
1096:
1097: /* Get all the neccessary info from pn_var_rent_inv for invoice date AND period_id
1098: where adjust_num is MAXimum adjust num for that invoice date */
1099:
1100: l_rowid := null;
1101:

Line 1109: /A record doesnt exist in pn_var_rent_inv for the combination of period_id AND invoice_date /

1105: l_for_term_status,l_for_exp_code,l_actual_exp_code,l_variance_exp_code;
1106:
1107: IF csr_get_invoice%NOTFOUND THEN
1108:
1109: /*A record doesnt exist in pn_var_rent_inv for the combination of period_id AND invoice_date */
1110:
1111: l_insert := TRUE;
1112: l_adjust_num := 0;
1113: l_for_term_status := 'N';

Line 1145: pnp_debug_pkg.log('Insert_Invoice - inserting into pn_var_rent_inv');

1141: close csr_get_invoice;
1142:
1143: IF l_insert THEN
1144:
1145: pnp_debug_pkg.log('Insert_Invoice - inserting into pn_var_rent_inv');
1146:
1147:
1148: PN_VAR_RENT_INV_PKG.INSERT_ROW (
1149: X_ROWID => l_rowid_out,

Line 1148: PN_VAR_RENT_INV_PKG.INSERT_ROW (

1144:
1145: pnp_debug_pkg.log('Insert_Invoice - inserting into pn_var_rent_inv');
1146:
1147:
1148: PN_VAR_RENT_INV_PKG.INSERT_ROW (
1149: X_ROWID => l_rowid_out,
1150: X_VAR_RENT_INV_ID => l_rent_inv_id,
1151: X_ADJUST_NUM => l_adjust_num,
1152: X_INVOICE_DATE => invoice_tbl(i).invoice_date,

Line 1199: pnp_debug_pkg.log('Insert_Invoice - Updating PN_VAR_RENT_INV ');

1195: l_rowid_out := null;
1196:
1197:
1198: ELSE
1199: pnp_debug_pkg.log('Insert_Invoice - Updating PN_VAR_RENT_INV ');
1200:
1201: /* Delete payment terms from pn_payment_terms created
1202: for the combination of var_rent_inv_id AND rent_TYPE
1203: that are in the draft status since we are recalculating

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 1253: /*get the invoices for all the periods from pn_var_rent_inv where the actual /actual-forecasted

1249:
1250: PROCEDURE apply_abatements (p_var_rent_id IN NUMBER)
1251: IS
1252:
1253: /*get the invoices for all the periods from pn_var_rent_inv where the actual /actual-forecasted
1254: variable rent amount has not been transferred */
1255:
1256: CURSOR csr_get_inv(p_var_rent_id NUMBER) is
1257: SELECT inv.rowid,

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 1341: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

1337:
1338:
1339: l_total_abatement pn_var_rents.abatement_amount%TYPE := 0;
1340: l_total_abt_appl NUMBER := 0;
1341: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;
1342: l_actual_invoice_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1343: l_negative_available NUMBER := 0;
1344: l_negative_applied NUMBER := 0;
1345: l_abatement_applied NUMBER := 0;

Line 1342: l_actual_invoice_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;

1338:
1339: l_total_abatement pn_var_rents.abatement_amount%TYPE := 0;
1340: l_total_abt_appl NUMBER := 0;
1341: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;
1342: l_actual_invoice_amt pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
1343: l_negative_available NUMBER := 0;
1344: l_negative_applied NUMBER := 0;
1345: l_abatement_applied NUMBER := 0;
1346: l_negative_rent_flag pn_var_rents.negative_rent%TYPE;

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 2567: -- exists then the corresponding row in pn_var_rent_inv should be deleted.

2563: -- PROCEDURE : process_vol_hist
2564: --
2565: -- Program to process rent when volume history is deleted. Checks to see
2566: -- if any volume history exists for an invoice date AND period. If none
2567: -- exists then the corresponding row in pn_var_rent_inv should be deleted.
2568: -- Also if no volume history exists for a group date AND line item then
2569: -- the corresponding record in pn_var_rent_SUMm should be deleted.
2570: --
2571: ----------------------------------------------------------------------------

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 2633: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE := null;

2629: l_rent_TYPE VARCHAR2(30):= null;
2630: l_adjust_num NUMBER := 0;
2631: l_rowid ROWID;
2632: l_delete BOOLEAN := FALSE;
2633: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE := null;
2634: l_var_exp_code pn_var_rent_inv.variance_exp_code%TYPE := null;
2635: l_var_rent_inv_id pn_var_rent_inv.var_rent_inv_id%TYPE;
2636:
2637: BEGIN

Line 2634: l_var_exp_code pn_var_rent_inv.variance_exp_code%TYPE := null;

2630: l_adjust_num NUMBER := 0;
2631: l_rowid ROWID;
2632: l_delete BOOLEAN := FALSE;
2633: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE := null;
2634: l_var_exp_code pn_var_rent_inv.variance_exp_code%TYPE := null;
2635: l_var_rent_inv_id pn_var_rent_inv.var_rent_inv_id%TYPE;
2636:
2637: BEGIN
2638: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (+) ');

Line 2635: l_var_rent_inv_id pn_var_rent_inv.var_rent_inv_id%TYPE;

2631: l_rowid ROWID;
2632: l_delete BOOLEAN := FALSE;
2633: l_for_exp_code pn_var_rent_inv.forecasted_exp_code%TYPE := null;
2634: l_var_exp_code pn_var_rent_inv.variance_exp_code%TYPE := null;
2635: l_var_rent_inv_id pn_var_rent_inv.var_rent_inv_id%TYPE;
2636:
2637: BEGIN
2638: pnp_debug_pkg.log('pn_variable_amount_pkg.process_vol_hist (+) ');
2639:

Line 2701: /* Delete from pn_var_rent_inv */

2697: WHERE var_rent_inv_id = l_var_rent_inv_id
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;

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 2807: l_constr_actual_rent pn_var_rent_inv.constr_actual_rent%TYPE := 0 ;

2803: p_negative_rent number,
2804: p_rec_abatement number,
2805: p_rec_abatement_override number)
2806: RETURN NUMBER IS
2807: l_constr_actual_rent pn_var_rent_inv.constr_actual_rent%TYPE := 0 ;
2808: l_actual_invoiced_amount pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
2809: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE := 0;
2810:
2811: BEGIN

Line 2808: l_actual_invoiced_amount pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;

2804: p_rec_abatement number,
2805: p_rec_abatement_override number)
2806: RETURN NUMBER IS
2807: l_constr_actual_rent pn_var_rent_inv.constr_actual_rent%TYPE := 0 ;
2808: l_actual_invoiced_amount pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
2809: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE := 0;
2810:
2811: BEGIN
2812: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (+) :');

Line 2809: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE := 0;

2805: p_rec_abatement_override number)
2806: RETURN NUMBER IS
2807: l_constr_actual_rent pn_var_rent_inv.constr_actual_rent%TYPE := 0 ;
2808: l_actual_invoiced_amount pn_var_rent_inv.actual_invoiced_amount%TYPE := 0;
2809: l_rec_abatement pn_var_rent_inv.rec_abatement%TYPE := 0;
2810:
2811: BEGIN
2812: pnp_debug_pkg.log('pn_variable_amount_pkg.derive_actual_invoiced_amt (+) :');
2813:

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: );