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_RENT_SUMM_ALL

Line 1388: -- pn_var_rent_summ_all

1384: -- : Warning! This is not the procedure which is called from
1385: -- calculate_rent. It is other overloaded post_summary.
1386: -- dd-mon-yyyy name o Created
1387: -- 21-MAY-07 Lokesh o Added rounding off for bug # 6031202 in
1388: -- pn_var_rent_summ_all
1389: --------------------------------------------------------------------------------
1390: PROCEDURE post_summary ( p_var_rent_id IN NUMBER
1391: ,p_period_id IN NUMBER
1392: ,p_line_item_id IN NUMBER

Line 1412: /* Get rent and volume to store in pn_var_rent_summ_all */

1408: grp.var_rent_id = p_vr_id AND
1409: grp.period_id = p_prd_id AND
1410: grp.grp_date_id = p_grp_id;
1411:
1412: /* Get rent and volume to store in pn_var_rent_summ_all */
1413: CURSOR summ_c( p_vr_id IN NUMBER
1414: ,p_prd_id IN NUMBER
1415: ,p_line_id IN NUMBER
1416: ,p_grp_id IN NUMBER) IS

Line 1444: pn_var_rent_summ_all

1440: ,p_grp_id IN NUMBER) IS
1441: SELECT
1442: var_rent_summ_id
1443: FROM
1444: pn_var_rent_summ_all
1445: WHERE
1446: var_rent_id = p_vr_id AND
1447: period_id = p_prd_id AND
1448: line_item_id = p_line_id AND

Line 1496: pn_var_rent_summ_all

