DBA Data[Home] [Help]

APPS.MSD_EOL_PLAN dependencies on MSD_COMMON_UTILITIES

Line 272: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')

268: p_demand_plan_id
269: ,msd_dp_parameters_s.nextval
270: ,par.PARAMETER_TYPE
271: ,mds.supply_plan_name
272: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
273: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
274: ,par.OUTPUT_SCENARIO_ID
275: ,mds.SCENARIO_ID
276: ,mds.DEMAND_PLAN_ID

Line 273: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')

269: ,msd_dp_parameters_s.nextval
270: ,par.PARAMETER_TYPE
271: ,mds.supply_plan_name
272: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
273: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
274: ,par.OUTPUT_SCENARIO_ID
275: ,mds.SCENARIO_ID
276: ,mds.DEMAND_PLAN_ID
277: ,nvl(mdsr.REVISION,-1)

Line 360: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')

356: p_demand_plan_id
357: ,msd_dp_parameters_s.nextval
358: ,par.PARAMETER_TYPE
359: ,mds.supply_plan_name
360: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
361: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
362: ,par.OUTPUT_SCENARIO_ID
363: ,mds.SCENARIO_ID
364: ,mds.DEMAND_PLAN_ID

Line 361: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')

357: ,msd_dp_parameters_s.nextval
358: ,par.PARAMETER_TYPE
359: ,mds.supply_plan_name
360: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
361: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
362: ,par.OUTPUT_SCENARIO_ID
363: ,mds.SCENARIO_ID
364: ,mds.DEMAND_PLAN_ID
365: ,nvl(mdsr.REVISION,-1)

Line 474: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')

470: p_demand_plan_id
471: ,msd_dp_parameters_s.nextval
472: ,par.PARAMETER_TYPE
473: ,mds.supply_plan_name
474: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
475: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
476: ,par.OUTPUT_SCENARIO_ID
477: ,mds.SCENARIO_ID
478: ,mds.DEMAND_PLAN_ID

Line 475: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')

471: ,msd_dp_parameters_s.nextval
472: ,par.PARAMETER_TYPE
473: ,mds.supply_plan_name
474: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
475: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
476: ,par.OUTPUT_SCENARIO_ID
477: ,mds.SCENARIO_ID
478: ,mds.DEMAND_PLAN_ID
479: ,decode(nvl(mdsr.revision,-1), nvl(mdp2.revision,-1) , -1 , mdsr.revision)