APPS.MSC_COPY_PLAN_OPTIONS dependencies on MSC_PLANS

Line 91: from msc_plans

87: select nvl(organization_selection,3),designator_id
88: into l_org_selection , v_prev_designator_id
89: from msc_designators
90: where designator = (select compile_designator
91: from msc_plans
92: where plan_id = p_source_plan_id)
93: and organization_id = p_organization_id
94: and sr_instance_id = p_sr_instance_id;
95:

Line 526: 'MSC_PLANS',

522: P_plan_id IN number) is
523:
524: v_statement varchar2(1000);
525: v_tname_tab tname_type :=tname_type(
526: 'MSC_PLANS',
527: 'MSC_SUB_INVENTORIES',
528: 'MSC_PLAN_SCHEDULES',
529: 'MSC_PLAN_ORGANIZATIONS' );
530: v_tab_name varchar2(30);

Line 537: from msc_plans

533:
534: delete msc_designators
535: where (designator, organization_id, sr_instance_id) in (select
536: compile_designator, organization_id, sr_instance_id
537: from msc_plans
538: where plan_id=P_PLAN_ID);
539:
540: if P_plan_id = -1 then
541: raise ods_plan;

Line 581: update MSC_PLANS

577: end if;
578: p_plan_id := l_plan_id;
579: p_designator_id := l_designator_id;
580:
581: update MSC_PLANS
582: set copy_plan_id = p_src_Plan_id
583: where plan_id = p_plan_id;
584:
585: update MSC_DESIGNATORS

Line 626: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLANS';

622: end if;
623:
624: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
625: 'MSC_DESIGNATORS';
626: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLANS';
627: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
628: 'MSC_PLAN_ORGANIZATIONS';
629: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
630: 'MSC_PLAN_SCHEDULES';

Line 634: 'MSC_PLANS_OTHER';

630: 'MSC_PLAN_SCHEDULES';
631: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
632: 'MSC_SUB_INVENTORIES';
633: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
634: 'MSC_PLANS_OTHER';
635: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
636: 'MSC_PLAN_CATEGORIES';
637: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name :=
638: 'MSC_SOLVER_GROUPS';

Line 702: elsif p_source_table = 'MSC_PLANS' then

698: nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
699: , p_column_name /* 'null' */ ) into l_temp
700: from dual;
701:
702: elsif p_source_table = 'MSC_PLANS' then
703:
704: select decode(p_column_name ,'LAST_UPDATE_DATE' ,
705: ''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
706: ,'LAST_UPDATED_BY' , nvl(to_char(

Line 736: 'MSC_PLANS_OTHER',

732: , p_column_name) into l_temp from dual;
733:
734: elsif p_source_table in
735: ('MSC_PLAN_SCHEDULES', 'MSC_PLAN_ORGANIZATIONS', 'MSC_SUB_INVENTORIES',
736: 'MSC_PLANS_OTHER',
737: 'MSC_PLAN_CATEGORIES','MSC_SOLVER_GROUPS','MSC_SOL_GRP_RES','MSC_WRK_ORD_BD_STRUCTURE',
738: 'MSC_PLAN_QUERIES','MSC_RP_PLAN_ACCESS','MSC_PLAN_PROFILES' ) then
739:
740: select decode(p_column_name ,'LAST_UPDATE_DATE'

Line 812: elsif p_table_name = 'MSC_PLANS' then

808: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME
809: ,p_bind_var_col(1).P_DESCRIPTION ;
810:
811: --msc_util.debug_message(1 ,'End '|| p_table_name);
812: elsif p_table_name = 'MSC_PLANS' then
813: v_statement := 'INSERT INTO '||p_table_name||' (COMPILE_DESIGNATOR
814: ,DESCRIPTION ' ;
815: v_statement1 := ' SELECT :COMPILE_DESIGNATOR , :DESCRIPTION ' ;
816: --6028814

Line 841: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then

837: ,p_bind_var_col(1).P_DEST_PLAN_DESC ;
838:
839: -- msc_util.debug_message(2 ,'End '|| p_table_name);
840:
841: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then
842: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
843: for var in cur_design(p_table_name , v_msc_schema)
844: loop
845: i := i + 1;