[Home] [Help]
395: l_cust_id := 0;
396: END;
397: END IF;
398:
399: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
400: into l_WIP_BATCH_ID
401: from dual;
402:
403: -- call to min_max API
1848: BEGIN
1849: IF build_in_wip <> 'Y' OR pick_components <> 'N' THEN
1850: RAISE wip_exc;
1851: ELSE
1852: -- print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);
1853: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1854: LAST_UPDATE_DATE,
1855: LAST_UPDATED_BY,
1856: CREATION_DATE,
1849: IF build_in_wip <> 'Y' OR pick_components <> 'N' THEN
1850: RAISE wip_exc;
1851: ELSE
1852: -- print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);
1853: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1854: LAST_UPDATE_DATE,
1855: LAST_UPDATED_BY,
1856: CREATION_DATE,
1857: CREATED_BY,