APPS.INV_MINMAX_PVT dependencies on WSM_LOT_JOB_INTERFACE

Line 4178: /*Bug 15837698 Moved this part just before inserting into wsm_lot_job_interface*/

4174: from dual;
4175:
4176: l_mode_flag := 1;
4177:
4178: /*Bug 15837698 Moved this part just before inserting into wsm_lot_job_interface*/
4179: /* select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4180: INTO l_job_name
4181: from dual;
4182:

Line 4236: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.

4232:
4233: IF (p_osfm_batch_id is null) THEN
4234:
4235: --
4236: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
4237: --
4238:
4239: BEGIN
4240: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL

Line 4240: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL

4236: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
4237: --
4238:
4239: BEGIN
4240: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
4241: INTO l_osfm_batch_id
4242: FROM SYS.DUAL;
4243: EXCEPTION
4244: WHEN no_data_found THEN

Line 4246: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'

4242: FROM SYS.DUAL;
4243: EXCEPTION
4244: WHEN no_data_found THEN
4245: IF G_TRACE_ON = 1 THEN
4246: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'
4247: , 're_wip'
4248: , 9);
4249: END IF;
4250: RAISE wip_exc;

Line 4266: before inserting data into WSM_LOT_JOB_INTERFACE */

4262:
4263: IF l_is_lot_control = 'Y' THEN
4264:
4265: /*Bug 15837698 If it is a lot controlled item, only then use wip_job_number_s.nextval
4266: before inserting data into WSM_LOT_JOB_INTERFACE */
4267: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
4268: INTO l_job_name
4269: from dual;
4270:

Line 4274: INSERT INTO WSM_LOT_JOB_INTERFACE (

4270:
4271: print_debug('OSFM Job Name '||l_job_name , 're_wip', 9);
4272: /*End of Bug 15837698*/
4273:
4274: INSERT INTO WSM_LOT_JOB_INTERFACE (
4275: mode_flag,
4276: last_update_date,
4277: last_updated_by,
4278: creation_date,