APPS.MSC_COPY_PLAN_OPTIONS dependencies on MSC_PLANS

Line 85: from msc_plans

81: select nvl(organization_selection,3),designator_id
82: into l_org_selection , v_prev_designator_id
83: from msc_designators
84: where designator = (select compile_designator
85: from msc_plans
86: where plan_id = p_source_plan_id)
87: and organization_id = p_organization_id
88: and sr_instance_id = p_sr_instance_id;
89:

Line 504: 'MSC_PLANS',

500: P_plan_id IN number) is
501:
502: v_statement varchar2(1000);
503: v_tname_tab tname_type :=tname_type(
504: 'MSC_PLANS',
505: 'MSC_SUB_INVENTORIES',
506: 'MSC_PLAN_SCHEDULES',
507: 'MSC_PLAN_ORGANIZATIONS' );
508: v_tab_name varchar2(30);

Line 515: from msc_plans

511:
512: delete msc_designators
513: where (designator, organization_id, sr_instance_id) in (select
514: compile_designator, organization_id, sr_instance_id
515: from msc_plans
516: where plan_id=P_PLAN_ID);
517:
518: if P_plan_id = -1 then
519: raise ods_plan;

Line 558: update MSC_PLANS

554: end if;
555: p_plan_id := l_plan_id;
556: p_designator_id := l_designator_id;
557:
558: update MSC_PLANS
559: set copy_plan_id = p_src_Plan_id
560: where plan_id = p_plan_id;
561:
562: update MSC_DESIGNATORS

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

596: p_source_table.delete;
597: end if;
598:
599: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_DESIGNATORS';
600: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLANS';
601: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLAN_ORGANIZATIONS';
602: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLAN_SCHEDULES';
603: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_SUB_INVENTORIES';
604: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLANS_OTHER';

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

600: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLANS';
601: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLAN_ORGANIZATIONS';
602: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLAN_SCHEDULES';
603: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_SUB_INVENTORIES';
604: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLANS_OTHER';
605: p_source_table(nvl(p_source_table.count , 0) + 1).p_table_name := 'MSC_PLAN_CATEGORIES';
606:
607: End inti_pl_sql_table;
608:

Line 639: elsif p_source_table = 'MSC_PLANS' then

635: ,'CREATION_DATE' , ''''||to_char(p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
636: ,'CREATED_BY' , nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
637: , p_column_name /* 'null' */ ) into l_temp from dual;
638:
639: elsif p_source_table = 'MSC_PLANS' then
640:
641: select decode(p_column_name ,'LAST_UPDATE_DATE' , ''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
642: ,'LAST_UPDATED_BY' , nvl(to_char( p_bind_var_col(1).P_LAST_UPDATED_BY) ,'null')
643: ,'CREATION_DATE' , ''''||to_char(p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''

Line 659: elsif p_source_table in ('MSC_PLAN_SCHEDULES', 'MSC_PLAN_ORGANIZATIONS', 'MSC_SUB_INVENTORIES', 'MSC_PLANS_OTHER', 'MSC_PLAN_CATEGORIES' ) then

655: ,'PLAN_RUN_DATE' , 'null'
656: ,'ORGANIZATION_SELECTION' , nvl(to_char(p_bind_var_col(1).P_REFRESH_NUMBER),'null')
657: , p_column_name) into l_temp from dual;
658:
659: elsif p_source_table in ('MSC_PLAN_SCHEDULES', 'MSC_PLAN_ORGANIZATIONS', 'MSC_SUB_INVENTORIES', 'MSC_PLANS_OTHER', 'MSC_PLAN_CATEGORIES' ) then
660:
661: select decode(p_column_name ,'LAST_UPDATE_DATE' ,''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
662: ,'LAST_UPDATED_BY' , nvl(to_char(p_bind_var_col(1).P_LAST_UPDATED_BY),'null')
663: ,'CREATION_DATE' ,''''||to_char( p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''

Line 719: elsif p_table_name = 'MSC_PLANS' then

715:
716: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DESCRIPTION ;
717:
718: --msc_util.debug_message(1 ,'End '|| p_table_name);
719: elsif p_table_name = 'MSC_PLANS' then
720: v_statement := 'INSERT INTO '||p_table_name||' (COMPILE_DESIGNATOR ,DESCRIPTION ' ;
721: v_statement1 := ' SELECT :COMPILE_DESIGNATOR , :DESCRIPTION ' ;
722: --6028814
723: for var in cur_design(p_table_name , v_msc_schema)

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

737: EXECUTE IMMEDIATE v_statement using p_bind_var_col(1).P_DEST_PLAN_NAME ,p_bind_var_col(1).P_DEST_PLAN_DESC ;
738:
739: -- msc_util.debug_message(2 ,'End '|| p_table_name);
740:
741: elsif p_table_name not in ( 'MSC_PLANS' ,'MSC_DESIGNATORS' ) then
742: -- msc_util.debug_message(2 ,'Start '|| p_table_name);
743: for var in cur_design(p_table_name , v_msc_schema)
744: loop
745: i := i + 1;