eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_BOM_ODS_LOAD SQL Statements

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

Line: 25


  SELECT
     mrs.ORGANIZATION_ID,
     --mrs.DEPARTMENT_ID,
     mrs.RESOURCE_ID,
     mrs.SR_INSTANCE_ID,
     mrs.setup_id,
     mrs.setup_code,
     mrs.setup_Description
 FROM MSC_ST_RESOURCE_SETUPS mrs
 WHERE mrs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
 ORDER BY mrs.DELETED_FLAG;

Line: 45


       MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 48


    MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_RESOURCE_SETUPS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 56


       INSERT INTO MSC_RESOURCE_SETUPS
	( PLAN_ID,
  	RESOURCE_ID,
 	ORGANIZATION_ID  ,
 	--DEPARTMENT_ID  ,
        SR_INSTANCE_ID,
 	SETUP_ID,
	SETUP_CODE,
	SETUP_DESCRIPTION,
  	REFRESH_NUMBER,
  	LAST_UPDATE_DATE,
  	LAST_UPDATED_BY,
  	CREATION_DATE,
  	CREATED_BY)
      VALUES
	( -1,
  	c_rec.RESOURCE_ID,
  	c_rec.ORGANIZATION_ID  ,
  	--c_rec.DEPARTMENT_ID  ,
  	c_rec.SR_INSTANCE_ID  ,
  	c_rec. SETUP_ID,
  	c_rec.SETUP_CODE,
  	c_rec.SETUP_DESCRIPTION,
  	MSC_CL_COLLECTION.v_last_collection_id,
  	MSC_CL_COLLECTION.v_current_date,
  	MSC_CL_COLLECTION.v_current_user,
  	MSC_CL_COLLECTION.v_current_date,
  	MSC_CL_COLLECTION.v_current_user );

Line: 149


  SELECT
     mrs.ORGANIZATION_ID,
     mrs.RESOURCE_ID,
     mrs.SR_INSTANCE_ID,
     mrs.from_setup_id,
     mrs.to_setup_id,
     mrs.standard_operation_id,
     mrs.transition_time,
     mrs.transition_uom,
     mrs.transition_penalty
 FROM MSC_ST_SETUP_TRANSITIONS mrs
 WHERE mrs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 170


       MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 173


    MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 181


       INSERT INTO MSC_SETUP_TRANSITIONS
        ( PLAN_ID,
        RESOURCE_ID,
        ORGANIZATION_ID  ,
	SR_INSTANCE_ID,
        FROM_SETUP_ID,
        TO_SETUP_ID,
        STANDARD_OPERATION_ID,
        TRANSITION_TIME,
	TRANSITION_UOM,
	TRANSITION_PENALTY,
        REFRESH_NUMBER,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY)
      VALUES
        ( -1,
        c_rec.RESOURCE_ID,
        c_rec.ORGANIZATION_ID  ,
        c_rec.SR_INSTANCE_ID  ,
        c_rec.FROM_SETUP_ID,
        c_rec.TO_SETUP_ID,
        c_rec.STANDARD_OPERATION_ID,
        c_rec.TRANSITION_TIME,
        c_rec.TRANSITION_UOM,
        c_rec.TRANSITION_PENALTY,
        MSC_CL_COLLECTION.v_last_collection_id,
        MSC_CL_COLLECTION.v_current_date,
        MSC_CL_COLLECTION.v_current_user,
        MSC_CL_COLLECTION.v_current_date,
        MSC_CL_COLLECTION.v_current_user );

Line: 312


'SELECT'
||'    mrr.TRANSACTION_ID,'
||'    mrc.SR_INSTANCE_ID,'
||'    mrc.CHARGE_NUMBER,'
||'    mrc.CHARGE_QUANTITY,'
||'    mrc.CHARGE_START_DATETIME,'
||'    mrc.CHARGE_END_DATETIME,'
||'    mrc.DEPARTMENT_ID'
||' FROM '||lv_res_req_tbl||' mrr,'
||'      MSC_ST_RESOURCE_CHARGES mrc'
||' WHERE mrr.SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id
||'  AND mrr.PLAN_ID	     = -1'
||'  AND mrr.SR_INSTANCE_ID  = mrc.SR_INSTANCE_ID'
||'  AND mrr.WIP_ENTITY_ID   = mrc.WIP_ENTITY_ID'
||'  AND mrr.ORGANIZATION_ID = mrc.ORGANIZATION_ID'
||'  AND mrr.RESOURCE_ID     = mrc.RESOURCE_ID'
||'  AND mrr.OPERATION_SEQ_NUM = mrc.OPERATION_SEQ_NUM'
||'  AND mrr.RESOURCE_SEQ_NUM = mrc.RESOURCE_SEQ_NUM';

Line: 334


'insert into '||lv_tbl
||'  ( PLAN_ID,'
||'    RES_TRANSACTION_ID,'
||'    SR_INSTANCE_ID,'
||'    CHARGE_NUMBER,'
||'    CHARGE_QUANTITY,'
||'    CHARGE_START_DATETIME,'
||'    CHARGE_END_DATETIME,'
||'    LAST_UPDATE_DATE,'
||'    LAST_UPDATED_BY,'
||'    CREATION_DATE,'
||'    CREATED_BY)'
||'VALUES'
||'(   -1,'
||'    :TRANSACTION_ID,'
||'    :SR_INSTANCE_ID,'
||'    :CHARGE_NUMBER,'
||'    :CHARGE_QUANTITY,'
||'    :CHARGE_START_DATETIME,'
||'    :CHARGE_END_DATETIME,'
||'    :v_current_date,'
||'    :v_current_user,'
||'    :v_current_date,'
||'    :v_current_user)';

Line: 458


 SELECT
   msric.DEPARTMENT_ID,
   msric.RESOURCE_ID,
   msric.RES_INSTANCE_ID,
   --msric.EQUIPMENT_ITEM_ID,
   msric.SERIAL_NUMBER,
   msric.SHIFT_NUM,
   msric.FROM_DATE,
   msric.TO_DATE,
   msric.FROM_TIME,
   msric.TO_TIME,
   msric.CAPACITY_CHANGE,
   msric.SIMULATION_SET,
   msric.ACTION_TYPE,
   msric.DELETED_FLAG,
   msric.SR_INSTANCE_ID
 FROM MSC_ST_RES_INSTANCE_CHANGES msric
 WHERE msric.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
 ORDER BY
      msric.DELETED_FLAG;

Line: 493


	MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RES_INSTANCE_CHANGES', MSC_CL_COLLECTION.v_instance_id, NULL);

Line: 505


       IF MSC_CL_COLLECTION.v_is_incremental_refresh AND c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN

            DELETE MSC_RES_INSTANCE_CHANGES
       	    WHERE DEPARTMENT_ID   = c_rec.DEPARTMENT_ID
         	AND RESOURCE_ID       = c_rec.RESOURCE_ID
         	AND RES_INSTANCE_ID   = c_rec.RES_INSTANCE_ID
         	AND SERIAL_NUMBER     = c_rec.SERIAL_NUMBER
         	--AND EQUIPMENT_ITEM_ID = c_rec.EQUIPMENT_ITEM_ID
       	        AND SHIFT_NUM= c_rec.SHIFT_NUM
         	AND FROM_DATE= c_rec.FROM_DATE
         	AND NVL(TO_DATE,MSC_UTIL.NULL_DATE)= NVL(c_rec.TO_DATE,MSC_UTIL.NULL_DATE)
       	        AND NVL(FROM_TIME,MSC_UTIL.NULL_VALUE)= NVL(c_rec.FROM_TIME,MSC_UTIL.NULL_VALUE)
         	AND NVL(TO_TIME,MSC_UTIL.NULL_VALUE)= NVL(c_rec.TO_TIME,MSC_UTIL.NULL_VALUE)
         	AND SIMULATION_SET= c_rec.SIMULATION_SET
         	AND ACTION_TYPE= c_rec.ACTION_TYPE
         	AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 523


	  INSERT INTO MSC_RES_INSTANCE_CHANGES
	   ( DEPARTMENT_ID,
  	     RESOURCE_ID,
	     RES_INSTANCE_ID,
	     SERIAL_NUMBER,
	    -- EQUIPMENT_ITEM_ID,
  	     SHIFT_NUM,
  	     FROM_DATE,
  	     TO_DATE,
  	     FROM_TIME,
  	     TO_TIME,
  	     CAPACITY_CHANGE,
  	     SIMULATION_SET,
  	     ACTION_TYPE,
  	     SR_INSTANCE_ID,
  	     REFRESH_NUMBER,
    	     LAST_UPDATE_DATE,
  	     LAST_UPDATED_BY,
  	     CREATION_DATE,
  	     CREATED_BY)
	VALUES
	   ( c_rec.DEPARTMENT_ID,
            c_rec.RESOURCE_ID,
            c_rec.RES_INSTANCE_ID,
            c_rec.SERIAL_NUMBER,
            --c_rec.EQUIPMENT_ITEM_ID,
            c_rec.SHIFT_NUM,
            c_rec.FROM_DATE,
            c_rec.TO_DATE,
            c_rec.FROM_TIME,
            c_rec.TO_TIME,
            c_rec.CAPACITY_CHANGE,
            c_rec.SIMULATION_SET,
            c_rec.ACTION_TYPE,
            c_rec.SR_INSTANCE_ID,
            MSC_CL_COLLECTION.v_last_collection_id,
            MSC_CL_COLLECTION.v_current_date,
            MSC_CL_COLLECTION.v_current_user,
            MSC_CL_COLLECTION.v_current_date,
            MSC_CL_COLLECTION.v_current_user );

Line: 653


SELECT
  mscs.Bill_Sequence_ID,
  mscs.USAGE_QUANTITY,
  mscs.PRIORITY,
  mscs.ROUNDING_DIRECTION,
  mscs.ORGANIZATION_ID,
  t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID,   -- mscs.SUBSTITUTE_ITEM_ID,
  mscs.COMPONENT_SEQUENCE_ID,
  mscs.SR_INSTANCE_ID
FROM MSC_ITEM_ID_LID t1,
     MSC_ST_COMPONENT_SUBSTITUTES  mscs
WHERE t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id
  AND t1.sr_instance_id= mscs.sr_instance_id
  AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND mscs.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line: 670


SELECT
  mscs.BILL_SEQUENCE_ID,
  mscs.COMPONENT_SEQUENCE_ID,
  t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID,   -- mscs.SUBSTITUTE_ITEM_ID,
  mscs.SR_INSTANCE_ID
FROM MSC_ITEM_ID_LID t1,
     MSC_ST_COMPONENT_SUBSTITUTES mscs
WHERE ((t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id) AND (mscs.substitute_item_id
is NOT NULL))
  AND t1.sr_instance_id= mscs.sr_instance_id
  AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND mscs.DELETED_FLAG= MSC_UTIL.SYS_YES
UNION ALL
SELECT
  mscs.BILL_SEQUENCE_ID,
  mscs.COMPONENT_SEQUENCE_ID,
  TO_NUMBER(NULL) SUBSTITUTE_ITEM_ID,
  mscs.SR_INSTANCE_ID
FROM MSC_ST_COMPONENT_SUBSTITUTES mscs
WHERE mscs.substitute_item_id IS NULL
AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND mscs.DELETED_FLAG= MSC_UTIL.SYS_YES;

Line: 706


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 709


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 722


UPDATE MSC_COMPONENT_SUBSTITUTES
   SET USAGE_QUANTITY= 0,
       REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
       LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
       LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
 WHERE PLAN_ID= -1
   AND BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID
   AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 733


UPDATE MSC_COMPONENT_SUBSTITUTES
   SET USAGE_QUANTITY= 0,
       REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
       LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
       LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
 WHERE PLAN_ID= -1
 AND COMPONENT_SEQUENCE_ID= c_rec.COMPONENT_SEQUENCE_ID
 AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 745


UPDATE MSC_COMPONENT_SUBSTITUTES
   SET USAGE_QUANTITY= 0,
       REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
       LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
       LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
 WHERE PLAN_ID= -1
 AND COMPONENT_SEQUENCE_ID= c_rec.COMPONENT_SEQUENCE_ID
 AND SUBSTITUTE_ITEM_ID= c_rec.SUBSTITUTE_ITEM_ID
 AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 771


UPDATE MSC_COMPONENT_SUBSTITUTES
SET
 USAGE_QUANTITY= c_rec.USAGE_QUANTITY,
 PRIORITY= c_rec.PRIORITY,
 ROUNDING_DIRECTION= c_rec.ROUNDING_DIRECTION,
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
WHERE PLAN_ID= -1
  AND BILL_SEQUENCE_ID= c_rec.Bill_Sequence_ID
  AND COMPONENT_SEQUENCE_ID= c_rec.COMPONENT_SEQUENCE_ID
  AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
  AND SUBSTITUTE_ITEM_ID= c_rec.SUBSTITUTE_ITEM_ID
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 791


