DBA Data[Home] [Help]

APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_COPY_PLAN_OPTIONS

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

407: -- Delete the temp. plan because, for any plan,
408: -- only one temp. plan can exist at any instance.
409: -- ----------------------------------------------
410: MSC_UTIL.msc_Debug('deleting temp_plan '||var_temp_plan_id);
411: msc_copy_plan_options.delete_temp_plan(errbuf, retcode, var_temp_desig_id, TRUE);
412: if retcode >0 then
413: raise v_ex_error_plan_launch;
414: end if;
415: Commit;

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

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);
453: MSC_UTIL.msc_Debug('Copying plan options...' );
454: msc_copy_plan_options.copy_plan_options
455: ( v_plan_id , -- > p_source_plan_id
456: nvl(substr(to_char(v_plan_id),-10),v_plan_id), -- > p_dest_plan_name

Line 454: msc_copy_plan_options.copy_plan_options

450: where designator_id = var_desig_id;
451:
452: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
453: MSC_UTIL.msc_Debug('Copying plan options...' );
454: msc_copy_plan_options.copy_plan_options
455: ( v_plan_id , -- > p_source_plan_id
456: nvl(substr(to_char(v_plan_id),-10),v_plan_id), -- > p_dest_plan_name
457: var_desc, -- > p_dest_plan_desc
458: var_plan_type, -- > p_dest_plan_type

Line 466: msc_copy_plan_options.link_Plans

462: var_inactive_on, -- > p_dest_inactive_on
463: var_organization_id , -- > p_organization_id
464: var_sr_instance_id); -- > p_sr_instance_id
465:
466: msc_copy_plan_options.link_Plans
467: (errbuf, --> ERRBUF
468: retcode, --> RETCODE
469: v_plan_id, --> P_Src_plan_id
470: var_Desig_id, --> P_Src_Desg_id

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

472: var_temp_desig_id ); --> P_designator_id
473: if retcode > 0 then
474: raise v_ex_error_plan_launch;
475: end if;
476: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
477:
478: if var_overwrite_all<> 1 then
479: MSC_UTIL.msc_Debug('copying firm orders...' );
480: msc_copy_plan_options.copy_firm_orders(errbuf, retcode, v_plan_id, var_temp_plan_id);

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

476: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
477:
478: if var_overwrite_all<> 1 then
479: MSC_UTIL.msc_Debug('copying firm orders...' );
480: msc_copy_plan_options.copy_firm_orders(errbuf, retcode, v_plan_id, var_temp_plan_id);
481: if nvl(retcode,0) > 0 then
482: raise v_ex_error_plan_launch;
483: end if;
484: end if;

Line 1302: MSC_COPY_PLAN_OPTIONS.delete_plan_options

1298: -- To delete the Plan OPTIONS to enable
1299: -- to copy fresh plan options.
1300: -- ------------------------------------
1301:
1302: MSC_COPY_PLAN_OPTIONS.delete_plan_options
1303: (errbuf, retcode, p_temp_plan_id);
1304: if nvl(retcode,0) >0 then
1305: raise error_deletion;
1306: end if;

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

1364: and organization_id = v_org_desig_cur.organization_id
1365: and sr_instance_id = v_org_desig_cur.sr_instance_id;
1366:
1367:
1368: msc_copy_plan_options.init_plan_id('Y',p_temp_plan_id,v_temp_desig_cur.designator_id);
1369: msc_copy_plan_options.copy_plan_options
1370: ( p_org_plan_id, -- > p_source_plan_id
1371: v_org_plan_name_cur.compile_designator, -- > p_dest_plan_name
1372: v_org_desig_Cur.Description, -- > p_dest_plan_desc

Line 1369: msc_copy_plan_options.copy_plan_options

1365: and sr_instance_id = v_org_desig_cur.sr_instance_id;
1366:
1367:
1368: msc_copy_plan_options.init_plan_id('Y',p_temp_plan_id,v_temp_desig_cur.designator_id);
1369: msc_copy_plan_options.copy_plan_options
1370: ( p_org_plan_id, -- > p_source_plan_id
1371: v_org_plan_name_cur.compile_designator, -- > p_dest_plan_name
1372: v_org_desig_Cur.Description, -- > p_dest_plan_desc
1373: --v_org_Desig_Cur.organization_selection, -- > p_dest_org_selection

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

1378: v_org_desig_Cur.disable_date, -- > p_dest_inactive_on
1379: v_org_desig_Cur.organization_id , -- > p_organization_id
1380: v_org_desig_Cur.sr_instance_id); -- > p_sr_instance_id
1381:
1382: msc_copy_plan_options.init_plan_id('N',NULL,NULL);
1383: -- -----------------------------------------------
1384: -- Set the copy_plan_id to -1. Restore basic info.
1385: -- modified by planning engine.
1386: -- -----------------------------------------------

Line 1717: MSC_COPY_PLAN_OPTIONS.delete_temp_plan

1713: -- ---------------------------------
1714: -- Modified (forward port) for the bug # 3021850
1715: if nvl(v_org_desig_cur.purge_current_plan,1) = 1 THEN
1716: MSC_UTIL.msc_Debug('Purging Original plan...' );
1717: MSC_COPY_PLAN_OPTIONS.delete_temp_plan
1718: (errbuf, retcode, v_org_desig_cur.designator_id,FALSE);
1719:
1720: if nvl(retcode,0) >0 then
1721: raise error_deletion;