eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ITM_ITEM_SYNC dependencies on DBMS_SQL

Line 235: l_num_invItem_tab DBMS_SQL.Number_Table;

231: l_CursorID NUMBER;
232: l_ignore NUMBER;
233:
234: --PL/SQL Table used for Bulk Select
235: l_num_invItem_tab DBMS_SQL.Number_Table;
236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;

Line 236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;

232: l_ignore NUMBER;
233:
234: --PL/SQL Table used for Bulk Select
235: l_num_invItem_tab DBMS_SQL.Number_Table;
236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;

Line 237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;

233:
234: --PL/SQL Table used for Bulk Select
235: l_num_invItem_tab DBMS_SQL.Number_Table;
236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;

Line 238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;

234: --PL/SQL Table used for Bulk Select
235: l_num_invItem_tab DBMS_SQL.Number_Table;
236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;

Line 239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;

235: l_num_invItem_tab DBMS_SQL.Number_Table;
236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;

Line 240: l_num_orgId_tab DBMS_SQL.Number_Table;

236: l_varchar_PrdCode_tab DBMS_SQL.Varchar2_Table;
237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;

Line 241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;

237: l_varchar_Desc_tab DBMS_SQL.Varchar2_Table;
238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;
245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;

Line 242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;

238: l_varchar_LongDesc_tab DBMS_SQL.Clob_Table;
239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;
245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;

Line 243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;

239: l_varchar_hazClass_tab DBMS_SQL.Varchar2_Table;
240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;
245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;
247: l_LanguageCode VARCHAR2(4);

Line 244: l_num_itmVal_tab DBMS_SQL.Number_Table;

240: l_num_orgId_tab DBMS_SQL.Number_Table;
241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;
245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;
247: l_LanguageCode VARCHAR2(4);
248:

Line 245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;

241: l_num_srcOrgId_tab DBMS_SQL.Number_Table;
242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;
245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;
247: l_LanguageCode VARCHAR2(4);
248:
249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;

Line 246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;

242: l_varchar_ItmType_tab DBMS_SQL.Varchar2_Table;
243: l_varchar_UOM_tab DBMS_SQL.Varchar2_Table;
244: l_num_itmVal_tab DBMS_SQL.Number_Table;
245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;
247: l_LanguageCode VARCHAR2(4);
248:
249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;

Line 249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;

245: l_varchar_Curr_tab DBMS_SQL.Varchar2_Table;
246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;
247: l_LanguageCode VARCHAR2(4);
248:
249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;

Line 250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;

246: l_varchar_Coun_tab DBMS_SQL.Varchar2_Table;
247: l_LanguageCode VARCHAR2(4);
248:
249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;

Line 251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;

247: l_LanguageCode VARCHAR2(4);
248:
249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;

Line 252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;

248:
249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;

Line 253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;

249: l_varchar_Attrib1_tab DBMS_SQL.Varchar2_Table;
250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;

Line 254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;

250: l_varchar_Attrib2_tab DBMS_SQL.Varchar2_Table;
251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;

Line 255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;

251: l_varchar_Attrib3_tab DBMS_SQL.Varchar2_Table;
252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;

Line 256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;

252: l_varchar_Attrib4_tab DBMS_SQL.Varchar2_Table;
253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;

Line 257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;

253: l_varchar_Attrib5_tab DBMS_SQL.Varchar2_Table;
254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;

Line 258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;

254: l_varchar_Attrib6_tab DBMS_SQL.Varchar2_Table;
255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;

Line 259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;

255: l_varchar_Attrib7_tab DBMS_SQL.Varchar2_Table;
256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;

Line 260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;

256: l_varchar_Attrib8_tab DBMS_SQL.Varchar2_Table;
257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
264: l_num_Operunit_tab DBMS_SQL.Number_Table;

Line 261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;