1492:
1493: pnp_debug_pkg.log('inserting ...');
1494: /* to insert a new summary record */
1495: INSERT INTO
1496: pn_var_rent_summ_all
1497: (var_rent_summ_id
1498: ,var_rent_id
1499: ,period_id
1500: ,line_item_id

Line 1540: pn_var_rent_summ_all

1536: /* update the summary record */
1537:
1538: pnp_debug_pkg.log('updating ...');
1539: UPDATE
1540: pn_var_rent_summ_all
1541: SET
1542: tot_act_vol = summ_rec.sales
1543: ,tot_ded = summ_rec.ded
1544: ,act_var_rent = round(summ_rec.rent,g_precision)

Line 1587: -- pn_var_rent_summ_all

1583: -- HISTORY :
1584: --
1585: -- dd-mon-yyyy name o Created
1586: -- 21-MAY-07 Lokesh o Added rounding off for bug # 6031202 in
1587: -- pn_var_rent_summ_all
1588: --------------------------------------------------------------------------------
1589: PROCEDURE post_summary_firstyr ( p_var_rent_id IN NUMBER)
1590: IS
1591:

Line 1596: pn_var_rent_summ_all

1592: /* exists VR summ record */
1593: CURSOR vr_summ_fy_c IS
1594: SELECT *
1595: FROM
1596: pn_var_rent_summ_all
1597: WHERE
1598: var_rent_id = p_var_rent_id AND
1599: NVL(first_yr_rent, 0) <> 0;
1600:

Line 1609: pn_var_rent_summ_all

1605: ,tot_act_vol
1606: ,act_var_rent
1607: ,tot_ded
1608: FROM
1609: pn_var_rent_summ_all
1610: WHERE
1611: var_rent_id = p_var_rent_id AND
1612: period_id = p_period_id AND
1613: line_item_id = p_line_item_id;

Line 1666: pn_var_rent_summ_all

1662: vr_summ_fy_rec.first_yr_rent <> NVL(vr_summ_rec.act_var_rent, 0)
1663: THEN
1664:
1665: UPDATE
1666: pn_var_rent_summ_all
1667: SET
1668: tot_act_vol = vr_summ_fy_rec.tot_act_vol
1669: ,tot_ded = vr_summ_fy_rec.tot_ded
1670: ,act_var_rent = round(vr_summ_fy_rec.first_yr_rent,g_precision)

Line 1685: pn_var_rent_summ_all

1681:
1682:
1683: /* to insert a new summary record */
1684: INSERT INTO
1685: pn_var_rent_summ_all
1686: (var_rent_summ_id
1687: ,var_rent_id
1688: ,period_id
1689: ,line_item_id

Line 1763: pn_var_rent_summ_all

1759: SELECT
1760: invoice_date
1761: ,NVL(SUM(first_yr_rent), 0) AS total_actual_rent
1762: FROM
1763: pn_var_rent_summ_all
1764: WHERE
1765: var_rent_id = p_vr_id AND
1766: first_yr_rent IS NOT NULL
1767: GROUP BY

Line 2121: pn_var_rent_summ_all

2117: invoice_date
2118: ,NVL(SUM(tot_act_vol), 0) AS total_actual_sales
2119: ,NVL((SUM(act_var_rent) - NVL(SUM(first_yr_rent), 0)), 0) AS total_actual_rent
2120: FROM
2121: pn_var_rent_summ_all
2122: WHERE
2123: var_rent_id = p_vr_id AND
2124: period_id = p_prd_id AND
2125: invoice_date <= p_new_termn_date

Line 4663: pn_var_rent_summ_all

4659: ,NVL(SUM(tot_act_vol), 0) AS total_actual_sales
4660: ,NVL(SUM(act_var_rent), 0) AS total_actual_rent
4661: ,NVL(SUM(for_var_rent), 0) AS total_forecasted_rent
4662: FROM
4663: pn_var_rent_summ_all
4664: WHERE
4665: var_rent_id = p_vr_id AND
4666: period_id = p_prd_id
4667: GROUP BY

Line 5915: FROM pn_var_rent_summ_all

5911: AND period_num = 1;
5912:
5913: CURSOR first_period_cur IS
5914: SELECT period_id
5915: FROM pn_var_rent_summ_all
5916: WHERE var_rent_id = vr_id
5917: AND nvl(first_yr_rent,0) <> 0
5918: AND rownum < 2;
5919:

Line 5981: -- pn_var_rent_summ_all

5977: -- HISTORY :
5978: --
5979: -- 18.Sep.06 Shabda o Created
5980: -- 21-MAY-07 Lokesh o Added rounding off for bug # 6031202 in
5981: -- pn_var_rent_summ_all
5982: --------------------------------------------------------------------------------
5983: PROCEDURE post_summary_for ( p_var_rent_id IN NUMBER
5984: ,p_period_id IN NUMBER
5985: ,p_line_item_id IN NUMBER

Line 6005: /* Get rent and volume to store in pn_var_rent_summ_all */

6001: grp.var_rent_id = p_vr_id AND
6002: grp.period_id = p_prd_id AND
6003: grp.grp_date_id = p_grp_id;
6004:
6005: /* Get rent and volume to store in pn_var_rent_summ_all */
6006: CURSOR summ_c( p_vr_id IN NUMBER
6007: ,p_prd_id IN NUMBER
6008: ,p_line_id IN NUMBER
6009: ,p_grp_id IN NUMBER) IS

Line 6031: pn_var_rent_summ_all

6027: ,p_grp_id IN NUMBER) IS
6028: SELECT
6029: var_rent_summ_id
6030: FROM
6031: pn_var_rent_summ_all
6032: WHERE
6033: var_rent_id = p_vr_id AND
6034: period_id = p_prd_id AND
6035: line_item_id = p_line_id AND

Line 6077: pn_var_rent_summ_all

6073: IF l_vr_summ_id IS NULL THEN
6074:
6075: /* to insert a new summary record */
6076: INSERT INTO
6077: pn_var_rent_summ_all
6078: (var_rent_summ_id
6079: ,var_rent_id
6080: ,period_id
6081: ,line_item_id

Line 6118: pn_var_rent_summ_all

6114: ELSIF l_vr_summ_id IS NOT NULL THEN
6115: /* update the summary record */
6116:
6117: UPDATE
6118: pn_var_rent_summ_all
6119: SET
6120: tot_for_vol = summ_rec.sales
6121: ,for_var_rent = round(summ_rec.rent,g_precision)
6122: ,last_update_date = SYSDATE

Line 6165: -- pn_var_rent_summ_all

6161: -- HISTORY :
6162: --
6163: -- 18.Sep.06 Shabda o Created
6164: -- 21-MAY-07 Lokesh o Added rounding off for bug # 6031202 in
6165: -- pn_var_rent_summ_all
6166: --------------------------------------------------------------------------------
6167: PROCEDURE post_summary_for ( p_var_rent_id IN NUMBER
6168: ,p_period_id IN NUMBER)
6169: IS

Line 6202: /* Get rent and volume to store in pn_var_rent_summ_all */

6198:
6199: TYPE GRP_TBL IS TABLE OF grp_date_c%ROWTYPE INDEX BY BINARY_INTEGER;
6200: l_grp_t GRP_TBL;
6201:
6202: /* Get rent and volume to store in pn_var_rent_summ_all */
6203: CURSOR summ_c( p_vr_id IN NUMBER
6204: ,p_prd_id IN NUMBER
6205: ,p_line_id IN NUMBER
6206: ,p_grp_id IN NUMBER) IS

Line 6230: pn_var_rent_summ_all

6226: var_rent_summ_id
6227: ,tot_for_vol
6228: ,for_var_rent
6229: FROM
6230: pn_var_rent_summ_all
6231: WHERE
6232: var_rent_id = p_vr_id AND
6233: period_id = p_prd_id AND
6234: line_item_id = p_line_id AND

Line 6285: pn_var_rent_summ_all

6281: THEN
6282: pnp_debug_pkg.log('sales:'||summ_rec.sales);
6283: pnp_debug_pkg.log('rent: '||summ_rec.rent);
6284: UPDATE
6285: pn_var_rent_summ_all
6286: SET
6287: tot_for_vol = summ_rec.sales
6288: ,for_var_rent = round(summ_rec.rent,g_precision)
6289: ,last_update_date = SYSDATE

Line 6304: pn_var_rent_summ_all

6300:
6301: /* to insert a new summary record */
6302: pnp_debug_pkg.log('Inserting a new record for var_rent_summ table');
6303: INSERT INTO
6304: pn_var_rent_summ_all
6305: (var_rent_summ_id
6306: ,var_rent_id
6307: ,period_id
6308: ,line_item_id

Line 8809: FROM pn_var_rent_summ_all

8805: CURSOR true_up_cur IS
8806: SELECT sum(NVL(act_var_rent, 0)) + sum(NVL(trueup_var_rent, 0)) - sum(NVL(first_yr_rent,0)) true_up_rent,
8807: sum(NVL(tot_act_vol, 0)) true_up_vol,
8808: sum(NVL(tot_ded, 0)) true_up_deductions
8809: FROM pn_var_rent_summ_all
8810: WHERE period_id = p_period_id;
8811:
8812: BEGIN
8813:

Line 9762: -- pn_var_rent_summ_all

9758: -- fix for bug 5679847
9759: --
9760: -- dd-mon-yyyy name o Created
9761: -- 21-MAY-07 Lokesh o Added rounding off for bug # 6031202 in
9762: -- pn_var_rent_summ_all
9763: --------------------------------------------------------------------------------
9764: PROCEDURE post_summary ( p_var_rent_id IN NUMBER
9765: ,p_period_id IN NUMBER)
9766: IS

Line 9799: /* Get rent and volume to store in pn_var_rent_summ_all */

9795:
9796: TYPE GRP_TBL IS TABLE OF grp_date_c%ROWTYPE INDEX BY BINARY_INTEGER;
9797: l_grp_t GRP_TBL;
9798:
9799: /* Get rent and volume to store in pn_var_rent_summ_all */
9800: CURSOR summ_c( p_vr_id IN NUMBER
9801: ,p_prd_id IN NUMBER
9802: ,p_line_id IN NUMBER
9803: ,p_grp_id IN NUMBER) IS

Line 9836: pn_var_rent_summ_all

9832: ,tot_ded
9833: ,act_var_rent
9834: ,first_yr_rent
9835: FROM
9836: pn_var_rent_summ_all
9837: WHERE
9838: var_rent_id = p_vr_id AND
9839: period_id = p_prd_id AND
9840: line_item_id = p_line_id AND

Line 9902: pn_var_rent_summ_all

9898: THEN
9899:
9900: pnp_debug_pkg.log('before updation ...');
9901: UPDATE
9902: pn_var_rent_summ_all
9903: SET
9904: tot_act_vol = summ_rec.sales
9905: ,tot_ded = summ_rec.ded
9906: ,act_var_rent = round(summ_rec.rent,g_precision)

Line 9924: pn_var_rent_summ_all

9920: pnp_debug_pkg.log('before insertion ...');
9921:
9922: /* to insert a new summary record */
9923: INSERT INTO
9924: pn_var_rent_summ_all
9925: (var_rent_summ_id
9926: ,var_rent_id
9927: ,period_id
9928: ,line_item_id

Line 10399: pn_var_rent_summ_all

10395: CURSOR invoice_cur( p_vr_id IN NUMBER) IS
10396: SELECT
10397: invoice_date, period_id
10398: FROM
10399: pn_var_rent_summ_all
10400: WHERE
10401: var_rent_id = p_vr_id
10402: GROUP BY
10403: invoice_date, period_id

Line 10690: FROM pn_var_rent_summ_all

10686:
10687: CURSOR full_yr_cur IS
10688: SELECT sum(NVL(tot_act_vol, 0)) yr_vol,
10689: sum(NVL(tot_ded, 0)) yr_deductions
10690: FROM pn_var_rent_summ_all
10691: WHERE line_item_id = p_line_item_id;
10692:
10693: BEGIN
10694: