DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on WIP_JOB_SCHEDULE_INTERFACE

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

694: , 9);
695: END IF;
696:
697: --
698: -- Set L_WIP_BATCH_ID to the next Sequence of WIP_JOB_SCHEDULE_INTERFACE_S.
699: --
700: BEGIN
701: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL
702: INTO l_wip_batch_id

Line 701: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL

697: --
698: -- Set L_WIP_BATCH_ID to the next Sequence of WIP_JOB_SCHEDULE_INTERFACE_S.
699: --
700: BEGIN
701: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.NEXTVAL
702: INTO l_wip_batch_id
703: FROM SYS.DUAL;
704: EXCEPTION
705: WHEN no_data_found THEN

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

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

Line 959: FROM WIP_JOB_SCHEDULE_INTERFACE

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

Line 1097: ** WIP Batch Id of WIP_JOB_SCHEDULE_INTERFACE.

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