DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_COPY_PLAN_OPTIONS

Line 380: msc_copy_plan_options.delete_temp_plan(errbuf, retcode, var_temp_desig_id, TRUE);

376: -- Delete the temp. plan because, for any plan,
377: -- only one temp. plan can exist at any instance.
378: -- ----------------------------------------------
379: MSC_UTIL.msc_Debug('deleting temp_plan '||var_temp_plan_id);
380: msc_copy_plan_options.delete_temp_plan(errbuf, retcode, var_temp_desig_id, TRUE);
381: if retcode >0 then
382: raise v_ex_error_plan_launch;
383: end if;
384: Commit;

Line 421: msc_copy_plan_options.init_plan_id('N',NULL,NULL);

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);
422: MSC_UTIL.msc_Debug('Copying plan options...' );
423: msc_copy_plan_options.copy_plan_options
424: ( v_plan_id , -- > p_source_plan_id
425: nvl(substr(to_char(v_plan_id),-10),v_plan_id), -- > p_dest_plan_name

Line 423: msc_copy_plan_options.copy_plan_options

419: where designator_id = var_desig_id;
420:
421: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
422: MSC_UTIL.msc_Debug('Copying plan options...' );
423: msc_copy_plan_options.copy_plan_options
424: ( v_plan_id , -- > p_source_plan_id
425: nvl(substr(to_char(v_plan_id),-10),v_plan_id), -- > p_dest_plan_name
426: var_desc, -- > p_dest_plan_desc
427: var_plan_type, -- > p_dest_plan_type

Line 435: msc_copy_plan_options.link_Plans

431: var_inactive_on, -- > p_dest_inactive_on
432: var_organization_id , -- > p_organization_id
433: var_sr_instance_id); -- > p_sr_instance_id
434:
435: msc_copy_plan_options.link_Plans
436: (errbuf, --> ERRBUF
437: retcode, --> RETCODE
438: v_plan_id, --> P_Src_plan_id
439: var_Desig_id, --> P_Src_Desg_id

Line 445: msc_copy_plan_options.init_plan_id('N',NULL,NULL);

441: var_temp_desig_id ); --> P_designator_id
442: if retcode > 0 then
443: raise v_ex_error_plan_launch;
444: end if;
445: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
446:
447: if var_overwrite_all<> 1 then
448: MSC_UTIL.msc_Debug('copying firm orders...' );
449: msc_copy_plan_options.copy_firm_orders(errbuf, retcode, v_plan_id, var_temp_plan_id);

Line 449: msc_copy_plan_options.copy_firm_orders(errbuf, retcode, v_plan_id, var_temp_plan_id);

445: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
446:
447: if var_overwrite_all<> 1 then
448: MSC_UTIL.msc_Debug('copying firm orders...' );
449: msc_copy_plan_options.copy_firm_orders(errbuf, retcode, v_plan_id, var_temp_plan_id);
450: if nvl(retcode,0) > 0 then
451: raise v_ex_error_plan_launch;
452: end if;
453: end if;

Line 1219: MSC_COPY_PLAN_OPTIONS.delete_plan_options

1215: -- To delete the Plan OPTIONS to enable
1216: -- to copy fresh plan options.
1217: -- ------------------------------------
1218:
1219: MSC_COPY_PLAN_OPTIONS.delete_plan_options
1220: (errbuf, retcode, p_temp_plan_id);
1221: if nvl(retcode,0) >0 then
1222: raise error_deletion;
1223: end if;

Line 1285: msc_copy_plan_options.init_plan_id('Y',p_temp_plan_id,v_temp_desig_cur.designator_id);

1281: and organization_id = v_org_desig_cur.organization_id
1282: and sr_instance_id = v_org_desig_cur.sr_instance_id;
1283:
1284:
1285: msc_copy_plan_options.init_plan_id('Y',p_temp_plan_id,v_temp_desig_cur.designator_id);
1286: msc_copy_plan_options.copy_plan_options
1287: ( p_org_plan_id, -- > p_source_plan_id
1288: v_org_plan_name_cur.compile_designator, -- > p_dest_plan_name
1289: v_org_desig_Cur.Description, -- > p_dest_plan_desc

Line 1286: msc_copy_plan_options.copy_plan_options

1282: and sr_instance_id = v_org_desig_cur.sr_instance_id;
1283:
1284:
1285: msc_copy_plan_options.init_plan_id('Y',p_temp_plan_id,v_temp_desig_cur.designator_id);
1286: msc_copy_plan_options.copy_plan_options
1287: ( p_org_plan_id, -- > p_source_plan_id
1288: v_org_plan_name_cur.compile_designator, -- > p_dest_plan_name
1289: v_org_desig_Cur.Description, -- > p_dest_plan_desc
1290: --v_org_Desig_Cur.organization_selection, -- > p_dest_org_selection

Line 1299: msc_copy_plan_options.init_plan_id('N',NULL,NULL);

1295: v_org_desig_Cur.disable_date, -- > p_dest_inactive_on
1296: v_org_desig_Cur.organization_id , -- > p_organization_id
1297: v_org_desig_Cur.sr_instance_id); -- > p_sr_instance_id
1298:
1299: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
1300: -- -----------------------------------------------
1301: -- Set the copy_plan_id to -1. Restore basic info.
1302: -- modified by planning engine.
1303: -- -----------------------------------------------

Line 1602: MSC_COPY_PLAN_OPTIONS.delete_temp_plan

1598: -- ---------------------------------
1599: -- Modified (forward port) for the bug # 3021850
1600: if nvl(v_org_desig_cur.purge_current_plan,1) = 1 THEN
1601: MSC_UTIL.msc_Debug('Purging Original plan...' );
1602: MSC_COPY_PLAN_OPTIONS.delete_temp_plan
1603: (errbuf, retcode, v_org_desig_cur.designator_id,FALSE);
1604:
1605: if nvl(retcode,0) >0 then
1606: raise error_deletion;