DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 694: -- Set L_WIP_BATCH_ID to the next Sequence of WIP_JOB_SCHEDULE_INTERFACE_S.

690: , 9);
691: END IF;
692:
693: --
694: -- Set L_WIP_BATCH_ID to the next Sequence of WIP_JOB_SCHEDULE_INTERFACE_S.
695: --
696: BEGIN
697: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL
698: INTO l_wip_batch_id

Line 697: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL

693: --
694: -- Set L_WIP_BATCH_ID to the next Sequence of WIP_JOB_SCHEDULE_INTERFACE_S.
695: --
696: BEGIN
697: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL
698: INTO l_wip_batch_id
699: FROM SYS.DUAL;
700: EXCEPTION
701: WHEN no_data_found THEN

Line 703: print_debug('Exception: WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL is not defined'

699: FROM SYS.DUAL;
700: EXCEPTION
701: WHEN no_data_found THEN
702: IF G_TRACE_ON = 1 THEN
703: print_debug('Exception: WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL is not defined'
704: , l_proc
705: , 9);
706: END IF;
707: RAISE fnd_api.g_exc_error;

Line 955: FROM WIP_JOB_SCHEDULE_INTERFACE

951: -- Submit the Concurrent Request for WIP Mass Load.
952: --
953: SELECT COUNT(*)
954: INTO l_count
955: FROM WIP_JOB_SCHEDULE_INTERFACE
956: WHERE GROUP_ID = l_wip_batch_id;
957:
958: IF l_count > 0 THEN
959:

Line 1093: ** WIP Batch Id of WIP_JOB_SCHEDULE_INTERFACE.

1089: ** Flag indicating if item is transactable.
1090: ** p_unit_price
1091: ** Unit list price - purchasing.
1092: ** p_wip_id
1093: ** WIP Batch Id of WIP_JOB_SCHEDULE_INTERFACE.
1094: ** p_user_id
1095: ** Identifier of the User performinng the Min Max planning.
1096: ** p_sysd
1097: ** Current System Date.