APPS.MSC_WS_COMMON dependencies on MSC_PLANS

Line 179: FROM MSC_PLANS

175: l_PlanName VARCHAR2(10);
176: BEGIN
177: BEGIN
178: SELECT COMPILE_DESIGNATOR INTO l_PlanName
179: FROM MSC_PLANS
180: WHERE PLAN_ID = PlanId;
181: EXCEPTION WHEN NO_DATA_FOUND THEN
182: Status := 'INVALID_PLANID';
183: RETURN FALSE;

Line 207: from msc_plans

203: l_def_pref_id number;
204: l_plan_type number;
205: cursor plan_type_c(v_plan_id number) is
206: select curr_plan_type
207: from msc_plans
208: where plan_id = v_plan_id;
209: BEGIN
210: open plan_type_c(arg_plan_id);
211: fetch plan_type_c into l_plan_type;

Line 257: msc_plans plans,

253: OrgId,
254: InsId,
255: PlanName
256: FROM
257: msc_plans plans,
258: msc_designators desig
259: WHERE
260: plans.organization_id = desig.organization_id AND
261: plans.sr_instance_id = desig.sr_instance_id AND

Line 386: UPDATE msc_plans

382: Overwrite IN NUMBER
383: ) AS
384: BEGIN
385: BEGIN
386: UPDATE msc_plans
387: SET
388: item_simulation_set_id = ItemSimulationSetId,
389: curr_overwrite_option = Overwrite
390: WHERE