APPS.WSH_ITM_PARTY_SYNC dependencies on WSH_ITM_PARTIES

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 1068: --Saving Request Control for Child WSH_ITM_PARTIES Table

1064: l_varchar_rcAttrib14_tab(j) := l_varchar_tempAttrib14_tab(i);
1065: l_varchar_rcAttrib15_tab(j) := l_varchar_tempAttrib15_tab(i);
1066:
1067: END IF;
1068: --Saving Request Control for Child WSH_ITM_PARTIES Table
1069:
1070: l_num_PartyReqCtrl_tab(i) := l_num_ReqCtrl_tab(l_num_ReqCtrl_tab.COUNT);
1071: select WSH_ITM_PARTIES_S.NEXTVAL
1072: into

Line 1071: select WSH_ITM_PARTIES_S.NEXTVAL

1067: END IF;
1068: --Saving Request Control for Child WSH_ITM_PARTIES Table
1069:
1070: l_num_PartyReqCtrl_tab(i) := l_num_ReqCtrl_tab(l_num_ReqCtrl_tab.COUNT);
1071: select WSH_ITM_PARTIES_S.NEXTVAL
1072: into
1073: l_num_itmpartyID_tab(l_num_itmpartyID_tab.COUNT)
1074: from dual;
1075: END LOOP;

Line 1161: INSERT INTO WSH_ITM_PARTIES (

1157:
1158: --Bulk Insert into Parties Table
1159: IF l_num_PartyReqCtrl_tab.COUNT <> 0 THEN
1160: FOR i IN l_num_PartyReqCtrl_tab.FIRST..l_num_PartyReqCtrl_tab.LAST LOOP
1161: INSERT INTO WSH_ITM_PARTIES (
1162: PARTY_ID,
1163: CUST_SITE_USE_ID,
1164: REQUEST_CONTROL_ID,
1165: PARTY_NAME,