APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_RENT_SUMM_ALL

Line 811: -- pn_var_rent_summ_all

807: -- insert/update pn_var_rent_SUMm with the new variable rent
808: --
809: -- 14-JUL-05 hareesha o Bug 4284035 - Replaced pn_var_rent_SUMm with _ALL table.
810: -- 21-MAY-07 Lokesh o Added rounding off for bug # 6031202 in
811: -- pn_var_rent_summ_all
812: -----------------------------------------------------------------------------
813:
814: PROCEDURE process_rent (p_var_rent_id IN NUMBER,
815: p_period_id IN NUMBER,

Line 843: FROM pn_var_rent_summ_all

839:
840: CURSOR csr_cum_rent(p_line_item_id NUMBER,
841: p_group_date DATE) IS
842: SELECT NVL(decode(g_rent_TYPE,'FORECASTED',SUM(for_var_rent),SUM(act_var_rent)),0)
843: FROM pn_var_rent_summ_all
844: WHERE line_item_id = p_line_item_id
845: AND group_date < p_group_date;
846:
847: BEGIN

Line 914: INSERT INTO pn_var_rent_summ_all

910: l_act_var_rent := l_var_rent;
911: END IF;
912:
913:
914: INSERT INTO pn_var_rent_summ_all
915: (VAR_RENT_SUMM_ID
916: ,VAR_RENT_ID
917: ,PERIOD_ID
918: ,LINE_ITEM_ID

Line 957: UPDATE pn_var_rent_SUMm_all

953: ELSE
954:
955: /* update pn_var_rent_SUMm for the combination of line_item_id AND grp_date_id*/
956:
957: UPDATE pn_var_rent_SUMm_all
958: SET tot_act_vol = decode(g_rent_TYPE,'ACTUAL',p_tot_vol,tot_act_vol),
959: tot_ded = decode(g_rent_TYPE,'ACTUAL',p_tot_ded,tot_ded),
960: act_var_rent = decode(g_rent_TYPE,'ACTUAL',round(l_var_rent,g_precision),
961: round(act_var_rent,g_precision)),

Line 1003: FROM pn_var_rent_summ_all

999: apply_constraints(ip_period_id,SUM(act_var_rent))
1000: ),g_precision
1001: )constr_act_rent,
1002: (SUM(tot_act_vol) - SUM(tot_ded)) actual_volume
1003: FROM pn_var_rent_summ_all
1004: WHERE period_id= ip_period_id
1005: AND invoice_date = ip_invoice_date;
1006:
1007: CURSOR csr_get_invoice(ip_period_id NUMBER,

Line 1032: FROM pn_var_rent_summ_all summ

1028:
1029: CURSOR csr_cum_vol (ip_period_id NUMBER,
1030: ip_invoice_date DATE) IS
1031: SELECT (summ.tot_act_vol - NVL(summ.tot_ded,0)) cum_act_vol
1032: FROM pn_var_rent_summ_all summ
1033: WHERE summ.group_date = (SELECT MAX(summ1.group_date)
1034: FROM pn_var_rent_summ_all summ1
1035: WHERE summ1.invoice_date = ip_invoice_date
1036: AND summ1.period_id = ip_period_id)

Line 1034: FROM pn_var_rent_summ_all summ1

1030: ip_invoice_date DATE) IS
1031: SELECT (summ.tot_act_vol - NVL(summ.tot_ded,0)) cum_act_vol
1032: FROM pn_var_rent_summ_all summ
1033: WHERE summ.group_date = (SELECT MAX(summ1.group_date)
1034: FROM pn_var_rent_summ_all summ1
1035: WHERE summ1.invoice_date = ip_invoice_date
1036: AND summ1.period_id = ip_period_id)
1037: AND summ.period_id = ip_period_id;
1038:

Line 1602: FROM pn_var_rent_summ_all

1598: SELECT 'Y'
1599: INTO l_varrent_exists
1600: FROM dual
1601: WHERE EXISTS (SELECT null
1602: FROM pn_var_rent_summ_all
1603: WHERE line_item_id = p_line_item_id
1604: AND grp_date_id = p_grp_date_id);
1605:
1606: RETURN l_varrent_exists;

Line 1996: FROM pn_var_rent_summ_all summ,

1992: SELECT 'Y'
1993: INTO l_volume_exists
1994: FROM dual
1995: WHERE not exists (SELECT null
1996: FROM pn_var_rent_summ_all summ,
1997: (SELECT gd.period_id,
1998: lines.line_item_id,
1999: gd.grp_date_id
2000: FROM pn_var_lines_all lines,

Line 2175: FROM pn_var_rent_summ_all summ,

2171: SELECT summ.tot_act_vol,
2172: summ.tot_for_vol,
2173: summ.tot_ded,
2174: decode(vrent.cumulative_vol ,'N','N','T','N','Y')
2175: FROM pn_var_rent_summ_all summ,
2176: pn_var_rents_all vrent
2177: WHERE summ.line_item_id = p_line_item_id
2178: AND summ.group_date = p_group_date
2179: AND summ.var_rent_id = vrent.var_rent_id;

Line 2186: FROM pn_var_rent_summ_all summ

2182: p_group_date DATE) IS
2183: SELECT nvl(summ.tot_act_vol,0),
2184: nvl(summ.tot_for_vol,0),
2185: nvl(summ.tot_ded,0)
2186: FROM pn_var_rent_summ_all summ
2187: WHERE summ.group_date =(SELECT max(summ1.group_date)
2188: FROM pn_var_rent_summ_all summ1
2189: WHERE summ1.group_date < p_group_date
2190: AND summ1.line_item_id = p_line_item_id)

Line 2188: FROM pn_var_rent_summ_all summ1

2184: nvl(summ.tot_for_vol,0),
2185: nvl(summ.tot_ded,0)
2186: FROM pn_var_rent_summ_all summ
2187: WHERE summ.group_date =(SELECT max(summ1.group_date)
2188: FROM pn_var_rent_summ_all summ1
2189: WHERE summ1.group_date < p_group_date
2190: AND summ1.line_item_id = p_line_item_id)
2191: AND summ.line_item_id = p_line_item_id;
2192:

Line 2652: DELETE from pn_var_rent_SUMm_all

2648: CLOSE csr_any_vol_exists;
2649:
2650: /* Delete from pn_var_rent_SUMm */
2651: IF l_any_vol_exists = 'N' THEN
2652: DELETE from pn_var_rent_SUMm_all
2653: WHERE grp_date_id = p_grp_date_id
2654: AND line_item_id = p_line_item_id;
2655: END IF;
2656: