DBA Data[Home] [Help]

APPS.WSH_ITM_ITEM_SYNC dependencies on WSH_ITM_REQUEST_CONTROL

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 554: select WSH_ITM_REQUEST_CONTROL_S.NEXTVAL

550: --Check if New Item
551: IF l_num_invItem_tab(i) <> l_tempInvItem THEN
552: l_tempInvItem := l_num_invItem_tab(i);
553: --Create a new Request Control Seq
554: select WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
555: into
556: l_num_ReqCtrl_tab(l_num_ReqCtrl_tab.COUNT + 1)
557: from dual;
558:

Line 582: INSERT INTO WSH_ITM_REQUEST_CONTROL(

578:
579: --Bulk Insert to Request Control Table
580: --ApplicationID = 702 (Bill of Materials)
581: FORALL i IN l_num_ReqCtrl_tab.FIRST..l_num_ReqCtrl_tab.LAST
582: INSERT INTO WSH_ITM_REQUEST_CONTROL(
583: REQUEST_CONTROL_ID,
584: APPLICATION_ID,
585: APPLICATION_USER_ID, --bug 11676284
586: PROCESS_FLAG,