APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_DESIGNATORS

Line 174: from msc_designators desig, msc_plans plans

170: desig.organization_id,
171: desig.sr_instance_id,
172: plans.curr_plan_type,
173: plans.curr_overwrite_option
174: from msc_designators desig, msc_plans plans
175: where desig.designator = plans.compile_designator
176: and plans.plan_id= p_plan_id
177: and plans.organization_id = desig.organization_id
178: and plans.sr_instance_id = desig.sr_instance_id;

Line 184: FROM msc_designators

180: cursor temp_desig_exists_cur(p_designator in varchar2,
181: p_org_id in number,
182: p_instance_id in number) is
183: SELECT designator_id
184: FROM msc_designators
185: WHERE designator = p_designator
186: AND organization_id = p_org_id
187: AND sr_instance_id = p_instance_id;
188:

Line 417: update msc_designators

413: -- Copy Plan Options.
414: -- If running with 24X7mode then...
415: -- -----------------------------------------------------
416:
417: update msc_designators
418: set purge_current_plan = decode(p_24x7atp,3,2,1)
419: where designator_id = var_desig_id;
420:
421: msc_copy_plan_options.init_plan_id('N',NULL,NULL);

Line 1045: FROM msc_designators

1041: begin
1042:
1043: SELECT NVL(production, SYS_NO)
1044: INTO var_production1
1045: FROM msc_designators
1046: where organization_id = v_rec_c1.organization_id
1047: AND sr_instance_id = v_rec_c1.sr_instance_id
1048: AND (designator,designator_type) in
1049: (select compile_designator, plan_type

Line 1154: From Msc_Designators

1150: Cursor Desig_Cur(p_plan_id in number) Is
1151: Select Designator_Id,description, Inventory_Atp_Flag, launch_workflow_flag,
1152: Production, Disable_Date,organization_id, sr_instance_id,
1153: organization_selection,last_update_date,last_updated_by,last_update_login,nvl(purge_current_plan,2) purge_current_plan
1154: From Msc_Designators
1155: Where (Designator, Organization_Id, Sr_Instance_Id) =
1156: ( Select Compile_Designator, Organization_Id, Sr_Instance_Id
1157: From Msc_Plans
1158: Where Plan_Id=p_plan_id);

Line 1162: from msc_designators

1158: Where Plan_Id=p_plan_id);
1159:
1160: cursor c_plan_name(p_designator in varchar2) is
1161: select designator
1162: from msc_designators
1163: where designator = p_designator;
1164:
1165: v_org_Plan_Name_Cur Plan_Name_Cur%rowtype;
1166: v_temp_Plan_Name_Cur Plan_Name_Cur%rowtype;

Line 1273: update msc_designators

1269: summary_flag = decode(v_org_desig_cur.purge_current_plan,2,v_org_plan_name_Cur.summary_flag,null)
1270: where plan_id = p_org_plan_id;
1271:
1272: -- Modified for the bug#2850632
1273: update msc_designators
1274: set designator = decode(v_org_desig_cur.purge_current_plan,2,lv_plan_name,
1275: nvl(substr(to_char(p_temp_plan_id),-10),p_temp_plan_id)),
1276: -- copy_designator_id = v_temp_desig_cur.designator_id
1277: copy_designator_id = decode(v_org_desig_cur.purge_current_plan,2,-1,-2),

Line 1441: update msc_designators

1437: -- --------------------------------
1438: -- Set Copy_designator_id to -1.
1439: -- --------------------------------
1440:
1441: update msc_designators
1442: set copy_designator_id = -1,
1443: last_update_date = v_temp_plan_name_Cur.last_update_date,
1444: last_updated_by = v_temp_plan_name_Cur.last_updated_by,
1445: last_update_login = v_temp_plan_name_Cur.last_update_login,