APPS.MSC_COPY_PLAN_OPTIONS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

l_org_selection      number;

Line: 62

	  select msc_designators_s.nextval
	  into v_designator_id
	  from dual;

Line: 69

  select decode(p_dest_plan_type, 1, 3,
                                  2, 2,
                                  3, 4,
                                  4, 5,
                                  5,8,
                                  6,9,
                                  7,10,
                                  8,11,
                                  9,12)
  into v_designator_type
  from dual;

Line: 81

  select nvl(organization_selection,3),designator_id
  into l_org_selection , v_prev_designator_id
  from msc_designators
  where designator =  (select compile_designator
                       from msc_plans
                       where plan_id = p_source_plan_id)
  and   organization_id = p_organization_id
  and   sr_instance_id =  p_sr_instance_id;

Line: 108

  v_col_value(1).P_REFRESH_NUMBER		:= l_org_selection ;

Line: 109

  v_col_value(1).P_ORGANIZATION_SELECTION	:= 2 ;

Line: 111

  v_col_value(1).P_LAST_UPDATE_DATE		:= sysdate ;

Line: 112

  v_col_value(1).P_LAST_UPDATED_BY		:= fnd_global.user_id ;

Line: 115

  v_col_value(1).P_LAST_UPDATE_LOGIN		:= fnd_global.login_id ;

Line: 255

							,'UPDATED'
							,'SUBST_ITEM_FLAG'
							,'STATUS'
							,'APPLIED'
							,'EXPIRATION_QUANTITY'
							,'EXPIRATION_DATE'
							,'NON_NETTABLE_QTY'
							,'IMPLEMENT_WIP_START_DATE'
							,'REFRESH_NUMBER'
							,'REQUEST_ID'
							,'PROGRAM_APPLICATION_ID'
							,'PROGRAM_ID'
							,'PROGRAM_UPDATE_DATE'
							,'IMPLEMENT_DAILY_RATE'
							,'NEED_BY_DATE'
							,'SOURCE_SUPPLY_ID'
							,'SR_MTL_SUPPLY_ID'
							,'WIP_STATUS_CODE'
							,'DEMAND_CLASS'
							,'FROM_ORGANIZATION_ID'
							,'WIP_SUPPLY_TYPE'
							,'PO_LINE_ID'
							,'LOAD_FACTOR_RATE'
							,'ROUTING_SEQUENCE_ID'
							,'BILL_SEQUENCE_ID'
							,'COPRODUCTS_SUPPLY'
							,'CFM_ROUTING_FLAG'
							,'CUSTOMER_ID'
							,'SHIP_TO_SITE_ID'
							,'OLD_NEED_BY_DATE'
							,'OLD_DAILY_RATE'
							,'OLD_FIRST_UNIT_START_DATE'
							,'OLD_LAST_UNIT_COMPLETION_DATE'
							,'OLD_NEW_SCHEDULE_DATE'
							,'OLD_QTY_COMPLETED'
							,'OLD_NEW_ORDER_QUANTITY'
							,'OLD_FIRM_QUANTITY'
							,'OLD_FIRM_DATE'
							,'PLANNING_PARTNER_SITE_ID'
							,'PLANNING_TP_TYPE'
							,'OWNING_PARTNER_SITE_ID'
							,'OWNING_TP_TYPE'
							,'VMI_FLAG'
							,'EARLIEST_START_DATE'
							,'EARLIEST_COMPLETION_DATE'
							,'MIN_START_DATE'
							,'SCHEDULED_DEMAND_ID'
							,'EXPLOSION_DATE'
							,'SCO_SUPPLY_DATE'
							,'RECORD_SOURCE'
							,'SUPPLY_IS_SHARED'
							,'ULPSD'
							,'ULPCD'
							,'UEPSD'
							,'UEPCD'
							,'EACD'
							,'ORIGINAL_NEED_BY_DATE'
							,'ORIGINAL_QUANTITY'
							,'ACCEPTANCE_REQUIRED_FLAG'
							);

Line: 344

							,'UPDATED'
							,'SUBST_RES_FLAG'
							,'REFRESH_NUMBER'
							,'REQUEST_ID'
							,'PROGRAM_APPLICATION_ID'
							,'PROGRAM_ID'
							,'PROGRAM_UPDATE_DATE'
							,'SOURCE_ITEM_ID'
							,'ASSEMBLY_ITEM_ID'
							,'SUPPLY_TYPE'
							,'FIRM_START_DATE'
							,'FIRM_END_DATE'
							,'FIRM_FLAG'
							,'CUMMULATIVE_QUANTITY'
							,'YIELD'
							,'REVERSE_CUMULATIVE_YIELD'
							,'BATCH_NUMBER'
							,'MINIMUM_TRANSFER_QUANTITY'
							,'REMAINING_CAPACITY'
							,'OVERLOADED_CAPACITY'
							,'EARLIEST_START_DATE'
							,'EARLIEST_COMPLETION_DATE'
							,'SCHEDULED_DEMAND_ID'
							,'ULPSD'
							,'ULPCD'
							,'UEPSD'
							,'UEPCD'
							,'EACD'
							,'PARENT_SEQ_NUM');

