eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_LIABILITY dependencies on MSD_DEMAND_PLANS

Line 265: update msd_demand_plans

261:
262: display_message('Liability Plan Validation: BEGIN' ,INFORMATION );
263:
264: /* Set the liability plan to INVALID */
265: update msd_demand_plans
266: set valid_flag = 1
267: where demand_plan_id = p_liability_plan_id ;
268:
269: /* Validate the plan */

Line 279: update msd_demand_plans

275: /* If Validation Fails, Return */
276: IF retcode = 2 THEN
277: RETURN;
278: ELSE /* Set the plan status to VALID */
279: update msd_demand_plans
280: set valid_flag = 0
281: where demand_plan_id = p_liability_plan_id ;
282: END IF;
283:

Line 501: update msd_demand_plans set plan_start_date = x_plan_start_date , plan_end_date = x_plan_end_date

497: END IF ;
498: */
499: ---display_message('CS_NAME ', x_liab_plan_name ) ;
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')

Line 524: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;

520:
521:
522: /* If Set up Validation Fails Exit with Error */
523: IF retcode = 2 THEN
524: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;
525: RETURN ;
526:
527:
528: display_message(' Validating Demand Plan Definition' , DEBUG ) ;

Line 535: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;

531:
532: IF retcode = 2 THEN
533:
534: RETURN ;
535: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;
536:
537: END IF;
538:
539: /* Set the Previous Plan dates */

Line 637: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;

633:
634: /* If Validation Fails Exit with Error */
635: IF retcode = 2 THEN
636: RETURN ;
637: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;
638: END IF;
639:
640:
641:

Line 644: update msd_demand_plans set valid_flag = 0 where liab_plan_id = p_plan_id ;

640:
641:
642:
643: /* Here set the Demand Plan to Valid or Invalid */
644: update msd_demand_plans set valid_flag = 0 where liab_plan_id = p_plan_id ;
645:
646:
647: /* Start:DPE Download */
648: /* Place Holder for DPE API */

Line 665: from msd_demand_plans

661: /* IF the build errors out then the error out handling is done */
662:
663: -- retcode := MSD_COMMON_UTILITIES_LB.liability_post_process( 97608 , 'TOTAL_LIABILITY', 1) ;
664: Select DP_BUILD_ERROR_FLAG into x_DP_BUILD_ERROR_FLAG
665: from msd_demand_plans
666: where demand_plan_id = MSD_COMMON_UTILITIES_LB.get_demand_plan_id(p_plan_id) ;
667:
668: IF nvl( x_DP_BUILD_ERROR_FLAG , 'NO') = 'YES' THEN
669: display_message('Plan Build Unsuccessful' ,ERROR );

Line 2036: FROM msd_demand_plans

2032: Counter NUMBER;
2033:
2034: CURSOR C IS
2035: SELECT demand_plan_name
2036: FROM msd_demand_plans
2037: WHERE demand_plan_id = p_demand_plan_id
2038: FOR UPDATE of demand_plan_name NOWAIT;
2039: Recinfo C%ROWTYPE;
2040:

Line 2081: from msd_demand_plans ;

2077: from msd_level_values_lb
2078: minus
2079: Select
2080: liab_plan_id plan_id
2081: from msd_demand_plans ;
2082:
2083: a_plan_id plan_id_tab;
2084:
2085: BEGIN

Line 2199: update msd_demand_plans set base_uom = x_base_uom where liab_plan_id = p_plan_id ;

2195:
2196:
2197:
2198:
2199: update msd_demand_plans set base_uom = x_base_uom where liab_plan_id = p_plan_id ;
2200:
2201: OPEN c_agreement ;
2202: FETCH c_agreement into x_no_of_agreements ;
2203: CLOSE c_agreement ;

Line 2208: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;

2204:
2205: /* BUG # 4283643-----Plan can validate without any agreement, it will give warning and make the plan INVALID.*/
2206: IF x_no_of_agreements = 0 THEN
2207: retcode := 1 ;
2208: update msd_demand_plans set valid_flag = 1 where liab_plan_id = p_plan_id ;
2209: display_message( 'No valid Liability agreements were found for the items in this plan.',WARNING);
2210:
2211: -- display_message( 'No Demand Plan has been created for the Given Supply Plan ', INFORMATION) ;
2212:

Line 2237: msd_demand_plans mdp

2233: FROM
2234: msd_dp_scenario_output_levels a,
2235: msd_levels ml,
2236: msd_dp_scenarios scen,
2237: msd_demand_plans mdp
2238: WHERE a.level_id = ml.level_id
2239: AND a.scenario_id = scen.scenario_id
2240: AND scen.enable_flag = 'Y'
2241: and scen.demand_plan_id = mdp.demand_plan_id

Line 2253: msd_demand_plans mdp

2249:
2250: CURSOR c_lowest_time_lvl
2251: IS
2252: select m_min_tim_lvl_id from
2253: msd_demand_plans mdp
2254: where
2255: mdp.liab_plan_id =p_plan_id ;
2256:
2257:

Line 2263: msd_demand_plans mdp

2259: IS
2260: select mdc.calendar_type
2261: from
2262: msd_dp_calendars mdc ,
2263: msd_demand_plans mdp
2264: where
2265: mdc.demand_plan_id = mdp.demand_plan_id
2266: and mdp.liab_plan_id = p_plan_id
2267: and mdc.calendar_type = 2 ;