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:
769: l_varchar_rcAttrib14_tab(j) := l_varchar_tempAttrib14_tab(i);
770: l_varchar_rcAttrib15_tab(j) := l_varchar_tempAttrib15_tab(i);
771:
772: END IF;
773: --Saving Request Control for Child WSH_ITM_PARTIES Table
774:
775: l_num_PartyReqCtrl_tab(i) := l_num_ReqCtrl_tab(l_num_ReqCtrl_tab.COUNT);
776: select WSH_ITM_PARTIES_S.NEXTVAL
777: into
772: END IF;
773: --Saving Request Control for Child WSH_ITM_PARTIES Table
774:
775: l_num_PartyReqCtrl_tab(i) := l_num_ReqCtrl_tab(l_num_ReqCtrl_tab.COUNT);
776: select WSH_ITM_PARTIES_S.NEXTVAL
777: into
778: l_num_itmpartyID_tab(l_num_itmpartyID_tab.COUNT)
779: from dual;
780: END LOOP;
861:
862: --Bulk Insert into Parties Table
863: IF l_num_PartyReqCtrl_tab.COUNT <> 0 THEN
864: FOR i IN l_num_PartyReqCtrl_tab.FIRST..l_num_PartyReqCtrl_tab.LAST LOOP
865: INSERT INTO WSH_ITM_PARTIES (
866: PARTY_ID,
867: CUST_SITE_USE_ID,
868: REQUEST_CONTROL_ID,
869: PARTY_NAME,