APPS.MST_COPY_PLAN_OPTIONS SQL Statements

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

Line: 42

      select plan_id
      into l_plan_id
      from mst_plans
      where plan_id = -1-l_user_id;

Line: 51

    select (sysdate + nvl(system_date_offset, 0)) start_date_new,
           (sysdate + nvl(nvl(system_date_offset,0) + plan_days, 1)) cutoff_date_new
    into v_dest_start_date, v_dest_end_date
    from mst_plans
    where plan_id = l_plan_id;

Line: 58

    select start_date, cutoff_date
    into v_dest_start_date, v_dest_end_date
    from mst_plans
    where plan_id = p_source_plan_id;

Line: 71

  select mst_plans_s.nextval
  into v_dest_plan_id
  from dual;

Line: 76

              'INSERT INTO MST_PLANS(' ||
	      'plan_id, ' ||
	      'plan_type, ' ||
              'compile_designator, '  ||
              'description, '  ||
              'start_date, '   ||
              'cutoff_date, '  ||
              'OUTSIDE_PROCESSING_FLAG, '  ||
              'DROP_SHIPMENT_FLAG, '  ||
              'SHIP_FROM_SUPPLIER_FLAG, ' ||
              'SHIP_TO_CUSTOMER_FLAG, '  ||
              'RETURN_TO_SUPPLIER_FLAG, '  ||
	      'RETURN_FROM_CUSTOMER_FLAG, '  ||
              'INT_INBOUND_ALL_FLAG, '  ||
              'INT_OUTBOUND_ALL_FLAG, '  ||
              'EXT_OUTBOUND_ALL_FLAG, '  ||
              'EXT_INBOUND_ALL_FLAG, '  ||
              'OPTIMIZATION_STRATEGY_FLAG, '  ||
              'POOLING_FLAG, '  ||
              'MULTI_STOP_TL_FLAG, '  ||
              'CONTINUOUS_MOVE_FLAG, ' ||
	      'OPTIMIZED_FLAG, '  ||
	      'PALLETIZE_FLAG, '  ||
	      'TARGET_TL_UTILIZATION, '  ||
              'MIN_TL_UTILIZATION, '  ||
              'LOCAL_POOLING_SHIPMENT_SIZE, '  ||
              'LOCAL_POOLING_RADIUS, '  ||
              'STOP_NEIGHBORHOOD_RADIUS, '  ||
       	      'GENERAL_POOLING_RADIUS'  ||
	      ',POOL_POINT_COUNT'  ||
	      ',LOADING_UNLOADING_CHARGE'  ||
	      ',LAYOVER_CHARGES'  ||
	      ',ORIGIN_DESTINATION_TL_CHRGS'  ||
	      ',OTHER_TL_CHARGES'  ||
	      ',OTHER_LTL_CHARGES'  ||
	      ',OTHER_PARCEL_CHARGES'  ||
	      ',LTL_DISCOUNT'  ||
	      ',PARCEL_DISCOUNT'  ||
	      ',AUTO_RELEASE'  ||
	      ',AUTO_REL_RULE_SET_ID'  ||
	      ',COMMITMENT_SET_ID'  ||
	      ',CURRENCY_UOM'  ||
	      ',DISTANCE_UOM'  ||
	      ',TIME_UOM'  ||
	      ',VOLUME_UOM'  ||
	      ',WEIGHT_UOM'  ||
	      ',CREATED_BY' ||
              ',CREATION_DATE' ||
              ',LAST_UPDATED_BY' ||
              ',LAST_UPDATE_DATE' ||
              ',LAST_UPDATE_LOGIN' ||
              ',DIMENSION_UOM' ||
	      ',MAXIMUM_EMPTY_LEG_LENGTH) '  ||
  'select   '  ||
              ':v_dest_plan_id, ' ||
              'plan_type, ' ||
              ':p_dest_plan_name, '  ||
              ':p_dest_plan_desc, '  ||
              ':v_dest_start_date, '   ||
              ':v_dest_end_date, '  ||
              'OUTSIDE_PROCESSING_FLAG, '  ||
              'DROP_SHIPMENT_FLAG, '  ||
              'SHIP_FROM_SUPPLIER_FLAG, ' ||
              'SHIP_TO_CUSTOMER_FLAG, '  ||
              'RETURN_TO_SUPPLIER_FLAG, '  ||
              'RETURN_FROM_CUSTOMER_FLAG, '  ||
              'INT_INBOUND_ALL_FLAG, '  ||
              'INT_OUTBOUND_ALL_FLAG, '  ||
              'EXT_OUTBOUND_ALL_FLAG, '  ||
              'EXT_INBOUND_ALL_FLAG, '  ||
              'OPTIMIZATION_STRATEGY_FLAG, '  ||
              l_POOLING_FLAG||',' ||
              'MULTI_STOP_TL_FLAG, '  ||
              'CONTINUOUS_MOVE_FLAG, ' ||
              'OPTIMIZED_FLAG,   '  ||
              'PALLETIZE_FLAG, '  ||
              'TARGET_TL_UTILIZATION, '  ||
              'MIN_TL_UTILIZATION, '  ||
              'LOCAL_POOLING_SHIPMENT_SIZE, '  ||
              'LOCAL_POOLING_RADIUS, '  ||
              'STOP_NEIGHBORHOOD_RADIUS, '  ||
              'GENERAL_POOLING_RADIUS'  ||
              ',POOL_POINT_COUNT'  ||
              ',LOADING_UNLOADING_CHARGE'  ||
              ',LAYOVER_CHARGES'  ||
              ',ORIGIN_DESTINATION_TL_CHRGS'  ||
              ',OTHER_TL_CHARGES'  ||
              ',OTHER_LTL_CHARGES'  ||
              ',OTHER_PARCEL_CHARGES'  ||
              ',LTL_DISCOUNT'  ||
              ',PARCEL_DISCOUNT'  ||
              ',AUTO_RELEASE'  ||
              ',AUTO_REL_RULE_SET_ID'  ||
              ',COMMITMENT_SET_ID'  ||
              ',CURRENCY_UOM'  ||
              ',DISTANCE_UOM'  ||
              ',TIME_UOM'  ||
              ',VOLUME_UOM'  ||
              ',WEIGHT_UOM'  ||
              ',:v_user_id' ||
              ',:v_sysdate' ||
              ',:v_user_id' ||
              ',:v_sysdate' ||
              ',:v_login_id' ||
              ',DIMENSION_UOM' ||
              ',MAXIMUM_EMPTY_LEG_LENGTH '  ||
  'from MST_PLANS '  ||
  'where plan_id = :p_source_plan_id';