Line: 374

	v_select_cols varchar2(8000);

Line: 375

	v_insert_cols varchar2(8000);

Line: 380

	v_insert_who   varchar2(4000):= ',last_update_date,' ||
                            		'last_updated_by,'  ||
                            		'creation_date,'    ||
                            		'created_by,'       ||
                            		'last_update_login ';

Line: 385

	v_select_who   varchar2(4000):= ',sysdate,' 		||
                            		'fnd_global.user_id,'   ||
                            		'sysdate,'  		||
                            		'fnd_global.user_id,' 	||
                            		'fnd_global.user_id ';

Line: 408

		v_select_cols:= null;

Line: 411

				if v_select_cols is null then
                        		v_select_cols := v_table_name || '.' ||v_supp_col_list(i);

Line: 413

                        		v_insert_cols := v_supp_col_list(i);

Line: 415

                        		v_select_cols := v_select_cols||',' || v_table_name || '.' ||v_supp_col_list(i);

Line: 416

                        		v_insert_cols := v_insert_cols||',' || v_supp_col_list(i);

Line: 419

			v_supp_col_list.delete;

Line: 422

                                if v_select_cols is null then
                                        v_select_cols := v_table_name || '.' ||v_res_col_list(i);

Line: 424

                                        v_insert_cols := v_res_col_list(i);

Line: 426

                                        v_select_cols := v_select_cols||',' || v_table_name || '.' ||v_res_col_list(i);

Line: 427

                                        v_insert_cols := v_insert_cols||',' || v_res_col_list(i);

Line: 430

			v_res_col_list.delete;

Line: 437

		v_statement := 'INSERT into '	||v_table_name ||'(plan_id, '|| v_insert_cols || v_insert_who || ')'
  						|| ' SELECT  :Dest_Plan_Id, '|| v_select_cols  || v_select_who
  						|| v_from_where;

Line: 458

PROCEDURE delete_temp_plan( 	errbuf 	   out NOCOPY varchar2,
				retcode    out NOCOPY number,
				P_desig_id IN  	      number,
				p_childreq IN 	      boolean default false) is

	v_request_id       number;

Line: 496

End delete_temp_plan;

Line: 498

PROCEDURE delete_plan_options(  errbuf    out NOCOPY varchar2,
				retcode   out NOCOPY number,
				P_plan_id IN  	     number) is

	v_statement varchar2(1000);

Line: 512

  delete msc_designators
  where (designator, organization_id, sr_instance_id) in (select
         compile_designator, organization_id, sr_instance_id
         from msc_plans
         where plan_id=P_PLAN_ID);

Line: 524

	v_statement := 'delete from ' || v_tab_name || ' where plan_id=' || ':p_plan_id';

Line: 539

End Delete_plan_options;

Line: 558

	update MSC_PLANS
	set copy_plan_id = p_src_Plan_id
	where plan_id = p_plan_id;

Line: 562

	update MSC_DESIGNATORS
	set   copy_Designator_id = p_src_Desg_id
	Where designator_id = p_designator_id;

Line: 596

	p_source_table.delete;

Line: 618

