APPS.MSC_COPY_PLAN_OPTIONS dependencies on MSC_DESIGNATORS

Line 63: select msc_designators_s.nextval

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

Line 89: from msc_designators

85: from dual;
86:
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

Line 534: delete msc_designators

530: v_tab_name varchar2(30);
531: ods_plan exception;
532: Begin
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);

Line 585: update MSC_DESIGNATORS

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
586: set copy_Designator_id = p_src_Desg_id
587: Where designator_id = p_designator_id;
588: retcode := 0;
589: errbuf := NULL;

Line 625: 'MSC_DESIGNATORS';

621: p_source_table.delete;
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 :=

Line 660: if p_source_table = 'MSC_DESIGNATORS' then

656: return varchar2 is
657: l_temp varchar2(4000);
658: l_count number ;
659: begin
660: if p_source_table = 'MSC_DESIGNATORS' then
661:
662: select decode(p_column_name ,'DESIGNATOR_ID' ,
663: nvl(to_char(p_bind_var_col(1).P_DESIGNATOR_ID ) , 'null')
664: ,'DESIGNATOR' ,

Line 787: if p_table_name = 'MSC_DESIGNATORS' then

783:
784: Begin
785: lv_retval := FND_INSTALLATION.GET_APP_INFO ('MSC', lv_dummy1,
786: lv_dummy2,v_msc_schema);
787: if p_table_name = 'MSC_DESIGNATORS' then
788: v_statement := 'INSERT INTO '||p_table_name||' (DESIGNATOR ,DESCRIPTION ' ;
789: v_statement1 := ' SELECT :DESIGNATOR , :DESCRIPTION ' ;
790: for var in cur_design(p_table_name , v_msc_schema)
791: loop

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;