APPS.MSC_WS_PLAN_MANAGEMENT dependencies on MSC_DESIGNATORS

Line 30: msc_designators desig

26: l_InsId,
27: l_PlanName
28: FROM
29: msc_plans plans,
30: msc_designators desig
31: WHERE
32: plans.organization_id = desig.organization_id AND
33: plans.sr_instance_id = desig.sr_instance_id AND
34: plans.compile_designator = desig.designator AND

Line 101: FROM msc_designators

97: l_Dest_OrgSel NUMBER;
98: BEGIN
99: BEGIN
100: SELECT organization_selection INTO l_Dest_OrgSel
101: FROM msc_designators
102: WHERE
103: designator = PlanName AND
104: organization_id = OrgId AND
105: sr_instance_id = InsId;

Line 124: msc_designators

120: BEGIN
121: SELECT
122: designator_id INTO l_DesignatorId
123: FROM
124: msc_designators
125: WHERE
126: designator_id = DesignatorId AND
127: nvl(copy_designator_id,-1) = -1 AND
128: (

Line 163: msc_designators desig

159: SELECT NVL(archive_flag, 2)
160: INTO ArchiveFlag
161: FROM
162: msc_plans plans,
163: msc_designators desig
164: WHERE
165: plans.organization_id = desig.organization_id AND
166: plans.sr_instance_id = desig.sr_instance_id AND
167: plans.compile_designator = desig.designator AND

Line 377: -- Update the MSC_DESIGNATORS table to disable it to prevent further

373: -- Hardcoding to mfg, Advanced Supply Chain Planner for prototype
374: -- this init function call is embedded in MSC_WS_COMMON.VALIDATE_USER_RESP
375: -- fnd_global.apps_initialize(1068, 21634, 724);
376:
377: -- Update the MSC_DESIGNATORS table to disable it to prevent further
378: -- activities, such as plan launch while the purge is taking place
379: BEGIN
380: UPDATE msc_designators
381: SET disable_date = sysdate

Line 380: UPDATE msc_designators

376:
377: -- Update the MSC_DESIGNATORS table to disable it to prevent further
378: -- activities, such as plan launch while the purge is taking place
379: BEGIN
380: UPDATE msc_designators
381: SET disable_date = sysdate
382: WHERE designator_id = DesignatorId;
383: EXCEPTION WHEN others THEN
384: g_ErrorCode := 'ERROR_UNEXPECTED_00006';