257: l_varchar_Attrib9_tab DBMS_SQL.Varchar2_Table;
258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
264: l_num_Operunit_tab DBMS_SQL.Number_Table;
265:

Line 262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;

258: l_varchar_Attrib10_tab DBMS_SQL.Varchar2_Table;
259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
264: l_num_Operunit_tab DBMS_SQL.Number_Table;
265:
266: --For Insert to ITM Inteface Tables

Line 263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;

259: l_varchar_Attrib11_tab DBMS_SQL.Varchar2_Table;
260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
264: l_num_Operunit_tab DBMS_SQL.Number_Table;
265:
266: --For Insert to ITM Inteface Tables
267: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;

Line 264: l_num_Operunit_tab DBMS_SQL.Number_Table;

260: l_varchar_Attrib12_tab DBMS_SQL.Varchar2_Table;
261: l_varchar_Attrib13_tab DBMS_SQL.Varchar2_Table;
262: l_varchar_Attrib14_tab DBMS_SQL.Varchar2_Table;
263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
264: l_num_Operunit_tab DBMS_SQL.Number_Table;
265:
266: --For Insert to ITM Inteface Tables
267: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
268: l_num_ItmReqCtrl_tab DBMS_SQL.Number_Table;

Line 267: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;

263: l_varchar_Attrib15_tab DBMS_SQL.Varchar2_Table;
264: l_num_Operunit_tab DBMS_SQL.Number_Table;
265:
266: --For Insert to ITM Inteface Tables
267: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
268: l_num_ItmReqCtrl_tab DBMS_SQL.Number_Table;
269: l_num_invItemID_tab DBMS_SQL.Number_Table;
270:
271: l_tempInvItem NUMBER := -999;

Line 268: l_num_ItmReqCtrl_tab DBMS_SQL.Number_Table;

264: l_num_Operunit_tab DBMS_SQL.Number_Table;
265:
266: --For Insert to ITM Inteface Tables
267: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
268: l_num_ItmReqCtrl_tab DBMS_SQL.Number_Table;
269: l_num_invItemID_tab DBMS_SQL.Number_Table;
270:
271: l_tempInvItem NUMBER := -999;
272:

Line 269: l_num_invItemID_tab DBMS_SQL.Number_Table;

265:
266: --For Insert to ITM Inteface Tables
267: l_num_ReqCtrl_tab DBMS_SQL.Number_Table;
268: l_num_ItmReqCtrl_tab DBMS_SQL.Number_Table;
269: l_num_invItemID_tab DBMS_SQL.Number_Table;
270:
271: l_tempInvItem NUMBER := -999;
272:
273: l_user_id NUMBER;

Line 457: l_CursorID := DBMS_SQL.Open_Cursor;

453: END IF;
454:
455:
456: -- Parse cursor
457: l_CursorID := DBMS_SQL.Open_Cursor;
458: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
459:
460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);

Line 458: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);

454:
455:
456: -- Parse cursor
457: l_CursorID := DBMS_SQL.Open_Cursor;
458: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
459:
460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);

Line 460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);

456: -- Parse cursor
457: l_CursorID := DBMS_SQL.Open_Cursor;
458: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
459:
460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);

Line 461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);

457: l_CursorID := DBMS_SQL.Open_Cursor;
458: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
459:
460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);

Line 462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);

458: DBMS_SQL.PARSE(l_CursorID, l_SQLQuery, DBMS_SQL.v7);
459:
460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);

Line 463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);

459:
460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);

Line 464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);

460: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 1, l_num_invItem_tab, 100, 0);
461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);

Line 465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);

461: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 2, l_varchar_PrdCode_tab, 100, 0);
462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);

Line 466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);

462: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 3, l_varchar_Desc_tab, 100, 0);
463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);

Line 467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);

463: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 4, l_varchar_LongDesc_tab, 100, 0);
464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);

Line 468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);

464: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 5, l_varchar_hazClass_tab, 100, 0);
465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);

