APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_DESIGNATORS

Line 179: from msc_designators desig, msc_plans plans

175: desig.organization_id,
176: desig.sr_instance_id,
177: plans.curr_plan_type,
178: plans.curr_overwrite_option
179: from msc_designators desig, msc_plans plans
180: where desig.designator = plans.compile_designator
181: and plans.plan_id= p_plan_id
182: and plans.organization_id = desig.organization_id
183: and plans.sr_instance_id = desig.sr_instance_id;

Line 189: FROM msc_designators

185: cursor temp_desig_exists_cur(p_designator in varchar2,
186: p_org_id in number,
187: p_instance_id in number) is
188: SELECT designator_id
189: FROM msc_designators
190: WHERE designator = p_designator
191: AND organization_id = p_org_id
192: AND sr_instance_id = p_instance_id;
193:

Line 448: update msc_designators

444: -- Copy Plan Options.
445: -- If running with 24X7mode then...
446: -- -----------------------------------------------------
447:
448: update msc_designators
449: set purge_current_plan = decode(p_24x7atp,3,2,1)
450: where designator_id = var_desig_id;
451:
452: msc_copy_plan_options.init_plan_id('N',NULL,NULL);

Line 1121: FROM msc_designators

1117: begin
1118:
1119: SELECT NVL(production, SYS_NO)
1120: INTO var_production1
1121: FROM msc_designators
1122: where organization_id = v_rec_c1.organization_id
1123: AND sr_instance_id = v_rec_c1.sr_instance_id
1124: AND (designator,designator_type) in
1125: (select compile_designator, plan_type

Line 1237: From Msc_Designators

1233: Cursor Desig_Cur(p_plan_id in number) Is
1234: Select Designator_Id,description, Inventory_Atp_Flag, launch_workflow_flag,
1235: Production, Disable_Date,organization_id, sr_instance_id,
1236: organization_selection,last_update_date,last_updated_by,last_update_login,nvl(purge_current_plan,2) purge_current_plan
1237: From Msc_Designators
1238: Where (Designator, Organization_Id, Sr_Instance_Id) =
1239: ( Select Compile_Designator, Organization_Id, Sr_Instance_Id
1240: From Msc_Plans
1241: Where Plan_Id=p_plan_id);

Line 1245: from msc_designators

1241: Where Plan_Id=p_plan_id);
1242:
1243: cursor c_plan_name(p_designator in varchar2) is
1244: select designator
1245: from msc_designators
1246: where designator = p_designator;
1247:
1248: v_org_Plan_Name_Cur Plan_Name_Cur%rowtype;
1249: v_temp_Plan_Name_Cur Plan_Name_Cur%rowtype;

Line 1356: update msc_designators

1352: summary_flag = decode(v_org_desig_cur.purge_current_plan,2,v_org_plan_name_Cur.summary_flag,null)
1353: where plan_id = p_org_plan_id;
1354:
1355: -- Modified for the bug#2850632
1356: update msc_designators
1357: set designator = decode(v_org_desig_cur.purge_current_plan,2,lv_plan_name,
1358: nvl(substr(to_char(p_temp_plan_id),-10),p_temp_plan_id)),
1359: -- copy_designator_id = v_temp_desig_cur.designator_id
1360: copy_designator_id = decode(v_org_desig_cur.purge_current_plan,2,-1,-2),

Line 1524: update msc_designators

1520: -- --------------------------------
1521: -- Set Copy_designator_id to -1.
1522: -- --------------------------------
1523:
1524: update msc_designators
1525: set copy_designator_id = -1,
1526: last_update_date = v_temp_plan_name_Cur.last_update_date,
1527: last_updated_by = v_temp_plan_name_Cur.last_updated_by,
1528: last_update_login = v_temp_plan_name_Cur.last_update_login,