INSERT INTO MSC_COMPONENT_SUBSTITUTES
( PLAN_ID,
  BILL_SEQUENCE_ID,
  USAGE_QUANTITY,
  PRIORITY,
  ROUNDING_DIRECTION,
  ORGANIZATION_ID,
  SUBSTITUTE_ITEM_ID,
  COMPONENT_SEQUENCE_ID,
  SR_INSTANCE_ID,
  REFRESH_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( -1,
  c_rec.Bill_Sequence_ID,
  c_rec.USAGE_QUANTITY,
  c_rec.PRIORITY,
  c_rec.ROUNDING_DIRECTION,
  c_rec.ORGANIZATION_ID,
  c_rec.SUBSTITUTE_ITEM_ID,
  c_rec.COMPONENT_SEQUENCE_ID,
  c_rec.SR_INSTANCE_ID,
  MSC_CL_COLLECTION.v_last_collection_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );

Line: 878


SELECT
  msb.BILL_OF_RESOURCES,
  msb.ORGANIZATION_ID,
  msb.DESCRIPTION,
  msb.DISABLE_DATE,
  msb.ROLLUP_START_DATE,
  msb.ROLLUP_COMPLETION_DATE,
  msb.SR_INSTANCE_ID
FROM MSC_ST_BILL_OF_RESOURCES msb
WHERE msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 890


SELECT
  msbr.BILL_OF_RESOURCES,
  msbr.RESOURCE_DEPARTMENT_HOURS,
  msbr.OPERATION_SEQUENCE_ID,
  msbr.OPERATION_SEQ_NUM,
  msbr.RESOURCE_SEQ_NUM,
  msbr.SETBACK_DAYS,
  msbr.ASSEMBLY_USAGE,
  msbr.ORIGINATION_TYPE,
  msbr.RESOURCE_UNITS,
  msbr.BASIS,
  msbr.RESOURCE_ID,
  msbr.DEPARTMENT_ID,
  msbr.ORGANIZATION_ID,
  msbr.SR_TRANSACTION_ID,
  t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,
  t2.INVENTORY_ITEM_ID SOURCE_ITEM_ID,
  msbr.SR_INSTANCE_ID
FROM MSC_ITEM_ID_LID t1,
     MSC_ITEM_ID_LID t2,
     MSC_ST_BOR_REQUIREMENTS msbr
WHERE t1.SR_INVENTORY_ITEM_ID=        msbr.assembly_item_id
  AND t1.sr_instance_id= msbr.sr_instance_id
  AND t2.SR_INVENTORY_ITEM_ID=        msbr.source_item_id
  AND t2.sr_instance_id= msbr.sr_instance_id
  AND msbr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 927


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 928


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 931


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 932


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 945


UPDATE MSC_BILL_OF_RESOURCES
SET
 DESCRIPTION= c_rec.DESCRIPTION,
 DISABLE_DATE= c_rec.DISABLE_DATE,
 ROLLUP_START_DATE= c_rec.ROLLUP_START_DATE,
 ROLLUP_COMPLETION_DATE= c_rec.ROLLUP_COMPLETION_DATE,
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
WHERE PLAN_ID= -1
  AND BILL_OF_RESOURCES= c_rec.BILL_OF_RESOURCES
  AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 964


INSERT INTO MSC_BILL_OF_RESOURCES
( PLAN_ID,
  BILL_OF_RESOURCES,
  ORGANIZATION_ID,
  DESCRIPTION,
  DISABLE_DATE,
  ROLLUP_START_DATE,
  ROLLUP_COMPLETION_DATE,
  SR_INSTANCE_ID,
  REFRESH_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( -1,
  c_rec.BILL_OF_RESOURCES,
  c_rec.ORGANIZATION_ID,
  c_rec.DESCRIPTION,
  c_rec.DISABLE_DATE,
  c_rec.ROLLUP_START_DATE,
  c_rec.ROLLUP_COMPLETION_DATE,
  c_rec.SR_INSTANCE_ID,
  MSC_CL_COLLECTION.v_last_collection_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );

Line: 1054


UPDATE MSC_BOR_REQUIREMENTS
SET
 BILL_OF_RESOURCES= c_rec.BILL_OF_RESOURCES,
 RESOURCE_DEPARTMENT_HOURS= c_rec.RESOURCE_DEPARTMENT_HOURS,
 OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID,
 OPERATION_SEQ_NUM= c_rec.OPERATION_SEQ_NUM,
 RESOURCE_SEQ_NUM= c_rec.RESOURCE_SEQ_NUM,
 SETBACK_DAYS= c_rec.SETBACK_DAYS,
 ASSEMBLY_USAGE= c_rec.ASSEMBLY_USAGE,
 ORIGINATION_TYPE= c_rec.ORIGINATION_TYPE,
 RESOURCE_UNITS= c_rec.RESOURCE_UNITS,
 BASIS= c_rec.BASIS,
 RESOURCE_ID= c_rec.RESOURCE_ID,
 DEPARTMENT_ID= c_rec.DEPARTMENT_ID,
 ORGANIZATION_ID= c_rec.ORGANIZATION_ID,
 ASSEMBLY_ITEM_ID= c_rec.ASSEMBLY_ITEM_ID,
 SOURCE_ITEM_ID= c_rec.SOURCE_ITEM_ID,
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
WHERE PLAN_ID= -1
  AND SR_TRANSACTION_ID= c_rec.SR_TRANSACTION_ID
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 1083


INSERT INTO MSC_BOR_REQUIREMENTS
( PLAN_ID,
  TRANSACTION_ID,
  SR_TRANSACTION_ID,
  BILL_OF_RESOURCES,
  RESOURCE_DEPARTMENT_HOURS,
  OPERATION_SEQUENCE_ID,
  OPERATION_SEQ_NUM,
  RESOURCE_SEQ_NUM,
  SETBACK_DAYS,
  ASSEMBLY_USAGE,
  ORIGINATION_TYPE,
  RESOURCE_UNITS,
  BASIS,
  RESOURCE_ID,
  DEPARTMENT_ID,
  ORGANIZATION_ID,
  ASSEMBLY_ITEM_ID,
  SOURCE_ITEM_ID,
  SR_INSTANCE_ID,
  REFRESH_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( -1,
  MSC_BOR_REQUIREMENTS_S.NEXTVAL,
  c_rec.SR_TRANSACTION_ID,
  c_rec.BILL_OF_RESOURCES,
  c_rec.RESOURCE_DEPARTMENT_HOURS,
  c_rec.OPERATION_SEQUENCE_ID,
  c_rec.OPERATION_SEQ_NUM,
  c_rec.RESOURCE_SEQ_NUM,
  c_rec.SETBACK_DAYS,
  c_rec.ASSEMBLY_USAGE,
  c_rec.ORIGINATION_TYPE,
  c_rec.RESOURCE_UNITS,
  c_rec.BASIS,
  c_rec.RESOURCE_ID,
  c_rec.DEPARTMENT_ID,
  c_rec.ORGANIZATION_ID,
  c_rec.ASSEMBLY_ITEM_ID,
  c_rec.SOURCE_ITEM_ID,
  c_rec.SR_INSTANCE_ID,
  MSC_CL_COLLECTION.v_last_collection_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );

Line: 1196


SELECT
  miil.INVENTORY_ITEM_ID,           -- msor.ITEM_ID,
  msor.ORGANIZATION_ID,
  msor.EFFECTIVITY_DATE,
  msor.DISABLE_DATE,
  msor.MINIMUM_QUANTITY,
  msor.MAXIMUM_QUANTITY,
  msor.PREFERENCE,
  msor.ROUTING_SEQUENCE_ID,
  msor.BILL_SEQUENCE_ID,
  msor.TOTAL_PRODUCT_CYCLE_TIME,
  msor.LINE_ID,
  msor.PRIMARY_LINE_FLAG,
  msor.PRODUCTION_LINE_RATE,
  msor.LOAD_DISTRIBUTION_PRIORITY,
  msor.ITEM_PROCESS_COST,
  msor.SR_INSTANCE_ID,
  msor.RECIPE
FROM MSC_ITEM_ID_LID miil,
     MSC_ST_PROCESS_EFFECTIVITY msor
WHERE miil.SR_INVENTORY_ITEM_ID= msor.ITEM_ID
  AND miil.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msor.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line: 1222


SELECT
  miil.INVENTORY_ITEM_ID,           -- msor.ITEM_ID,
  msor.ORGANIZATION_ID,
  msor.ROUTING_SEQUENCE_ID,
  msor.BILL_SEQUENCE_ID,
  msor.LINE_ID,
  msor.SR_INSTANCE_ID
FROM MSC_ITEM_ID_LID miil,
     MSC_ST_PROCESS_EFFECTIVITY msor
WHERE miil.SR_INVENTORY_ITEM_ID(+)= msor.ITEM_ID
  AND miil.SR_INSTANCE_ID(+)= MSC_CL_COLLECTION.v_instance_id
  AND msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msor.DELETED_FLAG= MSC_UTIL.SYS_YES
UNION ALL
SELECT
  TO_NUMBER(NULL),
  TO_NUMBER(NULL),
  mpe.ROUTING_SEQUENCE_ID,
  mpe.BILL_SEQUENCE_ID,
  TO_NUMBER(NULL),
  mpe.SR_INSTANCE_ID
FROM MSC_PROCESS_EFFECTIVITY mpe,
     MSC_ST_PROCESS_EFFECTIVITY mspe
WHERE mspe.Bill_Sequence_ID= mpe.Bill_Sequence_ID
  AND mspe.Routing_Sequence_ID <> mpe.Routing_Sequence_ID
  AND mspe.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND mpe.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND mspe.DELETED_FLAG= MSC_UTIL.SYS_NO
  AND mpe.PLAN_ID= -1;

Line: 1253


SELECT
  msr.ROUTING_SEQUENCE_ID,
  msr.BILL_SEQUENCE_ID
FROM MSC_ST_ROUTINGS msr
WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
UNION ALL
SELECT
  TO_NUMBER(NULL),
  msb.BILL_SEQUENCE_ID
FROM MSC_ST_BOMS msb
WHERE msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 1278


     DELETE MSC_PROCESS_EFFECTIVITY
       WHERE PLAN_ID= -1
        AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
        AND (  ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
               OR BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID );

Line: 1293


lv_sql_stmt1 := '  DELETE MSC_PROCESS_EFFECTIVITY '
		||'     WHERE PLAN_ID= -1 '
		||'     AND SR_INSTANCE_ID= :SR_INSTANCE_ID ';

Line: 1355


    DELETE MSC_PROCESS_EFFECTIVITY
     WHERE PLAN_ID= -1
       AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
       AND (  ( ITEM_ID= c_rec.INVENTORY_ITEM_ID
                AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
                AND LINE_ID= c_rec.LINE_ID)
              OR ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
              OR BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID );

Line: 1378


UPDATE MSC_PROCESS_EFFECTIVITY
SET
 MINIMUM_QUANTITY= c_rec.MINIMUM_QUANTITY,
 MAXIMUM_QUANTITY= c_rec.MAXIMUM_QUANTITY,
 PREFERENCE= c_rec.PREFERENCE,
 TOTAL_PRODUCT_CYCLE_TIME= c_rec.TOTAL_PRODUCT_CYCLE_TIME,
 PRIMARY_LINE_FLAG= c_rec.PRIMARY_LINE_FLAG,
 PRODUCTION_LINE_RATE= c_rec.PRODUCTION_LINE_RATE,
 LOAD_DISTRIBUTION_PRIORITY= c_rec.LOAD_DISTRIBUTION_PRIORITY,
 ITEM_PROCESS_COST= c_rec.ITEM_PROCESS_COST,
 EFFECTIVITY_DATE= c_rec.EFFECTIVITY_DATE,
 DISABLE_DATE= c_rec.DISABLE_DATE,
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
 RECIPE = c_rec.RECIPE
WHERE PLAN_ID= -1
  AND ITEM_ID= c_rec.INVENTORY_ITEM_ID
  AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID
  AND ( ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID
        OR ( ROUTING_SEQUENCE_ID IS NULL
             AND c_rec.ROUTING_SEQUENCE_ID IS NULL))
  AND ( BILL_SEQUENCE_ID = c_rec.BILL_SEQUENCE_ID
        OR ( BILL_SEQUENCE_ID IS NULL
             AND c_rec.BILL_SEQUENCE_ID IS NULL))
  AND ( LINE_ID = c_rec.LINE_ID
        OR ( LINE_ID IS NULL
             AND c_rec.LINE_ID IS NULL));

Line: 1410


INSERT INTO MSC_PROCESS_EFFECTIVITY
( PLAN_ID,
  PROCESS_SEQUENCE_ID,
  ITEM_ID,
  ORGANIZATION_ID,
  EFFECTIVITY_DATE,
  DISABLE_DATE,
  MINIMUM_QUANTITY,
  MAXIMUM_QUANTITY,
  PREFERENCE,
  ROUTING_SEQUENCE_ID,
  BILL_SEQUENCE_ID,
  TOTAL_PRODUCT_CYCLE_TIME,
  LINE_ID,
  PRIMARY_LINE_FLAG,
  PRODUCTION_LINE_RATE,
  LOAD_DISTRIBUTION_PRIORITY,
  ITEM_PROCESS_COST,
  RECIPE,
  SR_INSTANCE_ID,
  REFRESH_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( -1,
  MSC_PROCESS_EFFECTIVITY_S.NEXTVAL,
  c_rec.INVENTORY_ITEM_ID,
  c_rec.ORGANIZATION_ID,
  c_rec.EFFECTIVITY_DATE,
  c_rec.DISABLE_DATE,
  c_rec.MINIMUM_QUANTITY,
  c_rec.MAXIMUM_QUANTITY,
  c_rec.PREFERENCE,
  c_rec.ROUTING_SEQUENCE_ID,
  c_rec.BILL_SEQUENCE_ID,
  c_rec.TOTAL_PRODUCT_CYCLE_TIME,
  c_rec.LINE_ID,
  c_rec.PRIMARY_LINE_FLAG,
  c_rec.PRODUCTION_LINE_RATE,
  c_rec.LOAD_DISTRIBUTION_PRIORITY,
  c_rec.ITEM_PROCESS_COST,
  c_rec.RECIPE,
  c_rec.SR_INSTANCE_ID,
  MSC_CL_COLLECTION.v_last_collection_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );

Line: 1522


/* if it's complete refresh, delete the old records after the insert/update */
IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
         -- We want to delete all BOM related data and get new stuff.

    /*   DELETE MSC_PROCESS_EFFECTIVITY
       WHERE PLAN_ID= -1
       AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
       AND REFRESH_NUMBER <> MSC_CL_COLLECTION.v_last_collection_id; */

Line: 1533


        MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 1537


       MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PROCESS_EFFECTIVITY', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 1552


SELECT
  msb.ASSEMBLY_TYPE,
  msb.ALTERNATE_BOM_DESIGNATOR,
  msb.SPECIFIC_ASSEMBLY_COMMENT,
  msb.PENDING_FROM_ECN,
  msb.SCALING_TYPE,
  msb.ASSEMBLY_QUANTITY,
  msb.UOM,
  msb.ORGANIZATION_ID,
  t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,        -- msb.ASSEMBLY_ITEM_ID,
  msb.BILL_SEQUENCE_ID,
  msb.SR_INSTANCE_ID,
  msb.operation_seq_num  /* ds change for opm: yielding op seq num */
FROM MSC_ITEM_ID_LID t1,
     MSC_ST_BOMS msb
WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id
  AND t1.sr_instance_id= msb.sr_instance_id
  AND msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msb.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line: 1573


SELECT
  msb.BILL_SEQUENCE_ID,
  msb.SR_INSTANCE_ID
FROM MSC_ST_BOMS msb
WHERE msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msb.DELETED_FLAG= MSC_UTIL.SYS_YES;

Line: 1614


'INSERT INTO MSC_BOMS '
||'( PLAN_ID,'
||'  ASSEMBLY_TYPE,'
||'  ALTERNATE_BOM_DESIGNATOR,'
||'  SPECIFIC_ASSEMBLY_COMMENT,'
||'  PENDING_FROM_ECN,'
||'  SCALING_TYPE,'
||'  ASSEMBLY_QUANTITY,'
||'  UOM,'
||'  ORGANIZATION_ID,'
||'  ASSEMBLY_ITEM_ID,'
||'  BILL_SEQUENCE_ID,'
||'  SR_INSTANCE_ID,'
||'  yielding_op_seq_num,'
||'  REFRESH_NUMBER,'
||'  LAST_UPDATE_DATE,'
||'  LAST_UPDATED_BY,'
||'  CREATION_DATE,'
||'  CREATED_BY)'
||'VALUES'
||'( -1,'
||'  :ASSEMBLY_TYPE,'
||'  :ALTERNATE_BOM_DESIGNATOR,'
||'  :SPECIFIC_ASSEMBLY_COMMENT,'
||'  :PENDING_FROM_ECN,'
||'  :SCALING_TYPE,'
||'  :ASSEMBLY_QUANTITY,'
||'  :UOM,'
||'  :ORGANIZATION_ID,'
||'  :ASSEMBLY_ITEM_ID,'
||'  :BILL_SEQUENCE_ID,'
||'  :SR_INSTANCE_ID,'
||'  :operation_seq_num,'
||'  :v_last_collection_id,'
||'  :v_current_date,'
||'  :v_current_user,'
||'  :v_current_date,'
||'  :v_current_user )';

Line: 1656


          MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 1659


          MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOMS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 1664


'INSERT INTO MSC_BOMS '
||'( PLAN_ID,'
||'  ASSEMBLY_TYPE,'
||'  ALTERNATE_BOM_DESIGNATOR,'
||'  SPECIFIC_ASSEMBLY_COMMENT,'
||'  PENDING_FROM_ECN,'
||'  SCALING_TYPE,'
||'  ASSEMBLY_QUANTITY,'
||'  UOM,'
||'  ORGANIZATION_ID,'
||'  ASSEMBLY_ITEM_ID,'
||'  BILL_SEQUENCE_ID,'
||'  SR_INSTANCE_ID,'
||'  yielding_op_seq_num,'
||'  REFRESH_NUMBER,'
||'  LAST_UPDATE_DATE,'
||'  LAST_UPDATED_BY,'
||'  CREATION_DATE,'
||'  CREATED_BY)'
||'  SELECT '
||'  -1,'
||'  msb.ASSEMBLY_TYPE,'
||'  msb.ALTERNATE_BOM_DESIGNATOR,'
||'  msb.SPECIFIC_ASSEMBLY_COMMENT,'
||'  msb.PENDING_FROM_ECN,'
||'  msb.SCALING_TYPE,'
||'  msb.ASSEMBLY_QUANTITY,'
||'  msb.UOM,'
||'  msb.ORGANIZATION_ID,'
||'  t1.INVENTORY_ITEM_ID,'
||'  msb.BILL_SEQUENCE_ID,'
||'  msb.SR_INSTANCE_ID,'
||'  msb.operation_seq_num,'
||'  :v_last_collection_id,'
||'  :v_current_date,'
||'  :v_current_user,'
||'  :v_current_date,'
||'  :v_current_user '
||' FROM MSC_ITEM_ID_LID t1,'
||'      MSC_ST_BOMS msb '
||'   WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id'
||'     AND t1.sr_instance_id= msb.sr_instance_id'
||'     AND msb.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
||'    AND msb.DELETED_FLAG= '||MSC_UTIL.SYS_NO;

Line: 1752


      DELETE MSC_BOMS
        WHERE PLAN_ID= -1
           AND BILL_SEQUENCE_ID= c_rec.BILL_SEQUENCE_ID
           AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 1808


       UPDATE MSC_BOMS
       SET
 	ASSEMBLY_TYPE= lb_ASSEMBLY_TYPE(j),
 	ALTERNATE_BOM_DESIGNATOR= lb_ALTERNATE_BOM_DESIGNATOR(j),
 	SPECIFIC_ASSEMBLY_COMMENT= lb_SPECIFIC_ASSEMBLY_COMMENT(j),
 	PENDING_FROM_ECN= lb_PENDING_FROM_ECN(j),
 	SCALING_TYPE= lb_SCALING_TYPE(j),
 	ASSEMBLY_QUANTITY= lb_ASSEMBLY_QUANTITY(j),
 	UOM= lb_UOM(j),
 	ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
 	ASSEMBLY_ITEM_ID= lb_ASSEMBLY_ITEM_ID(j),
 	REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 	LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 	LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
       WHERE PLAN_ID= -1
  	 AND BILL_SEQUENCE_ID= lb_BILL_SEQUENCE_ID(j)
  	 AND SR_INSTANCE_ID= lb_SR_INSTANCE_ID(j);

Line: 1908


SELECT
  msbc.COMPONENT_SEQUENCE_ID,
  msbc.ORGANIZATION_ID,
  msbc.BILL_SEQUENCE_ID,
  msbc.OPERATION_SEQ_NUM,
  t1.INVENTORY_ITEM_ID,              -- msbc.INVENTORY_ITEM_ID
  t2.INVENTORY_ITEM_ID USING_ASSEMBLY_ID, -- msbc.USING_ASSEMBLY_ID
  msbc.COMPONENT_TYPE,
  msbc.SCALING_TYPE,
  msbc.CHANGE_NOTICE,
  msbc.REVISION,
  msbc.UOM_CODE,
  msbc.USAGE_QUANTITY,
  msbc.COMPONENT_YIELD_FACTOR,
  msbc.EFFECTIVITY_DATE,
  msbc.DISABLE_DATE,
  msbc.FROM_UNIT_NUMBER,
  msbc.TO_UNIT_NUMBER,
  msbc.USE_UP_CODE,
  msbc.SUGGESTED_EFFECTIVITY_DATE,
  t3.INVENTORY_ITEM_ID DRIVING_ITEM_ID, -- msbc.DRIVING_ITEM_ID,
  msbc.OPERATION_OFFSET_PERCENT,
  msbc.OPTIONAL_COMPONENT,
  msbc.OLD_EFFECTIVITY_DATE,
  msbc.WIP_SUPPLY_TYPE,
  msbc.PLANNING_FACTOR,
  msbc.ATP_FLAG,
  msbc.SR_INSTANCE_ID,
  msbc.scale_multiple,
  msbc.SCALE_ROUNDING_VARIANCE,
  msbc.ROUNDING_DIRECTION,
  msbc.PRIMARY_FLAG,
  msbc.CONTRIBUTE_TO_STEP_QTY,  /* ds change */
  msbc.OLD_COMPONENT_SEQUENCE_ID
FROM MSC_ITEM_ID_LID t1,
     MSC_ITEM_ID_LID t2,
     MSC_ITEM_ID_LID t3,
     MSC_ST_BOM_COMPONENTS msbc
WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
  AND t1.sr_instance_id= msbc.sr_instance_id
  AND t2.SR_INVENTORY_ITEM_ID= msbc.using_assembly_id
  AND t2.sr_instance_id= msbc.sr_instance_id
  AND t3.SR_INVENTORY_ITEM_ID(+)= msbc.driving_item_id
  AND t3.sr_instance_id(+)= msbc.sr_instance_id
  AND msbc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msbc.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line: 1956


SELECT
  msbc.COMPONENT_SEQUENCE_ID,
  msbc.BILL_SEQUENCE_ID,
  msbc.SR_INSTANCE_ID
FROM MSC_ST_BOM_COMPONENTS msbc
WHERE msbc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
  AND msbc.DELETED_FLAG= MSC_UTIL.SYS_YES;

Line: 2026


' insert into '||lv_tbl
||'( PLAN_ID,'
||'  COMPONENT_SEQUENCE_ID,'
||'  ORGANIZATION_ID,'
||'  BILL_SEQUENCE_ID,'
||'  OPERATION_SEQ_NUM,'
||'  INVENTORY_ITEM_ID,'
||'  USING_ASSEMBLY_ID,'
||'  COMPONENT_TYPE,'
||'  SCALING_TYPE,'
||'  CHANGE_NOTICE,'
||'  REVISION,'
||'  UOM_CODE,'
||'  USAGE_QUANTITY,'
||'  COMPONENT_YIELD_FACTOR,'
||'  EFFECTIVITY_DATE,'
||'  DISABLE_DATE,'
||'  FROM_UNIT_NUMBER,'
||'  TO_UNIT_NUMBER,'
||'  USE_UP_CODE,'
||'  SUGGESTED_EFFECTIVITY_DATE,'
||'  DRIVING_ITEM_ID,'
||'  OPERATION_OFFSET_PERCENT,'
||'  OPTIONAL_COMPONENT,'
||'  OLD_EFFECTIVITY_DATE,'
||'  WIP_SUPPLY_TYPE,'
||'  PLANNING_FACTOR,'
||'  ATP_FLAG,'
||'  SR_INSTANCE_ID,'
||'  SCALE_MULTIPLE,'
||'  SCALE_ROUNDING_VARIANCE,'
||'  ROUNDING_DIRECTION,'
||'  PRIMARY_FLAG,'
||'  CONTRIBUTE_TO_STEP_QTY,'
||'  OLD_COMPONENT_SEQUENCE_ID,'
||'  REFRESH_NUMBER,'
||'  LAST_UPDATE_DATE,'
||'  LAST_UPDATED_BY,'
||'  CREATION_DATE,'
||'  CREATED_BY)'
||'VALUES'
||'( -1,'
||'  :COMPONENT_SEQUENCE_ID,'
||'  :ORGANIZATION_ID,'
||'  :BILL_SEQUENCE_ID,'
||'  :OPERATION_SEQ_NUM,'
||'  :INVENTORY_ITEM_ID,'
||'  :USING_ASSEMBLY_ID,'
||'  :COMPONENT_TYPE,'
||'  :SCALING_TYPE,'
||'  :CHANGE_NOTICE,'
||'  :REVISION,'
||'  :UOM_CODE,'
||'  :USAGE_QUANTITY,'
||'  :COMPONENT_YIELD_FACTOR,'
||'  :EFFECTIVITY_DATE,'
||'  :DISABLE_DATE,'
||'  :FROM_UNIT_NUMBER,'
||'  :TO_UNIT_NUMBER,'
||'  :USE_UP_CODE,'
||'  :SUGGESTED_EFFECTIVITY_DATE,'
||'  :DRIVING_ITEM_ID,'
||'  :OPERATION_OFFSET_PERCENT,'
||'  :OPTIONAL_COMPONENT,'
||'  :OLD_EFFECTIVITY_DATE,'
||'  :WIP_SUPPLY_TYPE,'
||'  :PLANNING_FACTOR,'
||'  :ATP_FLAG,'
||'  :SR_INSTANCE_ID,'
||'  :SCALE_MULTIPLE,'
||'  :SCALE_ROUNDING_VARIANCE,'
||'  :ROUNDING_DIRECTION,'
||'  :PRIMARY_FLAG,'
||'  :CONTRIBUTE_TO_STEP_QTY,'
||'  :OLD_COMPONENT_SEQUENCE_ID,'
||'  :v_last_collection_id,'
||'  :v_current_date,'
||'  :v_current_user,'
||'  :v_current_date,'
||'  :v_current_user)';

Line: 2113


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 2116


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOM_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 2122


' INSERT /*+ append  */ '
|| ' INTO '||lv_tbl
||'( PLAN_ID,'
||'  COMPONENT_SEQUENCE_ID,'
||'  ORGANIZATION_ID,'
||'  BILL_SEQUENCE_ID,'
||'  OPERATION_SEQ_NUM,'
||'  INVENTORY_ITEM_ID,'
||'  USING_ASSEMBLY_ID,'
||'  COMPONENT_TYPE,'
||'  SCALING_TYPE,'
||'  CHANGE_NOTICE,'
||'  REVISION,'
||'  UOM_CODE,'
||'  USAGE_QUANTITY,'
||'  COMPONENT_YIELD_FACTOR,'
||'  EFFECTIVITY_DATE,'
||'  DISABLE_DATE,'
||'  FROM_UNIT_NUMBER,'
||'  TO_UNIT_NUMBER,'
||'  USE_UP_CODE,'
||'  SUGGESTED_EFFECTIVITY_DATE,'
||'  DRIVING_ITEM_ID,'
||'  OPERATION_OFFSET_PERCENT,'
||'  OPTIONAL_COMPONENT,'
||'  OLD_EFFECTIVITY_DATE,'
||'  WIP_SUPPLY_TYPE,'
||'  PLANNING_FACTOR,'
||'  ATP_FLAG,'
||'  SR_INSTANCE_ID,'
||'  SCALE_MULTIPLE,'
||'  SCALE_ROUNDING_VARIANCE,'
||'  ROUNDING_DIRECTION,'
||'  PRIMARY_FLAG,'
||'  CONTRIBUTE_TO_STEP_QTY,'
||'  OLD_COMPONENT_SEQUENCE_ID,'
||'  REFRESH_NUMBER,'
||'  LAST_UPDATE_DATE,'
||'  LAST_UPDATED_BY,'
||'  CREATION_DATE,'
||'  CREATED_BY)'
||'  SELECT '
||'  -1,'
||'  msbc.COMPONENT_SEQUENCE_ID,'
||'  msbc.ORGANIZATION_ID,'
||'  msbc.BILL_SEQUENCE_ID,'
||'  msbc.OPERATION_SEQ_NUM,'
||'  t1.INVENTORY_ITEM_ID, '
||'  t2.INVENTORY_ITEM_ID,'
||'  msbc.COMPONENT_TYPE,'
||'  msbc.SCALING_TYPE,'
||'  msbc.CHANGE_NOTICE,'
||'  msbc.REVISION,'
||'  msbc.UOM_CODE,'
||'  msbc.USAGE_QUANTITY,'
||'  msbc.COMPONENT_YIELD_FACTOR,'
||'  msbc.EFFECTIVITY_DATE,'
||'  msbc.DISABLE_DATE,'
||'  msbc.FROM_UNIT_NUMBER,'
||'  msbc.TO_UNIT_NUMBER,'
||'  msbc.USE_UP_CODE,'
||'  msbc.SUGGESTED_EFFECTIVITY_DATE,'
||'  t3.INVENTORY_ITEM_ID,'
||'  msbc.OPERATION_OFFSET_PERCENT,'
||'  msbc.OPTIONAL_COMPONENT,'
||'  msbc.OLD_EFFECTIVITY_DATE,'
||'  msbc.WIP_SUPPLY_TYPE,'
||'  msbc.PLANNING_FACTOR,'
||'  msbc.ATP_FLAG,'
||'  msbc.SR_INSTANCE_ID,'
||'  msbc.scale_multiple,'
||'  msbc.SCALE_ROUNDING_VARIANCE,'
||'  msbc.ROUNDING_DIRECTION,'
||'  msbc.PRIMARY_FLAG, '
||'  msbc.CONTRIBUTE_TO_STEP_QTY, '
||'  msbc.OLD_COMPONENT_SEQUENCE_ID,'
||'   :v_last_collection_id, '
||'   :v_current_date      , '
||'   :v_current_user      , '
||'   :v_current_date      , '
||'   :v_current_user        '
||' FROM MSC_ITEM_ID_LID t1,'
||'     MSC_ITEM_ID_LID t2,'
||'     MSC_ITEM_ID_LID t3,'
||'     MSC_ST_BOM_COMPONENTS msbc'
||' WHERE t1.SR_INVENTORY_ITEM_ID   = msbc.inventory_item_id'
||'  AND t1.sr_instance_id          = msbc.sr_instance_id'
||'  AND t2.SR_INVENTORY_ITEM_ID    = msbc.using_assembly_id'
||'  AND t2.sr_instance_id          = msbc.sr_instance_id'
||'  AND t3.SR_INVENTORY_ITEM_ID(+) = msbc.driving_item_id'
||'  AND t3.sr_instance_id(+)       = msbc.sr_instance_id'
||'  AND msbc.SR_INSTANCE_ID        = '||MSC_CL_COLLECTION.v_instance_id
||'  AND msbc.DELETED_FLAG          = '||MSC_UTIL.SYS_NO;

Line: 2261


	lv_sql_stmt1 := ' UPDATE MSC_BOM_COMPONENTS '
			||'   SET USAGE_QUANTITY= 0, '
			||'   REFRESH_NUMBER=   :v_last_collection_id , '
			||'   LAST_UPDATE_DATE= :v_current_date , '
			||'   LAST_UPDATED_BY=  :v_current_user '
			||' WHERE PLAN_ID= -1 '
			||'  AND SR_INSTANCE_ID= :SR_INSTANCE_ID ';

Line: 2286


		/*ELSE --condition should not arise. even if it does, we should not delete
			EXECUTE IMMEDIATE lv_sql_stmt1  USING MSC_CL_COLLECTION.v_last_collection_id, MSC_CL_COLLECTION.v_current_date, MSC_CL_COLLECTION.v_current_user, c_rec.SR_INSTANCE_ID; */

Line: 2302


UPDATE MSC_BOM_COMPONENTS
   SET USAGE_QUANTITY= 0,
       REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
       LAST_UPDATE_DATE= v_current_date,
       LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
 WHERE PLAN_ID= -1
   AND BILL_SEQUENCE_ID= NVL(c_rec.BILL_SEQUENCE_ID, BILL_SEQUENCE_ID)
   AND COMPONENT_SEQUENCE_ID= NVL(c_rec.COMPONENT_SEQUENCE_ID, COMPONENT_SEQUENCE_ID)
   AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 2386


UPDATE MSC_BOM_COMPONENTS
SET
 ORGANIZATION_ID= lb_ORGANIZATION_ID(j),
 INVENTORY_ITEM_ID= lb_INVENTORY_ITEM_ID(j),
 USING_ASSEMBLY_ID= lb_USING_ASSEMBLY_ID(j),
 OPERATION_SEQ_NUM = lb_OPERATION_SEQ_NUM(j),
 COMPONENT_TYPE= lb_COMPONENT_TYPE(j),
 SCALING_TYPE= lb_SCALING_TYPE(j),
 CHANGE_NOTICE= lb_CHANGE_NOTICE(j),
 REVISION= lb_REVISION(j),
 UOM_CODE= lb_UOM_CODE(j),
 USAGE_QUANTITY= lb_USAGE_QUANTITY(j),
 COMPONENT_YIELD_FACTOR= lb_COMPONENT_YIELD_FACTOR(j),
 EFFECTIVITY_DATE= lb_EFFECTIVITY_DATE(j),
 DISABLE_DATE= lb_DISABLE_DATE(j),
 FROM_UNIT_NUMBER= lb_FROM_UNIT_NUMBER(j),
 TO_UNIT_NUMBER= lb_TO_UNIT_NUMBER(j),
 USE_UP_CODE= lb_USE_UP_CODE(j),
 SUGGESTED_EFFECTIVITY_DATE= lb_SUGGESTED_EFFECTIVITY_DATE(j),
 DRIVING_ITEM_ID= lb_DRIVING_ITEM_ID(j),
 OPERATION_OFFSET_PERCENT= lb_OPERATION_OFFSET_PERCENT(j),
 OPTIONAL_COMPONENT= lb_OPTIONAL_COMPONENT(j),
 OLD_EFFECTIVITY_DATE= lb_OLD_EFFECTIVITY_DATE(j),
 WIP_SUPPLY_TYPE= lb_WIP_SUPPLY_TYPE(j),
 PLANNING_FACTOR= lb_PLANNING_FACTOR(j),
 ATP_FLAG= lb_ATP_FLAG(j),
 SCALE_MULTIPLE  = lb_scale_multiple(j),
 SCALE_ROUNDING_VARIANCE     = lb_SCALE_ROUNDING_VARIANCE(j),
 ROUNDING_DIRECTION   = lb_ROUNDING_DIRECTION(j),
 PRIMARY_FLAG   = lb_PRIMARY_FLAG(j),
 CONTRIBUTE_TO_STEP_QTY   = lb_CONTRIBUTE_TO_STEP_QTY(j),
 OLD_COMPONENT_SEQUENCE_ID = lb_OLD_COMPONENT_SEQUENCE_ID(j),
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
WHERE PLAN_ID= -1
AND BILL_SEQUENCE_ID= lb_BILL_SEQUENCE_ID(j)
  AND COMPONENT_SEQUENCE_ID= lb_COMPONENT_SEQUENCE_ID(j)
  AND SR_INSTANCE_ID= lb_SR_INSTANCE_ID(j);

Line: 2527


         'INSERT INTO '||lv_tbl
          ||' SELECT * from MSC_BOM_COMPONENTS'
          ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
          ||' AND plan_id = -1 '
          ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

Line: 2569


SELECT
  msdr.RESOURCE_CODE,
  msdr.DEPARTMENT_CODE,
  msdr.DEPARTMENT_DESCRIPTION,
  msdr.RESOURCE_DESCRIPTION,
  msdr.DEPARTMENT_CLASS,
  msdr.LINE_FLAG,
  msdr.CAPACITY_UNITS,
  msdr.MAX_RATE,
  msdr.MIN_RATE,
  msdr.AGGREGATED_RESOURCE_ID,
  msdr.AGGREGATED_RESOURCE_FLAG,
  msdr.RESOURCE_GROUP_NAME,
  msdr.RESOURCE_GROUP_CODE,
  msdr.RESOURCE_BALANCE_FLAG,
  msdr.BOTTLENECK_FLAG,
  msdr.DEPARTMENT_ID,
  msdr.OWNING_DEPARTMENT_ID,
  msdr.ORGANIZATION_ID,
  msdr.RESOURCE_ID,
  msdr.SR_INSTANCE_ID,
  msdr.OVER_UTILIZED_PERCENT,
  msdr.UNDER_UTILIZED_PERCENT,
  msdr.RESOURCE_SHORTAGE_TYPE,
  msdr.RESOURCE_EXCESS_TYPE,
  msdr.PLANNING_EXCEPTION_SET,
  msdr.USER_TIME_FENCE,
  msdr.UTILIZATION,
  msdr.EFFICIENCY,
  msdr.BATCHABLE_FLAG,
  msdr.BATCHING_WINDOW,
  msdr.MIN_CAPACITY,
  msdr.MAX_CAPACITY,
  msdr.UNIT_OF_MEASURE,
  msdr.RESOURCE_INCLUDE_FLAG,
  msdr.CRITICAL_RESOURCE_FLAG,
  msdr.RESOURCE_TYPE,
  msdr.DISABLE_DATE,
  msdr.AVAILABLE_24_HOURS_FLAG,
  msdr.CTP_FLAG,
  msdr.START_TIME,
  msdr.STOP_TIME,
  msdr.RESOURCE_COST,
  msdr.RESOURCE_OVER_UTIL_COST,
  msdr.DEPT_OVERHEAD_COST,
  msdr.ATP_RULE_ID,
  msdr.DELETED_FLAG,
  msdr.CAPACITY_TOLERANCE,   /* ds change change start */
  msdr.CHARGEABLE_FLAG,
  msdr.IDLE_TIME_TOLERANCE,
  msdr.BATCHING_PENALTY,
  msdr.SCHEDULE_TO_INSTANCE,
  msdr.LAST_KNOWN_SETUP,
  msdr.SETUP_TIME_PERCENT,
  msdr.UTILIZATION_CHANGE_PERCENT,
  msdr.SETUP_TIME_TYPE,
  msdr.UTILIZATION_CHANGE_TYPE ,
  msdr.SDS_SCHEDULING_WINDOW  /* ds change change end */
FROM MSC_ST_DEPARTMENT_RESOURCES msdr
WHERE msdr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 2631


SELECT
  msss.ORGANIZATION_ID,
  msss.SIMULATION_SET,
  msss.DESCRIPTION,
  msss.USE_IN_WIP_FLAG,
  msss.SR_INSTANCE_ID
FROM MSC_ST_SIMULATION_SETS msss
WHERE msss.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 2641


SELECT
  msrg.GROUP_CODE,
  msrg.MEANING,
  msrg.DESCRIPTION,
  msrg.FROM_DATE,
  msrg.TO_DATE,
  msrg.ENABLED_FLAG
FROM MSC_ST_RESOURCE_GROUPS msrg
WHERE msrg.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

Line: 2653


SELECT
  msdri.RESOURCE_ID,
  msdri.DEPARTMENT_ID,
  msdri.ORGANIZATION_ID,
  msdri.SR_INSTANCE_ID,
  msdri.RES_INSTANCE_ID,
  t1.inventory_item_id EQUIPMENT_ITEM_ID,
  msdri.SERIAL_NUMBER,
  msdri.EFFECTIVE_START_DATE,
  msdri.EFFECTIVE_END_DATE,
  msdri.LAST_KNOWN_SETUP,
  msdri.DELETED_FLAG
FROM MSC_ST_DEPT_RES_INSTANCES msdri,
MSC_ITEM_ID_LID t1
WHERE msdri.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
AND t1.sr_instance_id (+) = msdri.sr_instance_id
AND t1.sr_inventory_item_id (+) = msdri.equipment_item_id;

Line: 2706


/* Bug 2878327 - We will always delete msc_department_resources and insert
                 into it as it uses no snapshots
*/

/* ds change change start */
select bom, wip
into lv_bom, lv_wip
from msc_coll_parameters
where instance_id = MSC_CL_COLLECTION.v_instance_id;

Line: 2718


      MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 2721


      MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPT_RES_INSTANCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);  /* ds change change */

Line: 2730


  MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_GROUPS', MSC_CL_COLLECTION.v_instance_id, NULL); /*No Organization_id Column */

Line: 2733


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

Line: 2734


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL);

Line: 2737


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEPARTMENT_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line: 2738


    MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SIMULATION_SETS', MSC_CL_COLLECTION.v_instance_id,NULL,v_sub_str);

Line: 2745


/* Bug 3041176 - Delete Only Department resources in NetChange */

 p_instance_id := MSC_CL_COLLECTION.v_instance_id;

Line: 2752


         lv_sql_stmt:= 'SELECT COUNT(*)'
                   ||' FROM '||p_table_name||' mdr, msc_trading_partners mtp'
                   ||' WHERE mdr.SR_INSTANCE_ID= :p_instance_id'
                   ||'   AND mdr.PLAN_ID= -1 '
                   ||'    AND mdr.LINE_FLAG = 2'
                   ||'    AND mdr.organization_id '|| MSC_UTIL.v_in_org_str
                   ||' AND mtp.sr_instance_id = :p_instance_id'
                   ||' AND mtp.sr_tp_id = mdr.organization_id'
                   ||' AND mtp.partner_type = 3'
                   ||' AND mtp.organization_type = 1';

Line: 2770


             lv_sql_stmt:=  'DELETE '||p_table_name||' mdr'
                         ||'  WHERE mdr.SR_INSTANCE_ID= :lv_instance_id'
                         ||'    AND mdr.PLAN_ID= -1 '
                         ||'    AND mdr.LINE_FLAG = 2'
                         ||'    AND mdr.organization_id '|| MSC_UTIL.v_in_org_str
                         ||'    AND mdr.organization_id = '
                         ||'        (SELECT mtp.sr_tp_id'
                         ||'         FROM msc_trading_partners mtp'
                         ||'         WHERE mtp.sr_instance_id = :lv_instance_id'
                         ||'         AND mtp.sr_tp_id = mdr.organization_id'
                         ||'         AND mtp.partner_type = 3'
                         ||'         AND mtp.organization_type = 1)';

Line: 2790


             lv_sql_stmt:=   'DELETE '||p_table_name||' mdr'
                         ||'  WHERE mdr.SR_INSTANCE_ID= :p_instance_id '
                         ||'    AND mdr.PLAN_ID= -1 '
                         ||'    AND mdr.LINE_FLAG = 2'
                         ||'    AND mdr.organization_id '|| MSC_UTIL.v_in_org_str
                         ||'    AND ROWNUM < :lv_pbs'
                         ||'    AND mdr.organization_id = '
                         ||'        (SELECT mtp.sr_tp_id'
                         ||'         FROM msc_trading_partners mtp'
                         ||'         WHERE mtp.sr_instance_id = :p_instance_id'
                         ||'         AND mtp.sr_tp_id = mdr.organization_id'
                         ||'         AND mtp.partner_type = 3'
                         ||'         AND mtp.organization_type = 1)';

Line: 2830


 SELECT DECODE(upper(uom_class),'WEIGHT',1 ,'VOLUME',2 , 1)
 INTO   lv_uom_class_type
 FROM   MSC_UNITS_OF_MEASURE
 WHERE  UOM_CODE = c_rec.unit_of_measure;

Line: 2844


IF c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN

UPDATE MSC_DEPARTMENT_RESOURCES
   SET CAPACITY_UNITS= 0,
       MAX_RATE= 0,
       MIN_RATE= 0,
       REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
       LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
       LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
WHERE PLAN_ID= -1
  AND DEPARTMENT_ID= c_rec.DEPARTMENT_ID
  AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
  AND RESOURCE_ID= c_rec.RESOURCE_ID
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 2860


UPDATE MSC_DEPARTMENT_RESOURCES
SET
 RESOURCE_CODE= c_rec.RESOURCE_CODE,
 DEPARTMENT_CODE= c_rec.DEPARTMENT_CODE,
 DEPARTMENT_DESCRIPTION= c_rec.DEPARTMENT_DESCRIPTION,
 RESOURCE_DESCRIPTION= c_rec.RESOURCE_DESCRIPTION,
 DEPARTMENT_CLASS= c_rec.DEPARTMENT_CLASS,
 LINE_FLAG= c_rec.LINE_FLAG,
 CAPACITY_UNITS= c_rec.CAPACITY_UNITS,
 MAX_RATE= c_rec.MAX_RATE,
 MIN_RATE= c_rec.MIN_RATE,
 AGGREGATE_RESOURCE_ID= c_rec.AGGREGATED_RESOURCE_ID,
 AGGREGATE_RESOURCE_FLAG= c_rec.AGGREGATED_RESOURCE_FLAG,
 RESOURCE_GROUP_NAME= c_rec.RESOURCE_GROUP_NAME,
 RESOURCE_GROUP_CODE= c_rec.RESOURCE_GROUP_CODE,
 RESOURCE_BALANCE_FLAG= c_rec.RESOURCE_BALANCE_FLAG,
 BOTTLENECK_FLAG= c_rec.BOTTLENECK_FLAG,
 OWNING_DEPARTMENT_ID= c_rec.OWNING_DEPARTMENT_ID,
 OVERUTILIZED_PERCENT= c_rec.OVER_UTILIZED_PERCENT,
 UNDERUTILIZED_PERCENT= c_rec.UNDER_UTILIZED_PERCENT,
 RESOURCE_SHORTAGE_TYPE= c_rec.RESOURCE_SHORTAGE_TYPE,
 RESOURCE_EXCESS_TYPE= c_rec.RESOURCE_EXCESS_TYPE,
 RESOURCE_INCLUDE_FLAG= c_rec.RESOURCE_INCLUDE_FLAG,
 PLANNING_EXCEPTION_SET= c_rec.PLANNING_EXCEPTION_SET,
 USER_TIME_FENCE= c_rec.USER_TIME_FENCE,
 UTILIZATION= c_rec.UTILIZATION,
 EFFICIENCY= c_rec.EFFICIENCY,
 BATCHABLE_FLAG= c_rec.BATCHABLE_FLAG,
 BATCHING_WINDOW= c_rec.BATCHING_WINDOW,
 MIN_CAPACITY= c_rec.MIN_CAPACITY,
 MAX_CAPACITY= c_rec.MAX_CAPACITY,
 UNIT_OF_MEASURE= c_rec.UNIT_OF_MEASURE,
 UOM_CLASS_TYPE = lv_uom_class_type,
 CRITICAL_RESOURCE_FLAG= c_rec.CRITICAL_RESOURCE_FLAG,
 RESOURCE_TYPE= c_rec.RESOURCE_TYPE,
 DISABLE_DATE= c_rec.DISABLE_DATE,
 AVAILABLE_24_HOURS_FLAG= c_rec.AVAILABLE_24_HOURS_FLAG,
 CTP_FLAG= c_rec.CTP_FLAG,
 START_TIME= c_rec.START_TIME,
 STOP_TIME= c_rec.STOP_TIME,
 RESOURCE_COST= c_rec.RESOURCE_COST,
 RESOURCE_OVER_UTIL_COST= c_rec.RESOURCE_OVER_UTIL_COST,
 DEPT_OVERHEAD_COST= c_rec.DEPT_OVERHEAD_COST,
 ATP_RULE_ID=c_rec.ATP_RULE_ID,
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user,
 CAPACITY_TOLERANCE= c_rec.CAPACITY_TOLERANCE,   /* ds change change start*/
 CHARGEABLE_FLAG= c_rec.CHARGEABLE_FLAG,
 IDLE_TIME_TOLERANCE= c_rec.IDLE_TIME_TOLERANCE,
 BATCHING_PENALTY= c_rec.BATCHING_PENALTY,
 SCHEDULE_TO_INSTANCE= c_rec.SCHEDULE_TO_INSTANCE,
 LAST_KNOWN_SETUP= c_rec.LAST_KNOWN_SETUP	 ,
 SETUP_TIME_PERCENT= c_rec.SETUP_TIME_PERCENT,
 UTILIZATION_CHANGE_PERCENT= c_rec.UTILIZATION_CHANGE_PERCENT,
 SETUP_TIME_TYPE= c_rec.SETUP_TIME_TYPE,
 UTILIZATION_CHANGE_TYPE= c_rec.UTILIZATION_CHANGE_TYPE,
 SDS_SCHEDULING_WINDOW= c_rec.SDS_SCHEDULING_WINDOW /* ds change change end */
WHERE PLAN_ID= -1
  AND DEPARTMENT_ID= c_rec.DEPARTMENT_ID
  AND ORGANIZATION_ID= c_rec.ORGANIZATION_ID
  AND RESOURCE_ID= c_rec.RESOURCE_ID
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 2924


END IF;  -- DELETED_FLAG

Line: 2930


INSERT INTO MSC_DEPARTMENT_RESOURCES
( PLAN_ID,
  RESOURCE_CODE,
  DEPARTMENT_CODE,
  DEPARTMENT_DESCRIPTION,
  RESOURCE_DESCRIPTION,
  DEPARTMENT_CLASS,
  LINE_FLAG,
  CAPACITY_UNITS,
  MAX_RATE,
  MIN_RATE,
  AGGREGATE_RESOURCE_ID,
  AGGREGATE_RESOURCE_FLAG,
  RESOURCE_GROUP_NAME,
  RESOURCE_GROUP_CODE,
  RESOURCE_BALANCE_FLAG,
  BOTTLENECK_FLAG,
  DEPARTMENT_ID,
  OWNING_DEPARTMENT_ID,
  ORGANIZATION_ID,
  RESOURCE_ID,
  SR_INSTANCE_ID,
  OVERUTILIZED_PERCENT,
  UNDERUTILIZED_PERCENT,
  RESOURCE_SHORTAGE_TYPE,
  RESOURCE_EXCESS_TYPE,
  RESOURCE_INCLUDE_FLAG,
  PLANNING_EXCEPTION_SET,
  USER_TIME_FENCE,
  UTILIZATION,
  EFFICIENCY,
  BATCHABLE_FLAG,
  BATCHING_WINDOW,
  MIN_CAPACITY,
  MAX_CAPACITY,
  UNIT_OF_MEASURE,
  UOM_CLASS_TYPE ,
  CRITICAL_RESOURCE_FLAG,
  RESOURCE_TYPE,
  DISABLE_DATE,
  AVAILABLE_24_HOURS_FLAG,
  CTP_FLAG,
  START_TIME,
  STOP_TIME,
  RESOURCE_COST,
  RESOURCE_OVER_UTIL_COST,
  DEPT_OVERHEAD_COST,
  ATP_RULE_ID,
  CAPACITY_TOLERANCE,			  /* ds change change start*/
  CHARGEABLE_FLAG,
  IDLE_TIME_TOLERANCE,
  BATCHING_PENALTY,
  SCHEDULE_TO_INSTANCE,
  LAST_KNOWN_SETUP,
  SETUP_TIME_PERCENT,
  UTILIZATION_CHANGE_PERCENT,
  SETUP_TIME_TYPE,
  UTILIZATION_CHANGE_TYPE ,
  SDS_SCHEDULING_WINDOW,  /* ds change change end */
  REFRESH_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( -1,
  c_rec.RESOURCE_CODE,
  c_rec.DEPARTMENT_CODE,
  c_rec.DEPARTMENT_DESCRIPTION,
  c_rec.RESOURCE_DESCRIPTION,
  c_rec.DEPARTMENT_CLASS,
  c_rec.LINE_FLAG,
  c_rec.CAPACITY_UNITS,
  c_rec.MAX_RATE,
  c_rec.MIN_RATE,
  c_rec.AGGREGATED_RESOURCE_ID,
  c_rec.AGGREGATED_RESOURCE_FLAG,
  c_rec.RESOURCE_GROUP_NAME,
  c_rec.RESOURCE_GROUP_CODE,
  c_rec.RESOURCE_BALANCE_FLAG,
  c_rec.BOTTLENECK_FLAG,
  c_rec.DEPARTMENT_ID,
  c_rec.OWNING_DEPARTMENT_ID,
  c_rec.ORGANIZATION_ID,
  c_rec.RESOURCE_ID,
  c_rec.SR_INSTANCE_ID,
  c_rec.OVER_UTILIZED_PERCENT,
  c_rec.UNDER_UTILIZED_PERCENT,
  c_rec.RESOURCE_SHORTAGE_TYPE,
  c_rec.RESOURCE_EXCESS_TYPE,
  c_rec.RESOURCE_INCLUDE_FLAG,
  c_rec.PLANNING_EXCEPTION_SET,
  c_rec.USER_TIME_FENCE,
  c_rec.UTILIZATION,
  c_rec.EFFICIENCY,
  c_rec.BATCHABLE_FLAG,
  c_rec.BATCHING_WINDOW,
  c_rec.MIN_CAPACITY,
  c_rec.MAX_CAPACITY,
  c_rec.UNIT_OF_MEASURE,
  lv_uom_class_type ,
  c_rec.CRITICAL_RESOURCE_FLAG,
  c_rec.RESOURCE_TYPE,
  c_rec.DISABLE_DATE,
  c_rec.AVAILABLE_24_HOURS_FLAG,
  c_rec.CTP_FLAG,
  c_rec.START_TIME,
  c_rec.STOP_TIME,
  c_rec.RESOURCE_COST,
  c_rec.RESOURCE_OVER_UTIL_COST,
  c_rec.DEPT_OVERHEAD_COST,
  c_rec.ATP_RULE_ID,
  c_rec.CAPACITY_TOLERANCE,	/* ds change change start*/
  c_rec.CHARGEABLE_FLAG,
  c_rec.IDLE_TIME_TOLERANCE,
  c_rec.BATCHING_PENALTY,
  c_rec.SCHEDULE_TO_INSTANCE,
  c_rec.LAST_KNOWN_SETUP,
  c_rec.SETUP_TIME_PERCENT,
  c_rec.UTILIZATION_CHANGE_PERCENT,
  c_rec.SETUP_TIME_TYPE,
  c_rec.UTILIZATION_CHANGE_TYPE,
  c_rec.SDS_SCHEDULING_WINDOW,
   /* ds change change end */
  MSC_CL_COLLECTION.v_last_collection_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );

Line: 3128


	INSERT INTO MSC_DEPT_RES_INSTANCES
	( PLAN_ID,
	  DEPT_RESOURCE_INST_ID ,
  	  RESOURCE_ID,
	  RES_INSTANCE_ID,
	  DEPARTMENT_ID,
  	  ORGANIZATION_ID,
  	  SERIAL_NUMBER,
  	  EQUIPMENT_ITEM_ID,
  	  SR_INSTANCE_ID,
    	  LAST_KNOWN_SETUP,
	  EFFECTIVE_START_DATE,
	  EFFECTIVE_END_DATE,
  	  REFRESH_NUMBER,
  	  LAST_UPDATE_DATE,
  	  LAST_UPDATED_BY,
  	  CREATION_DATE,
  	  CREATED_BY)
	VALUES
	( -1,
        MSC_DEPT_RES_INSTANCES_S.NEXTVAL,
  	c_rec.RESOURCE_ID,
  	c_rec.RES_INSTANCE_ID,
  	c_rec.DEPARTMENT_ID,
  	c_rec.ORGANIZATION_ID,
  	c_rec.SERIAL_NUMBER,
  	c_rec.EQUIPMENT_ITEM_ID,
  	c_rec.SR_INSTANCE_ID,
  	c_rec.LAST_KNOWN_SETUP,
  	c_rec.EFFECTIVE_START_DATE,
  	c_rec.EFFECTIVE_END_DATE,
	MSC_CL_COLLECTION.v_last_collection_id,
  	MSC_CL_COLLECTION.v_current_date,
  	MSC_CL_COLLECTION.v_current_user,
  	MSC_CL_COLLECTION.v_current_date,
  	MSC_CL_COLLECTION.v_current_user );

Line: 3235


UPDATE MSC_SIMULATION_SETS
SET
 DESCRIPTION= c_rec.DESCRIPTION,
 USE_IN_WIP_FLAG= c_rec.USE_IN_WIP_FLAG,
 REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
 LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
 LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
WHERE ORGANIZATION_ID= c_rec.ORGANIZATION_ID
  AND SIMULATION_SET= c_rec.SIMULATION_SET
  AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line: 3250


INSERT INTO MSC_SIMULATION_SETS
( ORGANIZATION_ID,
  SIMULATION_SET,
  DESCRIPTION,
  USE_IN_WIP_FLAG,
  SR_INSTANCE_ID,
  REFRESH_NUMBER,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( c_rec.ORGANIZATION_ID,
  c_rec.SIMULATION_SET,
  c_rec.DESCRIPTION,
  c_rec.USE_IN_WIP_FLAG,
  c_rec.SR_INSTANCE_ID,
  MSC_CL_COLLECTION.v_last_collection_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );

Line: 3334


INSERT INTO MSC_RESOURCE_GROUPS
( GROUP_CODE,
  MEANING,
  DESCRIPTION,
  FROM_DATE,
  TO_DATE,
  ENABLED_FLAG,
  SR_INSTANCE_ID,
  LAST_UPDATE_DATE,
  LAST_UPDATED_BY,
  CREATION_DATE,
  CREATED_BY)
VALUES
( c_rec.GROUP_CODE,
  c_rec.MEANING,
  c_rec.DESCRIPTION,
  c_rec.FROM_DATE,
  c_rec.TO_DATE,
  c_rec.ENABLED_FLAG,
  MSC_CL_COLLECTION.v_instance_id,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user,
  MSC_CL_COLLECTION.v_current_date,
  MSC_CL_COLLECTION.v_current_user );