Line 469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);

465: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 6, l_num_orgId_tab, 100, 0);
466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);

Line 470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);

466: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 7, l_num_srcOrgId_tab, 100, 0);
467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);

Line 471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);

467: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 8, l_varchar_ItmType_tab, 100, 0);
468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);

Line 472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);

468: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 9, l_varchar_UOM_tab, 100, 0);
469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);

Line 473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);

469: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 10, l_num_itmVal_tab, 100, 0);
470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);

Line 474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);

470: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 11, l_varchar_Curr_tab, 100, 0);
471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);

Line 475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);

471: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 12, l_varchar_Coun_tab, 100, 0);
472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);

Line 476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);

472: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 13, l_varchar_Attrib1_tab, 100, 0);
473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);

Line 477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);

473: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 14, l_varchar_Attrib2_tab, 100, 0);
474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);

Line 478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);

474: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 15, l_varchar_Attrib3_tab, 100, 0);
475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);

Line 479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);

475: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 16, l_varchar_Attrib4_tab, 100, 0);
476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);

Line 480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);

476: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 17, l_varchar_Attrib5_tab, 100, 0);
477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);

Line 481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);

477: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 18, l_varchar_Attrib6_tab, 100, 0);
478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);

Line 482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);

478: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 19, l_varchar_Attrib7_tab, 100, 0);
479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);
486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);

Line 483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);

479: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 20, l_varchar_Attrib8_tab, 100, 0);
480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);
486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);
487: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_num_Operunit_tab , 100, 0);

Line 484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);

480: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 21, l_varchar_Attrib9_tab, 100, 0);
481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);
486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);
487: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_num_Operunit_tab , 100, 0);
488:

Line 485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);

481: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 22, l_varchar_Attrib10_tab, 100, 0);
482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);
486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);
487: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_num_Operunit_tab , 100, 0);
488:
489: --

Line 486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);

482: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 23, l_varchar_Attrib11_tab, 100, 0);
483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);
486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);
487: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_num_Operunit_tab , 100, 0);
488:
489: --
490: -- Debug Statements

Line 487: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_num_Operunit_tab , 100, 0);

483: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 24, l_varchar_Attrib12_tab, 100, 0);
484: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 25, l_varchar_Attrib13_tab, 100, 0);
485: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 26, l_varchar_Attrib14_tab, 100, 0);
486: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 27, l_varchar_Attrib15_tab, 100, 0);
487: DBMS_SQL.DEFINE_ARRAY(l_CursorID, 28, l_num_Operunit_tab , 100, 0);
488:
489: --
490: -- Debug Statements
491: --

Line 503: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);

499: IF l_debug_on THEN
500: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull bind values',WSH_DEBUG_SV.C_STMT_LEVEL);
501: END IF;
502:
503: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
504:
505: --Bulk Collect customized SQL
506: LOOP
507: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);

Line 507: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);

503: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
504:
505: --Bulk Collect customized SQL
506: LOOP
507: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
508:
509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);
510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);

Line 509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);

505: --Bulk Collect customized SQL
506: LOOP
507: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
508:
509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);
510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);

Line 510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);

506: LOOP
507: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
508:
509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);
510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);

Line 511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);

507: l_ignore := DBMS_SQL.FETCH_ROWS(l_CursorID);
508:
509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);
510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);

Line 512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);

508:
509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);
510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);

Line 513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);

509: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_num_invItem_tab);
510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);

Line 514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);

510: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_varchar_PrdCode_tab);
511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);

Line 515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);

511: DBMS_SQL.COLUMN_VALUE(l_CursorID, 3, l_varchar_Desc_tab);
512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);

Line 516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);

512: DBMS_SQL.COLUMN_VALUE(l_CursorID, 4, l_varchar_LongDesc_tab);
513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);

Line 517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);

513: DBMS_SQL.COLUMN_VALUE(l_CursorID, 5, l_varchar_hazClass_tab);
514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);

