APPS.MSC_COPY_PLAN_OPTIONS dependencies on MSC_DESIGNATORS

Line 62: select msc_designators_s.nextval

58: v_dest_plan_id := L_plan_id;
59: end if;
60:
61: if NVL(L_Temp_plan,'N') = 'N' then
62: select msc_designators_s.nextval
63: into v_designator_id
64: from dual;
65: L_designator_id := v_designator_id;
66: else

Line 83: from msc_designators

79: from dual;
80:
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

Line 512: delete msc_designators

508: v_tab_name varchar2(30);
509: ods_plan exception;
510: Begin
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);

Line 562: update MSC_DESIGNATORS

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
563: set copy_Designator_id = p_src_Desg_id
564: Where designator_id = p_designator_id;
565: retcode := 0;
566: errbuf := NULL;

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

595: if nvl(l_count , 0) > 0 then
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';

Line 616: if p_source_table = 'MSC_DESIGNATORS' then

612: return varchar2 is
613: l_temp varchar2(4000);
614: l_count number ;
615: begin
616: if p_source_table = 'MSC_DESIGNATORS' then
617:
618: select decode(p_column_name ,'DESIGNATOR_ID' , nvl(to_char(p_bind_var_col(1).P_DESIGNATOR_ID ) , 'null')
619: ,'DESIGNATOR' , ''''||p_bind_var_col(1).P_DEST_PLAN_NAME||''''
620: ,'DESIGNATOR_TYPE' , nvl(to_char( p_bind_var_col(1).P_DESIGNATOR_TYPE),'null')

Line 698: if p_table_name = 'MSC_DESIGNATORS' then

694: and owner = l_owner ;
695:
696: Begin
697: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1, lv_dummy2,v_msc_schema);
698: if p_table_name = 'MSC_DESIGNATORS' then
699: v_statement := 'INSERT INTO '||p_table_name||' (DESIGNATOR ,DESCRIPTION ' ;
700: v_statement1 := ' SELECT :DESIGNATOR , :DESCRIPTION ' ;
701: for var in cur_design(p_table_name , v_msc_schema)
702: loop

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;