DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 399: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval

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

Line 1855: -- print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);

1851: BEGIN
1852: IF build_in_wip <> 'Y' OR pick_components <> 'N' THEN
1853: RAISE wip_exc;
1854: ELSE
1855: -- print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);
1856: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1857: LAST_UPDATE_DATE,
1858: LAST_UPDATED_BY,
1859: CREATION_DATE,

Line 1856: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(

1852: IF build_in_wip <> 'Y' OR pick_components <> 'N' THEN
1853: RAISE wip_exc;
1854: ELSE
1855: -- print_debug('Inserting into WIP_JOB_SCHEDULE_INTERFACE', 're_wip', 9);
1856: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1857: LAST_UPDATE_DATE,
1858: LAST_UPDATED_BY,
1859: CREATION_DATE,
1860: CREATED_BY,