Line 518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);

514: DBMS_SQL.COLUMN_VALUE(l_CursorID, 6, l_num_orgId_tab);
515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);

Line 519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);

515: DBMS_SQL.COLUMN_VALUE(l_CursorID, 7, l_num_srcOrgId_tab);
516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);

Line 520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);

516: DBMS_SQL.COLUMN_VALUE(l_CursorID, 8, l_varchar_ItmType_tab);
517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);

Line 521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);

517: DBMS_SQL.COLUMN_VALUE(l_CursorID, 9, l_varchar_UOM_tab);
518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);

Line 522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);

518: DBMS_SQL.COLUMN_VALUE(l_CursorID, 10, l_num_itmVal_tab);
519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);

Line 523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);

519: DBMS_SQL.COLUMN_VALUE(l_CursorID, 11, l_varchar_Curr_tab);
520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);

Line 524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);

520: DBMS_SQL.COLUMN_VALUE(l_CursorID, 12, l_varchar_Coun_tab);
521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);

Line 525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);

521: DBMS_SQL.COLUMN_VALUE(l_CursorID, 13, l_varchar_Attrib1_tab);
522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);

Line 526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);

522: DBMS_SQL.COLUMN_VALUE(l_CursorID, 14, l_varchar_Attrib2_tab);
523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);

Line 527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);

523: DBMS_SQL.COLUMN_VALUE(l_CursorID, 15, l_varchar_Attrib3_tab);
524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);

Line 528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);

524: DBMS_SQL.COLUMN_VALUE(l_CursorID, 16, l_varchar_Attrib4_tab);
525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);

Line 529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);

525: DBMS_SQL.COLUMN_VALUE(l_CursorID, 17, l_varchar_Attrib5_tab);
526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);

Line 530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);

526: DBMS_SQL.COLUMN_VALUE(l_CursorID, 18, l_varchar_Attrib6_tab);
527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);

Line 531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);

527: DBMS_SQL.COLUMN_VALUE(l_CursorID, 19, l_varchar_Attrib7_tab);
528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);
535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);

Line 532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);

528: DBMS_SQL.COLUMN_VALUE(l_CursorID, 20, l_varchar_Attrib8_tab);
529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);
535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);
536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );

Line 533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);

529: DBMS_SQL.COLUMN_VALUE(l_CursorID, 21, l_varchar_Attrib9_tab);
530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);
535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);
536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );
537: EXIT WHEN l_ignore <> 100;

Line 534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);

530: DBMS_SQL.COLUMN_VALUE(l_CursorID, 22, l_varchar_Attrib10_tab);
531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);
535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);
536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );
537: EXIT WHEN l_ignore <> 100;
538: END LOOP;

Line 535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);

531: DBMS_SQL.COLUMN_VALUE(l_CursorID, 23, l_varchar_Attrib11_tab);
532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);
535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);
536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );
537: EXIT WHEN l_ignore <> 100;
538: END LOOP;
539: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );

532: DBMS_SQL.COLUMN_VALUE(l_CursorID, 24, l_varchar_Attrib12_tab);
533: DBMS_SQL.COLUMN_VALUE(l_CursorID, 25, l_varchar_Attrib13_tab);
534: DBMS_SQL.COLUMN_VALUE(l_CursorID, 26, l_varchar_Attrib14_tab);
535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);
536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );
537: EXIT WHEN l_ignore <> 100;
538: END LOOP;
539: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
540:

Line 539: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

535: DBMS_SQL.COLUMN_VALUE(l_CursorID, 27, l_varchar_Attrib15_tab);
536: DBMS_SQL.COLUMN_VALUE(l_CursorID, 28, l_num_Operunit_tab );
537: EXIT WHEN l_ignore <> 100;
538: END LOOP;
539: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
540:
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Items queried: ' , l_num_invItem_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
543: END IF;