APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_VOL_HIST_ALL

Line 3209: FROM PN_VAR_VOL_HIST_ALL

3205: l_counter NUMBER := 0;
3206:
3207: CURSOR c1 IS
3208: SELECT vol_hist_id
3209: FROM PN_VAR_VOL_HIST_ALL
3210: WHERE line_item_id = p_line_item_id;
3211:
3212: BEGIN
3213:

Line 3802: FROM pn_var_vol_hist_ALL

3798: SELECT 1
3799: INTO l_volhist_exist
3800: FROM dual
3801: WHERE EXISTS ( SELECT vol_hist_id
3802: FROM pn_var_vol_hist_ALL
3803: WHERE line_item_id = p_line_item_id
3804: );
3805:
3806: RETURN l_volhist_exist;

Line 3858: FROM pn_var_vol_hist_all

3854: SELECT 'Y'
3855: INTO l_volhist_approved_exist
3856: FROM dual
3857: WHERE EXISTS ( SELECT vol_hist_id
3858: FROM pn_var_vol_hist_all
3859: WHERE line_item_id = p_line_item_id
3860: AND grp_date_id = p_grp_date_id
3861: AND vol_hist_status_code = 'APPROVED'
3862: );

Line 4872: FROM pn_var_vol_hist_ALL

4868: SELECT 1
4869: INTO l_exported
4870: FROM dual
4871: WHERE EXISTS ( SELECT vol_hist_id
4872: FROM pn_var_vol_hist_ALL
4873: WHERE vol_hist_id = p_id
4874: AND (actual_exp_code = 'Y' OR
4875: variance_exp_code = 'Y')
4876: );

Line 4941: FROM pn_var_vol_hist_ALL

4937: SELECT 1
4938: INTO l_exported
4939: FROM dual
4940: WHERE EXISTS ( SELECT vol_hist_id
4941: FROM pn_var_vol_hist_ALL
4942: WHERE vol_hist_id = p_id
4943: AND forecasted_exp_code = 'Y'
4944: );
4945:

Line 5009: FROM pn_var_vol_hist_ALL

5005: )
5006: )
5007: AND NOT EXISTS
5008: (SELECT vol_hist_id
5009: FROM pn_var_vol_hist_ALL
5010: WHERE period_id = p_period_id
5011: AND ((actual_exp_code = 'N' AND FORECASTED_exp_code ='N' AND variance_exp_code = 'N') OR
5012: (actual_exp_code = 'N' AND FORECASTED_exp_code ='Y' AND variance_exp_code = 'Y')
5013: )

Line 5033: FROM pn_var_vol_hist_all

5029: FROM pn_var_grp_dates_all
5030: WHERE period_id = p_period_id
5031: AND variance_exp_code = 'N')
5032: AND NOT EXISTS(SELECT vol_hist_id
5033: FROM pn_var_vol_hist_all
5034: WHERE period_id = p_period_id
5035: AND VARIANCE_EXP_CODE ='N' );
5036:
5037: RETURN l_status;

Line 5286: FROM pn_var_vol_hist_all vh

5282: SELECT 1
5283: INTO l_vol_ready_for_adjust
5284: FROM dual
5285: WHERE EXISTS(SELECT vh.grp_date_id
5286: FROM pn_var_vol_hist_all vh
5287: WHERE actual_exp_code = 'N'
5288: AND period_id = p_period_id
5289: AND EXISTS (SELECT grp.grp_date_id
5290: FROM pn_var_grp_dates_all grp

Line 5300: FROM pn_var_vol_hist_all vh

5296: SELECT 1
5297: INTO l_vol_ready_for_adjust
5298: FROM dual
5299: WHERE EXISTS(SELECT vh.grp_date_id
5300: FROM pn_var_vol_hist_all vh
5301: WHERE forecasted_exp_code = 'N'
5302: AND period_id = p_period_id
5303: AND EXISTS (SELECT grp.grp_date_id
5304: FROM pn_var_grp_dates_all grp

Line 7865: DELETE pn_var_vol_hist_all

7861: BEGIN
7862: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_vr_setup (+)');
7863:
7864: /* Delete the data from main tables */
7865: DELETE pn_var_vol_hist_all
7866: WHERE start_date > p_new_termn_date
7867: AND period_id IN (SELECT period_id
7868: FROM pn_var_periods_all
7869: WHERE var_rent_id = p_var_rent_id);

Line 8335: FROM pn_var_vol_hist_all

8331:
8332: /* Get the details of volume history */
8333: CURSOR vol_his_cur IS
8334: SELECT vol_hist_id, line_item_id
8335: FROM pn_var_vol_hist_all
8336: WHERE period_id = p_period_id
8337: AND p_new_termn_date BETWEEN start_date AND end_date;
8338:
8339:

Line 8774: DELETE pn_var_vol_hist_all

8770: BEGIN
8771: pnp_debug_pkg.debug ('pn_var_rent_pkg.delete_var_agreement (+)');
8772:
8773: /* Delete the data from main tables */
8774: DELETE pn_var_vol_hist_all
8775: WHERE period_id IN (SELECT period_id
8776: FROM pn_var_periods_all
8777: WHERE var_rent_id = p_var_rent_id);
8778: