APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 3205: FROM PN_VAR_VOL_HIST_ALL

3201: l_counter NUMBER := 0;
3202:
3203: CURSOR c1 IS
3204: SELECT vol_hist_id
3205: FROM PN_VAR_VOL_HIST_ALL
3206: WHERE line_item_id = p_line_item_id;
3207:
3208: BEGIN
3209:

Line 3798: FROM pn_var_vol_hist_ALL

3794: SELECT 1
3795: INTO l_volhist_exist
3796: FROM dual
3797: WHERE EXISTS ( SELECT vol_hist_id
3798: FROM pn_var_vol_hist_ALL
3799: WHERE line_item_id = p_line_item_id
3800: );
3801:
3802: RETURN l_volhist_exist;

Line 3854: FROM pn_var_vol_hist_all

3850: SELECT 'Y'
3851: INTO l_volhist_approved_exist
3852: FROM dual
3853: WHERE EXISTS ( SELECT vol_hist_id
3854: FROM pn_var_vol_hist_all
3855: WHERE line_item_id = p_line_item_id
3856: AND grp_date_id = p_grp_date_id
3857: AND vol_hist_status_code = 'APPROVED'
3858: );

Line 4868: FROM pn_var_vol_hist_ALL

4864: SELECT 1
4865: INTO l_exported
4866: FROM dual
4867: WHERE EXISTS ( SELECT vol_hist_id
4868: FROM pn_var_vol_hist_ALL
4869: WHERE vol_hist_id = p_id
4870: AND (actual_exp_code = 'Y' OR
4871: variance_exp_code = 'Y')
4872: );

Line 4937: FROM pn_var_vol_hist_ALL

4933: SELECT 1
4934: INTO l_exported
4935: FROM dual
4936: WHERE EXISTS ( SELECT vol_hist_id
4937: FROM pn_var_vol_hist_ALL
4938: WHERE vol_hist_id = p_id
4939: AND forecasted_exp_code = 'Y'
4940: );
4941:

Line 5005: FROM pn_var_vol_hist_ALL

5001: )
5002: )
5003: AND NOT EXISTS
5004: (SELECT vol_hist_id
5005: FROM pn_var_vol_hist_ALL
5006: WHERE period_id = p_period_id
5007: AND ((actual_exp_code = 'N' AND FORECASTED_exp_code ='N' AND variance_exp_code = 'N') OR
5008: (actual_exp_code = 'N' AND FORECASTED_exp_code ='Y' AND variance_exp_code = 'Y')
5009: )

Line 5029: FROM pn_var_vol_hist_all

5025: FROM pn_var_grp_dates_all
5026: WHERE period_id = p_period_id
5027: AND variance_exp_code = 'N')
5028: AND NOT EXISTS(SELECT vol_hist_id
5029: FROM pn_var_vol_hist_all
5030: WHERE period_id = p_period_id
5031: AND VARIANCE_EXP_CODE ='N' );
5032:
5033: RETURN l_status;

Line 5282: FROM pn_var_vol_hist_all vh

5278: SELECT 1
5279: INTO l_vol_ready_for_adjust
5280: FROM dual
5281: WHERE EXISTS(SELECT vh.grp_date_id
5282: FROM pn_var_vol_hist_all vh
5283: WHERE actual_exp_code = 'N'
5284: AND period_id = p_period_id
5285: AND EXISTS (SELECT grp.grp_date_id
5286: FROM pn_var_grp_dates_all grp

Line 5296: FROM pn_var_vol_hist_all vh

5292: SELECT 1
5293: INTO l_vol_ready_for_adjust
5294: FROM dual
5295: WHERE EXISTS(SELECT vh.grp_date_id
5296: FROM pn_var_vol_hist_all vh
5297: WHERE forecasted_exp_code = 'N'
5298: AND period_id = p_period_id
5299: AND EXISTS (SELECT grp.grp_date_id
5300: FROM pn_var_grp_dates_all grp

Line 7859: DELETE pn_var_vol_hist_all

7855: BEGIN
7856: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_vr_setup (+)');
7857:
7858: /* Delete the data from main tables */
7859: DELETE pn_var_vol_hist_all
7860: WHERE start_date > p_new_termn_date
7861: AND period_id IN (SELECT period_id
7862: FROM pn_var_periods_all
7863: WHERE var_rent_id = p_var_rent_id);

Line 8325: FROM pn_var_vol_hist_all

8321:
8322: /* Get the details of volume history */
8323: CURSOR vol_his_cur IS
8324: SELECT vol_hist_id, line_item_id
8325: FROM pn_var_vol_hist_all
8326: WHERE period_id = p_period_id
8327: AND p_new_termn_date BETWEEN start_date AND end_date;
8328:
8329:

Line 8757: DELETE pn_var_vol_hist_all

8753: BEGIN
8754: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_var_agreement (+)');
8755:
8756: /* Delete the data from main tables */
8757: DELETE pn_var_vol_hist_all
8758: WHERE period_id IN (SELECT period_id
8759: FROM pn_var_periods_all
8760: WHERE var_rent_id = p_var_rent_id);
8761: