DBA Data[Home] [Help]

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

1042: --Create a new Request Control Seq
1043:
1044: j := l_num_ReqCtrl_tab.COUNT + 1;
1045:
1046: select WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
1047: into
1048: l_num_ReqCtrl_tab(j)
1049: from dual;
1050:

Line 1096: INSERT INTO WSH_ITM_REQUEST_CONTROL(

1092:
1093: --Bulk Insert to Request Control Table
1094: IF l_num_ReqCtrl_tab.COUNT <> 0 THEN
1095: FORALL i IN l_num_ReqCtrl_tab.FIRST..l_num_ReqCtrl_tab.LAST
1096: INSERT INTO WSH_ITM_REQUEST_CONTROL(
1097: REQUEST_CONTROL_ID,
1098: APPLICATION_ID,
1099: APPLICATION_USER_ID, --bug 11676284
1100: LANGUAGE_CODE,