APPS.MSD_LIABILITY dependencies on MSD_DP_PARAMETERS

Line 504: UPDATE msd_dp_parameters set start_date = x_plan_start_date , end_date = x_plan_end_date

500:
501: update msd_demand_plans set plan_start_date = x_plan_start_date , plan_end_date = x_plan_end_date
502: where demand_plan_id = x_liab_plan_id ;
503:
504: UPDATE msd_dp_parameters set start_date = x_plan_start_date , end_date = x_plan_end_date
505: WHERE parameter_type in ( 'MSD_LIAB_OPEN_PO' , 'MSD_LIAB_FORECAST' ,'MSD_LIAB_FCST_DEMAND')
506: and demand_plan_id = x_liab_plan_id ;
507:
508: commit ;

Line 509: /*UPDATE msd_dp_parameters SET PARAMETER_NAME = x_liab_plan_name

505: WHERE parameter_type in ( 'MSD_LIAB_OPEN_PO' , 'MSD_LIAB_FORECAST' ,'MSD_LIAB_FCST_DEMAND')
506: and demand_plan_id = x_liab_plan_id ;
507:
508: commit ;
509: /*UPDATE msd_dp_parameters SET PARAMETER_NAME = x_liab_plan_name
510: WHERE demand_plan_id = x_liab_plan_id ; */
511:
512:
513:

Line 585: UPDATE msd_dp_parameters set start_date = x_plan_start_date , end_date = x_plan_end_date

581: x_plan_end_date := MSD_COMMON_UTILITIES_LB.get_cp_end_date ;
582:
583:
584:
585: UPDATE msd_dp_parameters set start_date = x_plan_start_date , end_date = x_plan_end_date
586: WHERE parameter_type in ( 'MSD_LIAB_OPEN_PO' , 'MSD_LIAB_FORECAST' ,'MSD_LIAB_FCST_DEMAND')
587: and demand_plan_id = x_liab_plan_id ;
588:
589: END IF ;

Line 739: FROM msd_dp_parameters_cs_v

735: /* This cursor returns the maximum and minimum dates of the input parameters */
736: CURSOR get_input_date is
737: SELECT
738: min(start_date), max(end_date)
739: FROM msd_dp_parameters_cs_v
740: WHERE demand_plan_id = p_demand_plan_id;
741:
742:
743: /* This cursor returns the start date and end date of a given calendar */

Line 760: FROM msd_dp_parameters mdp , msd_cs_definitions mcd

756: distinct
757: mdp.parameter_type ,
758: mcd.planning_server_view_name ,
759: mcd.description
760: FROM msd_dp_parameters mdp , msd_cs_definitions mcd
761: where mdp.demand_plan_id =p_demand_plan_id
762: and parameter_type =mcd.name
763: and nvl( mcd.planning_server_view_name, 'NA') <> 'NA'
764: and nvl(mcd.liability_user_flag , 'N') <> 'Y' ;