select decode(p_column_name ,'DESIGNATOR_ID' ,  nvl(to_char(p_bind_var_col(1).P_DESIGNATOR_ID ) , 'null')
                                    ,'DESIGNATOR' , ''''||p_bind_var_col(1).P_DEST_PLAN_NAME||''''
				      ,'DESIGNATOR_TYPE' , nvl(to_char( p_bind_var_col(1).P_DESIGNATOR_TYPE),'null')
				      ,'ORGANIZATION_ID' , nvl(to_char(p_bind_var_col(1).P_ORGANIZATION_ID) , 'null')
				      ,'MPS_RELIEF' , nvl(to_char(p_bind_var_col(1).P_MPS_RELIEF),'null')
				      ,'INVENTORY_ATP_FLAG' , nvl(to_char(p_bind_var_col(1).P_INVENTORY_ATP_FLAG),'null')
				      ,'PRODUCTION' , nvl(to_char(p_bind_var_col(1).P_PRODUCTION), 'null')
				      ,'LAUNCH_WORKFLOW_FLAG' , nvl(to_char(p_bind_var_col(1).P_LAUNCH_WORKFLOW_FLAG) ,'null')
				      ,'DESCRIPTION' , ':DESCRIPTION' --''''||p_bind_var_col(1).P_DESCRIPTION||''''
				      ,'DISABLE_DATE' , ''''||decode(p_bind_var_col(1).P_DISABLE_DATE , null ,
				       p_bind_var_col(1).P_DISABLE_DATE
				      ,to_char(p_bind_var_col(1).P_DISABLE_DATE , 'DD-MON-RRRR'))||''''
				      ,'SR_INSTANCE_ID' , nvl(to_char(p_bind_var_col(1).P_SR_INSTANCE_ID),'null')
				      ,'REFRESH_NUMBER' , nvl(to_char( p_bind_var_col(1).P_REFRESH_NUMBER) , 'null')
				      ,'ORGANIZATION_SELECTION' , nvl(to_char( p_bind_var_col(1).P_ORGANIZATION_SELECTION) , 'null')
				      ,'LAST_UPDATE_DATE' ,''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
				      ,'LAST_UPDATED_BY' , nvl(to_char( p_bind_var_col(1).P_LAST_UPDATED_BY) ,'null')
				      ,'CREATION_DATE' , ''''||to_char(p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
				      ,'CREATED_BY' ,  nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
				      , p_column_name /* 'null' */ ) into l_temp from dual;

Line: 641

select decode(p_column_name ,'LAST_UPDATE_DATE' , ''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
				      ,'LAST_UPDATED_BY' , nvl(to_char( p_bind_var_col(1).P_LAST_UPDATED_BY) ,'null')
				      ,'CREATION_DATE' , ''''||to_char(p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
				      ,'CREATED_BY' ,  nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
				      ,'LAST_UPDATE_LOGIN' ,nvl(to_char( p_bind_var_col(1).P_LAST_UPDATE_LOGIN),'null')
				      ,'COPY_PLAN' , nvl(to_char( p_bind_var_col(1).P_COPY_PLAN ) ,'null')
				      ,'PLAN_ID' , nvl(to_char(p_bind_var_col(1).P_DEST_PLAN_ID ) ,'null')
				      ,'COMPILE_DESIGNATOR' ,''''||p_bind_var_col(1).P_DEST_PLAN_NAME||''''
				      ,'CURR_PLAN_TYPE' , nvl(to_char( p_bind_var_col(1).P_DEST_PLAN_TYPE) , 'null')
				      ,'PLAN_TYPE' ,  nvl(to_char(p_bind_var_col(1).P_DEST_PLAN_TYPE),'null')
				      ,'DESCRIPTION' , ':DESCRIPTION' --''''||p_bind_var_col(1).P_DEST_PLAN_DESC||''''
				      ,'PLAN_COMPLETION_DATE' , 'null'
				      ,'PLAN_START_DATE' , 'null'
				      ,'DATA_COMPLETION_DATE' , 'null'
				      ,'PLAN_RUN_DATE' , 'null'
				      ,'ORGANIZATION_SELECTION' , nvl(to_char(p_bind_var_col(1).P_REFRESH_NUMBER),'null')
				      , p_column_name) into l_temp from dual;

Line: 661

select decode(p_column_name ,'LAST_UPDATE_DATE' ,''''||to_char(p_bind_var_col(1).P_LAST_UPDATE_DATE , 'DD-MON-RRRR')||''''
				      ,'LAST_UPDATED_BY' , nvl(to_char(p_bind_var_col(1).P_LAST_UPDATED_BY),'null')
				      ,'CREATION_DATE' ,''''||to_char( p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
				      ,'CREATED_BY' ,  nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
				      ,'LAST_UPDATE_LOGIN' , nvl(to_char(p_bind_var_col(1).P_LAST_UPDATE_LOGIN),'null')
				      ,'PLAN_ID' , nvl(to_char(p_bind_var_col(1).P_DEST_PLAN_ID),'null')
				      , p_column_name) into l_temp from dual;

Line: 691

select column_name , data_type , data_length
from all_tab_cols
where table_name = l_table_name
and owner = l_owner ;

Line: 699

 v_statement := 'INSERT INTO '||p_table_name||' (DESIGNATOR ,DESCRIPTION '  ;

Line: 700

 v_statement1 := ' SELECT :DESIGNATOR , :DESCRIPTION ' ;

Line: 720

      v_statement := 'INSERT INTO '||p_table_name||' (COMPILE_DESIGNATOR ,DESCRIPTION '  ;

Line: 721

      v_statement1 := ' SELECT :COMPILE_DESIGNATOR , :DESCRIPTION ' ;

Line: 747

		v_statement  := 'INSERT INTO '||p_table_name||'  (' ||var.column_name  ;

Line: 760

		v_statement1 := ' SELECT ' ||Get_Column_Value(p_bind_var_col ,var.column_name , var.data_type ,	p_table_name );