Line: 192

              'INSERT INTO MST_PLAN_FACILITIES(' ||
 	      'plan_id, ' ||
	      'FACILITY_ID, ' ||
              'INT_INBOUND_FLAG, ' ||
	      'INT_OUTBOUND_FLAG, ' ||
              'OUT_INBOUND_FLAG, ' ||
              'OUT_OUTBOUND_FLAG, '||
              'CREATED_BY, ' ||
              'CREATION_DATE, ' ||
              'LAST_UPDATED_BY, ' ||
              'LAST_UPDATE_DATE, ' ||
              'LAST_UPDATE_LOGIN ) ' ||
          'select  ' ||
 	      ':v_dest_plan_id, ' ||
	      'FACILITY_ID, ' ||
              'INT_INBOUND_FLAG, ' ||
	      'INT_OUTBOUND_FLAG, ' ||
              'OUT_INBOUND_FLAG, ' ||
              'OUT_OUTBOUND_FLAG, ' ||
              ':v_user_id, ' ||
              ':v_sysdate, ' ||
              ':v_user_id, ' ||
              ':v_sysdate, ' ||
              ':v_login_id ' ||
  'from  MST_PLAN_FACILITIES ' ||
  'where plan_id = :p_source_plan_id';

Line: 224

              ' INSERT INTO MST_PLAN_CONSTRAINT_RULES(' ||
 	      'plan_id, '  ||
              'CONSTRAINT_CODE, '  ||
              'TYPE, '  ||
	      'PENALTY_FUNCTION_TYPE, '  ||
              'CREATED_BY, '  ||
              'CREATION_DATE, '  ||
              'LAST_UPDATED_BY, '  ||
              'LAST_UPDATE_DATE, '  ||
              'last_update_login) '  ||
  'select   '  ||
 	      ':v_dest_plan_id, '  ||
              'CONSTRAINT_CODE, '  ||
              'TYPE, '  ||
	      'PENALTY_FUNCTION_TYPE, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_login_id '  ||
  'from mst_plan_constraint_rules '  ||
  'where plan_id = :p_source_plan_id';

