APPS.WSH_ITM_PARTY_SYNC dependencies on WSH_ITM_REQUEST_CONTROL

Line 13: | into WSH_ITM_REQUEST_CONTROL and WSH_ITM_PARTIES |

9: | |
10: | DESCRIPTION |
11: | This procedure is called when the Party Synchronization |
12: | Concurrent Program is launched. It populates the data |
13: | into WSH_ITM_REQUEST_CONTROL and WSH_ITM_PARTIES |
14: | based on the parameters selected. |
15: | |
16: +===========================================================================*/
17:

Line 751: select WSH_ITM_REQUEST_CONTROL_S.NEXTVAL

747: --Create a new Request Control Seq
748:
749: j := l_num_ReqCtrl_tab.COUNT + 1;
750:
751: select WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
752: into
753: l_num_ReqCtrl_tab(j)
754: from dual;
755:

Line 802: INSERT INTO WSH_ITM_REQUEST_CONTROL(

798:
799: --Bulk Insert to Request Control Table
800: IF l_num_ReqCtrl_tab.COUNT <> 0 THEN
801: FORALL i IN l_num_ReqCtrl_tab.FIRST..l_num_ReqCtrl_tab.LAST
802: INSERT INTO WSH_ITM_REQUEST_CONTROL(
803: REQUEST_CONTROL_ID,
804: APPLICATION_ID,
805: LANGUAGE_CODE,
806: PROCESS_FLAG,