DBA Data[Home] [Help]

APPS.WSH_ITM_ITEM_SYNC dependencies on WSH_ITM_ITEMS

Line 152: | into WSH_ITM_REQUEST_CONTROL and WSH_ITM_ITEMS |

148: | |
149: | DESCRIPTION |
150: | This procedure is called when the Item Synchronization |
151: | Concurrent Program is launched. It populates the data |
152: | into WSH_ITM_REQUEST_CONTROL and WSH_ITM_ITEMS |
153: | based on the parameters selected. |
154: | |
155: +===========================================================================*/
156:

Line 615: INSERT INTO WSH_ITM_ITEMS (

611: END IF;
612:
613: --Bulk Insert into Items Table
614: FORALL I IN l_num_ItmReqCtrl_tab.FIRST..l_num_ItmReqCtrl_tab.LAST
615: INSERT INTO WSH_ITM_ITEMS (
616: ITEM_ID,
617: REQUEST_CONTROL_ID,
618: INVENTORY_ITEM_ID,
619: ORGANIZATION_ID,

Line 653: WSH_ITM_ITEMS_S.NEXTVAL,

649: LAST_UPDATE_LOGIN,
650: OPERATING_UNIT
651: )
652: VALUES(
653: WSH_ITM_ITEMS_S.NEXTVAL,
654: l_num_ItmReqCtrl_tab(i),
655: l_num_invItem_tab(i),
656: l_num_orgId_tab(i),
657: l_varchar_PrdCode_tab(i),