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 617: INSERT INTO WSH_ITM_ITEMS (

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

Line 655: WSH_ITM_ITEMS_S.NEXTVAL,

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