APPS.INV_MMX_WRAPPER_PVT dependencies on WSM_LOT_JOB_INTERFACE

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

715:
716: /* Added for Bug 6807835 */
717:
718: --
719: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
720: --
721:
722: BEGIN
723: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL

Line 723: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL

719: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
720: --
721:
722: BEGIN
723: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
724: INTO l_osfm_batch_id
725: FROM SYS.DUAL;
726: EXCEPTION
727: WHEN no_data_found THEN

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

725: FROM SYS.DUAL;
726: EXCEPTION
727: WHEN no_data_found THEN
728: IF G_TRACE_ON = 1 THEN
729: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'
730: , l_proc
731: , 9);
732: END IF;
733: RAISE fnd_api.g_exc_error;

Line 988: FROM WSM_LOT_JOB_INTERFACE

984: /* Added for Bug 6807835 */
985:
986: SELECT count(*)
987: INTO l_job_count
988: FROM WSM_LOT_JOB_INTERFACE
989: WHERE GROUP_ID = l_osfm_batch_id;
990:
991: IF l_job_count > 0 THEN
992: l_reqid := FND_REQUEST.SUBMIT_REQUEST (