WIP Mass Load Interface(Discrete Job Interface)

The following are the insert statements for creating a discrete job through wip mass load.

== for creating a job
==========================
INSERT INTO                WIP_JOB_SCHEDULE_INTERFACE
  (last_update_date,
  last_updated_by,           
  creation_date,
  created_by,
last_update_login,
  group_id,            
  organization_id,
  load_type,
  wip_entity_id,
  process_phase,          
  process_status,
  header_id,
  allow_explosion,
  net_quantity,
  start_quantity,
  primary_item_id,
  COMPLETION_SUBINVENTORY,
--CLASS_CODE,
JOB_NAME,
first_unit_start_date,FIRST_UNIT_COMPLETION_DATE,LAST_UNIT_START_DATE,LAST_UNIT_COMPLETION_DATE
)
VALUES (
  SYSDATE,
  1318, 
  SYSDATE,
  1318,
  1318,
  1318,
  207,
  1, --1. create standard DJ, 2.creative pending repetitive schedule, 3. update standard or non standard job, 4. create non standard job
  null,
  2, --2. validation, 3.  EXPLOSION, 4. COMPLETION, 5. CREATION
  1, --1. pending 2. running, 3. error 4. complete 5. warning         
  1318
  ,'N',1,1
  ,98816  --KKTESTASS
  ,'FGI',
  --,'DISCRETE',
  'TESTKKWML1', sysdate,sysdate+1, sysdate,sysdate+1
  );
===============================
==FOR ADDING  AN OPERATION TO JOB
===============================
insert into wip_job_dtls_interface(group_id, organization_id, operation_seq_num,
                     department_id, load_type, substitution_type,
                     process_phase, process_status, last_update_date,
                     last_updated_by, creation_date,
                     created_by, parent_header_id,
             COUNT_POINT_TYPE,BACKFLUSH_FLAG
                                     )
             values(1318,--:parameter.user_id,--5300,
                    207,
                    3350,
                   6772,--KKTESTDEPT,
                    3,--load_type
                    2,--substitution_type
                    2,--process_phase
                    1,-- process_status
                    sysdate,
                    1318,--:parameter.user_id,
                    sysdate,
                    1318,--:parameter.user_id,
                    1318 , 2,1);
=======================
==FOR ADDING RESOURCE TO AN OPERATION
=============================
insert into wip_job_dtls_interface(group_id, organization_id, operation_seq_num,
                     RESOURCE_SEQ_NUM, RESOURCE_ID_NEW,USAGE_RATE_OR_AMOUNT,
 SCHEDULED_FLAG, ASSIGNED_UNITS,BASIS_TYPE,AUTOCHARGE_TYPE,STANDARD_RATE_FLAG,
START_DATE,COMPLETION_DATE,load_type, substitution_type,
                     process_phase, process_status, last_update_date,
                     last_updated_by, creation_date,
                     created_by, parent_header_id, SCHEDULE_SEQ_NUM
                                     )
             values(1318,--:parameter.user_id,--5300,
                    207,
                    3350,
                   10,--RESOURCE_SEQ_NUM,
           11266, --KKTESTRES
           0.5, -- USAGE RATE
           2, --SCHEDULE FLAG
           1, --ASSIGNED_UNITS
           1, --BASIS_TYPE
           1, --AUTOCHARGE_TYPE
           1, --STANDARD_RATE_FLAG
           sysdate, --START_DATE
           sysdate, --COMPLETION_DATE
                    1,--load_type
                    2,--substitution_type
                    2,--process_phase
                    1,-- process_status
                    sysdate,
                    1318,--:parameter.user_id,
                    sysdate,
                    1318,--:parameter.user_id,
                    1318,
            335010
);