Line: 253

              'INSERT INTO MST_PLAN_PENALTY_BREAKS( '  ||
              'plan_id, '  ||
              'CONSTRAINT_CODE, '  ||
              'LOW_RANGE, '  ||
              'HIGH_RANGE, '  ||
              'PENALTY_VALUE, '  ||
              'PENALTY_RATE, '  ||
              'CREATED_BY, '  ||
              'CREATION_DATE, '  ||
              'LAST_UPDATED_BY, '  ||
              'LAST_UPDATE_DATE, '  ||
              'LAST_UPDATE_LOGIN ) '  ||
  'select   '  ||
              ':v_dest_plan_id, '  ||
              'CONSTRAINT_CODE, '   ||
              'LOW_RANGE, '  ||
              'HIGH_RANGE, '  ||
              'PENALTY_VALUE, '  ||
              'PENALTY_RATE, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_login_id '  ||
  'from mst_plan_penalty_breaks ' ||
  'where plan_id = :p_source_plan_id ';

Line: 309

              'INSERT INTO MST_PLAN_FACILITIES(' ||
 	      'plan_id, ' ||
	      'FACILITY_ID, ' ||
              'INT_INBOUND_FLAG, ' ||
	      'INT_OUTBOUND_FLAG, ' ||
              'OUT_INBOUND_FLAG, ' ||
              'OUT_OUTBOUND_FLAG, '||
              'CREATED_BY, ' ||
              'CREATION_DATE, ' ||
              'LAST_UPDATED_BY, ' ||
              'LAST_UPDATE_DATE, ' ||
              'LAST_UPDATE_LOGIN ) ' ||
          'select  ' ||
 	      ':v_plan_id, ' ||
	      'FACILITY_ID, ' ||
              'INT_INBOUND_FLAG, ' ||
	      'INT_OUTBOUND_FLAG, ' ||
              'OUT_INBOUND_FLAG, ' ||
              'OUT_OUTBOUND_FLAG, ' ||
              ':v_user_id, ' ||
              ':v_sysdate, ' ||
              ':v_user_id, ' ||
              ':v_sysdate, ' ||
              ':v_login_id ' ||
  'from  MST_PLAN_FACILITIES ' ||
  'where plan_id = -1 and created_by = :p_created_by';

Line: 341

              ' INSERT INTO MST_PLAN_CONSTRAINT_RULES(' ||
 	      'plan_id, '  ||
              'CONSTRAINT_CODE, '  ||
              'TYPE, '  ||
	      'PENALTY_FUNCTION_TYPE, '  ||
              'CREATED_BY, '  ||
              'CREATION_DATE, '  ||
              'LAST_UPDATED_BY, '  ||
              'LAST_UPDATE_DATE, '  ||
              'last_update_login) '  ||
  'select   '  ||
 	      ':v_dest_plan_id, '  ||
              'CONSTRAINT_CODE, '  ||
              'TYPE, '  ||
	      'PENALTY_FUNCTION_TYPE, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_login_id '  ||
  'from mst_plan_constraint_rules '  ||
  'where plan_id = -1 and created_by = :p_created_by';

Line: 370

              'INSERT INTO MST_PLAN_PENALTY_BREAKS( '  ||
              'plan_id, '  ||
              'CONSTRAINT_CODE, '  ||
              'LOW_RANGE, '  ||
              'HIGH_RANGE, '  ||
              'PENALTY_VALUE, '  ||
              'PENALTY_RATE, '  ||
              'CREATED_BY, '  ||
              'CREATION_DATE, '  ||
              'LAST_UPDATED_BY, '  ||
              'LAST_UPDATE_DATE, '  ||
              'LAST_UPDATE_LOGIN ) '  ||
  'select   '  ||
              ':v_dest_plan_id, '  ||
              'CONSTRAINT_CODE, '   ||
              'LOW_RANGE, '  ||
              'HIGH_RANGE, '  ||
              'PENALTY_VALUE, '  ||
              'PENALTY_RATE, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_user_id, '  ||
              ':v_sysdate, '  ||
              ':v_login_id '  ||
  'from mst_plan_penalty_breaks ' ||
  'where plan_id = -1 and created_by = :p_created_by';