APPS.INV_MMX_WRAPPER_PVT dependencies on WSM_LOT_JOB_INTERFACE

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

719:
720: /* Added for Bug 6807835 */
721:
722: --
723: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
724: --
725:
726: BEGIN
727: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL

Line 727: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL

723: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
724: --
725:
726: BEGIN
727: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
728: INTO l_osfm_batch_id
729: FROM SYS.DUAL;
730: EXCEPTION
731: WHEN no_data_found THEN

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

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

Line 992: FROM WSM_LOT_JOB_INTERFACE

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