Wip Job Ceration  Interface

Job Creation Custom Table

Import  Job  Details Through Procedure  and Validate with Open Interface

         SELECT wip_job_schedule_interface_s.NEXTVAL

           INTO v_group_id

           FROM DUAL;;

         SELECT wip_job_number_s.NEXTVAL

           INTO v_job

           FROM DUAL;

/* Formatted on 2014/07/31 15:31 (Formatter Plus v4.8.8) */

INSERT INTO wip_job_schedule_interface

            (organization_id,

            primary_item_id,

            job_name,

            start_quantity,

             net_quantity,

             first_unit_start_date,

             last_unit_completion_date,

             class_code, status_type,

             GROUP_ID,

             header_id,

              load_type,

             process_phase,

              process_status,

               created_by,

                creation_date,

             last_updated_by,

              last_update_date,

--                      completion_subinventory, completion_locator_id,

                                               wip_supply_type,

             date_released

            )

     VALUES (204, 2058906, wip_job_number_s.NEXTVAL, 1,

             1, SYSDATE, NULL,

             'STD_DIS', 3, wip_job_schedule_interface_s.NEXTVAL, 111, 4,

             2, 1, 1, SYSDATE,

             1, SYSDATE, 1,

             SYSDATE

            );        

INSERT INTO wip_job_schedule_interface

(

organization_id

, primary_item_id

, job_name

, start_quantity

, net_quantity

, first_unit_start_date

, class_code

, status_type

, group_id

, load_type

, process_phase

, process_status

, created_by

, creation_date

, last_updated_by

, last_update_date

)

values

(

123 -- organization_id

,2058906 -- primary_item_id

,WIP_JOB_NUMBER_S.nextval -- job_name

,3 -- start_quantity

,3 -- Net Quantity

,to_date('01-AUG-2014','DD-MON-RRRR') --first_unit_start_date

,'STD_DIS' --class_code

,1 --status_type 1.UnReleased 3. Released 4.Complete 6.On Hold 7. Cancelled

,wip_job_schedule_interface_s.NEXTVAL -- group_id

,1 -- load_type

/*

1 Create Standard Discrete Job

2 Create Pending Repetitive Schedule

3 Update Standard or Non-Standard Discrete Job

4 Create Non-Standard Discrete Job

*/

,2 -- process_phase 2 Validation 3 Explosion 4 Complete 5 Creation

,1 -- process_status 1 Pending 2 Running 3 Error 4 Complete 5 Warning

,7272 -- created_by

, SYSDATE -- creation_date

,7272 -- last_updated_by

, SYSDATE -- last_update_date

);

Declare

v_interface_request_id Number;

Begin

Apps.Fnd_Global.Apps_Initialize(7272,20560, 706);

         v_interface_request_id :=

            fnd_request.submit_request ('WIP',

                                        'WICMLP',

                                        'WIP Mass Load',

                                        NULL,

                                        FALSE,

                                        191444,

                                        0,

                                        1

                                       );

         COMMIT;

End;