166:
167: l_source_code VARCHAR2(30);
168:
169: CURSOR group_cur IS
170: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
171: FROM DUAL;
172:
173: -- Bug 3019869. Changed the below cursor to wip_job cursor.
174: -- Records will not reside in WJSI if the MRP Debug mode
2897: l_status_type NUMBER;
2898:
2899:
2900: CURSOR group_cur IS
2901: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
2902: FROM DUAL;
2903:
2904: CURSOR job_cur IS
2905: SELECT wip_entity_id
3411: 3,
3412: p_status_type,
3413: p_job_name,
3414: p_wip_entity_id,
3415: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3416: 2,
3417: 1,
3418: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3419: ) returning header_id into l_header_id;
3414: p_wip_entity_id,
3415: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3416: 2,
3417: 1,
3418: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3419: ) returning header_id into l_header_id;
3420:
3421:
3422: INSERT INTO WIP_JOB_DTLS_INTERFACE
3446: COUNT_POINT_TYPE
3447: )
3448: VALUES
3449: (
3450: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3451: p_group_id,
3452: p_wip_entity_id,
3453: p_organization_id,
3454: p_op_seq_num,
3597: 3,
3598: p_status_type,
3599: p_job_name,
3600: p_wip_entity_id,
3601: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3602: 2,
3603: 1,
3604: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3605: ) returning header_id into l_header_id;
3600: p_wip_entity_id,
3601: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3602: 2,
3603: 1,
3604: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3605: ) returning header_id into l_header_id;
3606:
3607:
3608: IF (p_op_type = 2) THEN
3639: UOM_CODE
3640: )
3641: VALUES
3642: (
3643: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3644: p_group_id,
3645: p_organization_id,
3646: p_op_seq_num,
3647: 1, -- ( 1- Load Resource) LOAD_TYPE
3704: UOM_CODE
3705: )
3706: VALUES
3707: (
3708: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3709: p_group_id,
3710: p_organization_id,
3711: p_op_seq_num,
3712: 1, -- ( 1- Load Resource) LOAD_TYPE