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.ICX_POR_CTX_DESC dependencies on DBMS_SQL

Line 21: vRowids dbms_sql.urowid_table;

17: xErrLoc INTEGER := 0; -- execution location for error trapping
18: items_tl_cv item_source_cv_type;
19: items_tl_csr item_source_cv_type;
20:
21: vRowids dbms_sql.urowid_table;
22: BEGIN
23: xErrLoc := 100;
24:
25: IF (p_jobno <= 0) THEN

Line 186: vRowids dbms_sql.urowid_table;

182: getItemsTlCur item_source_cv_type;
183:
184: -- Bug # 3329169
185: items_tl_csr item_source_cv_type;
186: vRowids dbms_sql.urowid_table;
187:
188: BEGIN
189: xErrLoc := 100;
190:

Line 310: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;

306: xErrLoc:=200;
307: FOR catRec in getCatWithSearchCur(vLang, pJobNum)
308: LOOP
309: vCategoryId := catRec.rt_category_id;
310: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;
311: xErrLoc := 220;
312: -- OEX_IP_PORTING
313: vSqlString := 'SELECT tlp.rowid,tlp.rt_item_id,tlp.language FROM ICX_CAT_EXT_ITEMS_TLP tlp, icx_cat_items_b it where tlp.rt_category_id = :category_id and it.rt_item_id=tlp.rt_item_id and it.request_id=:request_id';
314: xErrLoc := 230;

Line 315: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);

311: xErrLoc := 220;
312: -- OEX_IP_PORTING
313: vSqlString := 'SELECT tlp.rowid,tlp.rt_item_id,tlp.language FROM ICX_CAT_EXT_ITEMS_TLP tlp, icx_cat_items_b it where tlp.rt_category_id = :category_id and it.rt_item_id=tlp.rt_item_id and it.request_id=:request_id';
314: xErrLoc := 230;
315: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
316: xErrLoc := 235;
317: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);
318: xErrLoc := 240;
319: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':request_id',pJobNum);

Line 317: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);

313: vSqlString := 'SELECT tlp.rowid,tlp.rt_item_id,tlp.language FROM ICX_CAT_EXT_ITEMS_TLP tlp, icx_cat_items_b it where tlp.rt_category_id = :category_id and it.rt_item_id=tlp.rt_item_id and it.request_id=:request_id';
314: xErrLoc := 230;
315: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
316: xErrLoc := 235;
317: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);
318: xErrLoc := 240;
319: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':request_id',pJobNum);
320: xErrLoc := 245;
321: populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,pDeleteYN,

Line 319: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':request_id',pJobNum);

315: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
316: xErrLoc := 235;
317: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);
318: xErrLoc := 240;
319: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':request_id',pJobNum);
320: xErrLoc := 245;
321: populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,pDeleteYN,
322: pUpdateYN, NULL, 'ROWID', p_log_type);
323: xErrLoc:=260;

Line 324: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);

320: xErrLoc := 245;
321: populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,pDeleteYN,
322: pUpdateYN, NULL, 'ROWID', p_log_type);
323: xErrLoc:=260;
324: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
325: xErrLoc:=280;
326: END LOOP;
327: xErrLoc:=300;
328: --Debugging

Line 335: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN

331: EXCEPTION
332: WHEN OTHERS THEN
333: ROLLBACK;
334:
335: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN
336: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
337: END IF;
338:
339: RAISE_APPLICATION_ERROR (-20000,

Line 336: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);

332: WHEN OTHERS THEN
333: ROLLBACK;
334:
335: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN
336: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
337: END IF;
338:
339: RAISE_APPLICATION_ERROR (-20000,
340: 'Exception at ICX_POR_CTX_DESC.populateCategoryAttribsByJob('||xErrLoc|| '), catId: ' || vCategoryId || ' Error: ' ||SQLERRM );

Line 393: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;

389: xErrLoc:=200;
390: FOR catRec in getCatWithSearchCur(vLang)
391: LOOP
392: vCategoryId := catRec.rt_category_id;
393: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;
394: xErrLoc := 220;
395: -- OEX_IP_PORTING
396: -- Add "and rt_item_id = :rt_item_ids". Bind array of the
397: -- item ids table

Line 400: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);

396: -- Add "and rt_item_id = :rt_item_ids". Bind array of the
397: -- item ids table
398: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_EXT_ITEMS_TLP where rt_category_id = :category_id';
399: xErrLoc := 230;
400: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
401: xErrLoc := 235;
402: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);
403: xErrLoc := 240;
404: populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,pDeleteYN,

Line 402: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);

398: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_EXT_ITEMS_TLP where rt_category_id = :category_id';
399: xErrLoc := 230;
400: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
401: xErrLoc := 235;
402: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',vCategoryId);
403: xErrLoc := 240;
404: populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,pDeleteYN,
405: pUpdateYN, NULL, 'ROWID', p_log_type);
406: xErrLoc:=260;

Line 407: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);

403: xErrLoc := 240;
404: populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,pDeleteYN,
405: pUpdateYN, NULL, 'ROWID', p_log_type);
406: xErrLoc:=260;
407: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
408: xErrLoc:=280;
409: END LOOP;
410: xErrLoc:=300;
411: --Debugging

Line 418: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN

414: EXCEPTION
415: WHEN OTHERS THEN
416: ROLLBACK;
417:
418: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN
419: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
420: END IF;
421:
422: RAISE_APPLICATION_ERROR (-20000,

Line 419: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);

415: WHEN OTHERS THEN
416: ROLLBACK;
417:
418: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN
419: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
420: END IF;
421:
422: RAISE_APPLICATION_ERROR (-20000,
423: 'Exception at ICX_POR_CTX_DESC.populateCategoryAttributes('||xErrLoc|| '), catId: ' || vCategoryId || ' Error: ' ||SQLERRM );

Line 436: vRowidTab DBMS_SQL.UROWID_TABLE;

432: p_log_type IN VARCHAR2 DEFAULT 'LOADER') IS
433: xErrLoc INTEGER := 0; -- execution location for error trapping
434: vInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
435: vUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
436: vRowidTab DBMS_SQL.UROWID_TABLE;
437: vItemIdTab DBMS_SQL.NUMBER_TABLE;
438: vLangTab DBMS_SQL.VARCHAR2_TABLE;
439: c_handle NUMBER ;
440: c_status PLS_INTEGER;

Line 437: vItemIdTab DBMS_SQL.NUMBER_TABLE;

433: xErrLoc INTEGER := 0; -- execution location for error trapping
434: vInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
435: vUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
436: vRowidTab DBMS_SQL.UROWID_TABLE;
437: vItemIdTab DBMS_SQL.NUMBER_TABLE;
438: vLangTab DBMS_SQL.VARCHAR2_TABLE;
439: c_handle NUMBER ;
440: c_status PLS_INTEGER;
441: vSqlString VARCHAR2(4000);

Line 438: vLangTab DBMS_SQL.VARCHAR2_TABLE;

434: vInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
435: vUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
436: vRowidTab DBMS_SQL.UROWID_TABLE;
437: vItemIdTab DBMS_SQL.NUMBER_TABLE;
438: vLangTab DBMS_SQL.VARCHAR2_TABLE;
439: c_handle NUMBER ;
440: c_status PLS_INTEGER;
441: vSqlString VARCHAR2(4000);
442: p_lang VARCHAR2(10) := NULL;

Line 503: c_handle:=DBMS_SQL.OPEN_CURSOR;

499: -- SqlTab Loop
500: FOR i in 1..vUpdateSqlTab.COUNT LOOP
501: xErrLoc := xErrLoc + 10;
502: vSqlString := vUpdateSqlTab(i);
503: c_handle:=DBMS_SQL.OPEN_CURSOR;
504: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
505:
506: IF (i = vUpdateSqlTab.COUNT - 1) THEN
507: -- This is the line

Line 504: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);

500: FOR i in 1..vUpdateSqlTab.COUNT LOOP
501: xErrLoc := xErrLoc + 10;
502: vSqlString := vUpdateSqlTab(i);
503: c_handle:=DBMS_SQL.OPEN_CURSOR;
504: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
505:
506: IF (i = vUpdateSqlTab.COUNT - 1) THEN
507: -- This is the line
508: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',10000);

Line 508: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',10000);

504: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
505:
506: IF (i = vUpdateSqlTab.COUNT - 1) THEN
507: -- This is the line
508: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',10000);
509: ELSIF (i = vUpdateSqlTab.COUNT) THEN
510: -- This is the line
511: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',15000);
512: ELSE

Line 511: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',15000);

507: -- This is the line
508: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',10000);
509: ELSIF (i = vUpdateSqlTab.COUNT) THEN
510: -- This is the line
511: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',15000);
512: ELSE
513: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',i);
514: END IF;
515:

Line 513: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',i);

509: ELSIF (i = vUpdateSqlTab.COUNT) THEN
510: -- This is the line
511: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',15000);
512: ELSE
513: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',i);
514: END IF;
515:
516: DBMS_SQL.BIND_VARIABLE(c_handle,':action_name','SYNC');
517: DBMS_SQL.BIND_VARIABLE(c_handle,':p_system_action','SYNC');

Line 516: DBMS_SQL.BIND_VARIABLE(c_handle,':action_name','SYNC');

512: ELSE
513: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',i);
514: END IF;
515:
516: DBMS_SQL.BIND_VARIABLE(c_handle,':action_name','SYNC');
517: DBMS_SQL.BIND_VARIABLE(c_handle,':p_system_action','SYNC');
518:
519: IF (pSourceType = 'ROWID') THEN
520: DBMS_SQL.BIND_ARRAY(c_handle,':p_rowid',vRowidTab);

Line 517: DBMS_SQL.BIND_VARIABLE(c_handle,':p_system_action','SYNC');

513: DBMS_SQL.BIND_VARIABLE(c_handle,':p_sequence',i);
514: END IF;
515:
516: DBMS_SQL.BIND_VARIABLE(c_handle,':action_name','SYNC');
517: DBMS_SQL.BIND_VARIABLE(c_handle,':p_system_action','SYNC');
518:
519: IF (pSourceType = 'ROWID') THEN
520: DBMS_SQL.BIND_ARRAY(c_handle,':p_rowid',vRowidTab);
521: ELSE

Line 520: DBMS_SQL.BIND_ARRAY(c_handle,':p_rowid',vRowidTab);

516: DBMS_SQL.BIND_VARIABLE(c_handle,':action_name','SYNC');
517: DBMS_SQL.BIND_VARIABLE(c_handle,':p_system_action','SYNC');
518:
519: IF (pSourceType = 'ROWID') THEN
520: DBMS_SQL.BIND_ARRAY(c_handle,':p_rowid',vRowidTab);
521: ELSE
522: DBMS_SQL.BIND_ARRAY(c_handle,':p_item_id',vItemIdTab);
523: END IF;
524:

Line 522: DBMS_SQL.BIND_ARRAY(c_handle,':p_item_id',vItemIdTab);

518:
519: IF (pSourceType = 'ROWID') THEN
520: DBMS_SQL.BIND_ARRAY(c_handle,':p_rowid',vRowidTab);
521: ELSE
522: DBMS_SQL.BIND_ARRAY(c_handle,':p_item_id',vItemIdTab);
523: END IF;
524:
525: IF (NOT pLanguage IS NULL) THEN
526: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);

Line 526: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);

522: DBMS_SQL.BIND_ARRAY(c_handle,':p_item_id',vItemIdTab);
523: END IF;
524:
525: IF (NOT pLanguage IS NULL) THEN
526: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);
527: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vLangTab);
528: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
529: END IF;
530:

Line 527: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vLangTab);

523: END IF;
524:
525: IF (NOT pLanguage IS NULL) THEN
526: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);
527: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vLangTab);
528: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
529: END IF;
530:
531: c_status := DBMS_SQL.EXECUTE(c_handle);

Line 528: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');

524:
525: IF (NOT pLanguage IS NULL) THEN
526: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);
527: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vLangTab);
528: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
529: END IF;
530:
531: c_status := DBMS_SQL.EXECUTE(c_handle);
532: DBMS_SQL.CLOSE_CURSOR(c_handle);

Line 531: c_status := DBMS_SQL.EXECUTE(c_handle);

527: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vLangTab);
528: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
529: END IF;
530:
531: c_status := DBMS_SQL.EXECUTE(c_handle);
532: DBMS_SQL.CLOSE_CURSOR(c_handle);
533: xErrLoc := xErrLoc + 10;
534: END LOOP; -- SqlTab Loop
535:

Line 532: DBMS_SQL.CLOSE_CURSOR(c_handle);

528: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
529: END IF;
530:
531: c_status := DBMS_SQL.EXECUTE(c_handle);
532: DBMS_SQL.CLOSE_CURSOR(c_handle);
533: xErrLoc := xErrLoc + 10;
534: END LOOP; -- SqlTab Loop
535:
536: xErrLoc := 500;

Line 547: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN

543: EXCEPTION
544: WHEN OTHERS THEN
545: ROLLBACK;
546:
547: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN
548: DBMS_SQL.CLOSE_CURSOR(c_handle);
549: END IF;
550:
551: RAISE_APPLICATION_ERROR (-20000,

Line 548: DBMS_SQL.CLOSE_CURSOR(c_handle);

544: WHEN OTHERS THEN
545: ROLLBACK;
546:
547: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN
548: DBMS_SQL.CLOSE_CURSOR(c_handle);
549: END IF;
550:
551: RAISE_APPLICATION_ERROR (-20000,
552: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBaseAtt('||xErrLoc||

Line 570: vCRowidTab DBMS_SQL.UROWID_TABLE;

566: IS
567: p_lang VARCHAR2(10) := NULL;
568: vCInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
569: vCUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
570: vCRowidTab DBMS_SQL.UROWID_TABLE;
571: vCLangTab DBMS_SQL.VARCHAR2_TABLE;
572: vCItemIdTab DBMS_SQL.NUMBER_TABLE;
573: c_handle NUMBER;
574: c_status PLS_INTEGER;

Line 571: vCLangTab DBMS_SQL.VARCHAR2_TABLE;

567: p_lang VARCHAR2(10) := NULL;
568: vCInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
569: vCUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
570: vCRowidTab DBMS_SQL.UROWID_TABLE;
571: vCLangTab DBMS_SQL.VARCHAR2_TABLE;
572: vCItemIdTab DBMS_SQL.NUMBER_TABLE;
573: c_handle NUMBER;
574: c_status PLS_INTEGER;
575: vSqlString VARCHAR2(4000);

Line 572: vCItemIdTab DBMS_SQL.NUMBER_TABLE;

568: vCInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
569: vCUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
570: vCRowidTab DBMS_SQL.UROWID_TABLE;
571: vCLangTab DBMS_SQL.VARCHAR2_TABLE;
572: vCItemIdTab DBMS_SQL.NUMBER_TABLE;
573: c_handle NUMBER;
574: c_status PLS_INTEGER;
575: vSqlString VARCHAR2(4000);
576: vTableName VARCHAR2(100);

Line 614: --vCursor := DBMS_SQL.OPEN_CURSOR;

610: -----------------------------------------------------------------------
611: -- Build a cursor with the category ID added the SQL
612: -- Define PL/SQL tables that will hold the value fetched
613: -----------------------------------------------------------------------
614: --vCursor := DBMS_SQL.OPEN_CURSOR;
615: --DBMS_SQL.PARSE(vCursor,'SELECT rowid,rt_item_id,language FROM '||
616: -- vTableName, DBMS_SQL.NATIVE);
617: xErrLoc := 200;
618: IF(pSourceType = 'ROWID') THEN

Line 615: --DBMS_SQL.PARSE(vCursor,'SELECT rowid,rt_item_id,language FROM '||

611: -- Build a cursor with the category ID added the SQL
612: -- Define PL/SQL tables that will hold the value fetched
613: -----------------------------------------------------------------------
614: --vCursor := DBMS_SQL.OPEN_CURSOR;
615: --DBMS_SQL.PARSE(vCursor,'SELECT rowid,rt_item_id,language FROM '||
616: -- vTableName, DBMS_SQL.NATIVE);
617: xErrLoc := 200;
618: IF(pSourceType = 'ROWID') THEN
619: xErrLoc := 220;

Line 616: -- vTableName, DBMS_SQL.NATIVE);

612: -- Define PL/SQL tables that will hold the value fetched
613: -----------------------------------------------------------------------
614: --vCursor := DBMS_SQL.OPEN_CURSOR;
615: --DBMS_SQL.PARSE(vCursor,'SELECT rowid,rt_item_id,language FROM '||
616: -- vTableName, DBMS_SQL.NATIVE);
617: xErrLoc := 200;
618: IF(pSourceType = 'ROWID') THEN
619: xErrLoc := 220;
620: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCRowidTab,BATCH_SIZE,vIndex);

Line 620: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCRowidTab,BATCH_SIZE,vIndex);

616: -- vTableName, DBMS_SQL.NATIVE);
617: xErrLoc := 200;
618: IF(pSourceType = 'ROWID') THEN
619: xErrLoc := 220;
620: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCRowidTab,BATCH_SIZE,vIndex);
621: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCItemIdTab,BATCH_SIZE,vIndex);
622: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,3,vCLangTab,BATCH_SIZE,vIndex);
623: xErrLoc := 240;
624: ELSE

Line 621: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCItemIdTab,BATCH_SIZE,vIndex);

617: xErrLoc := 200;
618: IF(pSourceType = 'ROWID') THEN
619: xErrLoc := 220;
620: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCRowidTab,BATCH_SIZE,vIndex);
621: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCItemIdTab,BATCH_SIZE,vIndex);
622: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,3,vCLangTab,BATCH_SIZE,vIndex);
623: xErrLoc := 240;
624: ELSE
625: xErrLoc := 260;

Line 622: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,3,vCLangTab,BATCH_SIZE,vIndex);

618: IF(pSourceType = 'ROWID') THEN
619: xErrLoc := 220;
620: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCRowidTab,BATCH_SIZE,vIndex);
621: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCItemIdTab,BATCH_SIZE,vIndex);
622: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,3,vCLangTab,BATCH_SIZE,vIndex);
623: xErrLoc := 240;
624: ELSE
625: xErrLoc := 260;
626: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCItemIdTab,BATCH_SIZE,vIndex);

Line 626: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCItemIdTab,BATCH_SIZE,vIndex);

622: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,3,vCLangTab,BATCH_SIZE,vIndex);
623: xErrLoc := 240;
624: ELSE
625: xErrLoc := 260;
626: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCItemIdTab,BATCH_SIZE,vIndex);
627: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCLangTab,BATCH_SIZE,vIndex);
628: xErrLoc := 280;
629: END IF;
630:

Line 627: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCLangTab,BATCH_SIZE,vIndex);

623: xErrLoc := 240;
624: ELSE
625: xErrLoc := 260;
626: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,1,vCItemIdTab,BATCH_SIZE,vIndex);
627: DBMS_SQL.DEFINE_ARRAY(pItemSourceCursor,2,vCLangTab,BATCH_SIZE,vIndex);
628: xErrLoc := 280;
629: END IF;
630:
631: xErrLoc := 300;

Line 632: vCStatus := DBMS_SQL.EXECUTE(pItemSourceCursor);

628: xErrLoc := 280;
629: END IF;
630:
631: xErrLoc := 300;
632: vCStatus := DBMS_SQL.EXECUTE(pItemSourceCursor);
633: -----------------------------------------------------------------------
634: -- Loop thru the cursor
635: -- FETCH_ROWS will fetch the next set of rows and fill the PL/SQL tables
636: -- Loop thru the UpdateSQL tab and for each sql

Line 643: vCStatus := DBMS_SQL.FETCH_ROWS(pItemSourceCursor);

639:
640: xErrLoc := 400;
641: LOOP
642:
643: vCStatus := DBMS_SQL.FETCH_ROWS(pItemSourceCursor);
644: IF(pSourceType = 'ROWID') THEN
645: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCRowidTab);
646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);
647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);

Line 645: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCRowidTab);

641: LOOP
642:
643: vCStatus := DBMS_SQL.FETCH_ROWS(pItemSourceCursor);
644: IF(pSourceType = 'ROWID') THEN
645: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCRowidTab);
646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);
647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);
648: ELSE
649: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCItemIdTab);

Line 646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);

642:
643: vCStatus := DBMS_SQL.FETCH_ROWS(pItemSourceCursor);
644: IF(pSourceType = 'ROWID') THEN
645: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCRowidTab);
646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);
647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);
648: ELSE
649: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCItemIdTab);
650: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCLangTab);

Line 647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);

643: vCStatus := DBMS_SQL.FETCH_ROWS(pItemSourceCursor);
644: IF(pSourceType = 'ROWID') THEN
645: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCRowidTab);
646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);
647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);
648: ELSE
649: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCItemIdTab);
650: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCLangTab);
651: END IF;

Line 649: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCItemIdTab);

645: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCRowidTab);
646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);
647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);
648: ELSE
649: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCItemIdTab);
650: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCLangTab);
651: END IF;
652:
653: xErrLoc := 310;

Line 650: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCLangTab);

646: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCItemIdTab);
647: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,3,vCLangTab);
648: ELSE
649: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,1,vCItemIdTab);
650: DBMS_SQL.COLUMN_VALUE(pItemSourceCursor,2,vCLangTab);
651: END IF;
652:
653: xErrLoc := 310;
654: --Debugging

Line 666: -- dbms_sql.column_value will keep incrementing the indexes of the

662: xErrLoc := 500;
663: IF (pDeleteYN = 'Y') THEN
664: -- Delete the rows for the categories
665: xErrLoc := xErrLoc + 10;
666: -- dbms_sql.column_value will keep incrementing the indexes of the
667: -- pl/sql tables, so need to use FIRST..LAST instead of 1..COUNT
668: FORALL i IN vCItemIdTab.FIRST..vCItemIdTab.LAST
669: DELETE FROM icx_cat_items_ctx_tlp
670: WHERE rt_item_id = vCItemIdTab(i)

Line 680: c_handle:=DBMS_SQL.OPEN_CURSOR;

676: xErrLoc := 600;
677: FOR i in 1..vCUpdateSqlTab.COUNT LOOP
678: xErrLoc := xErrLoc + 10;
679: vSqlString := vCUpdateSqlTab(i);
680: c_handle:=DBMS_SQL.OPEN_CURSOR;
681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);

Line 681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);

677: FOR i in 1..vCUpdateSqlTab.COUNT LOOP
678: xErrLoc := xErrLoc + 10;
679: vSqlString := vCUpdateSqlTab(i);
680: c_handle:=DBMS_SQL.OPEN_CURSOR;
681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');

Line 682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);

678: xErrLoc := xErrLoc + 10;
679: vSqlString := vCUpdateSqlTab(i);
680: c_handle:=DBMS_SQL.OPEN_CURSOR;
681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');
686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');

Line 683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);

679: vSqlString := vCUpdateSqlTab(i);
680: c_handle:=DBMS_SQL.OPEN_CURSOR;
681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');
686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');
687: IF(pSourceType = 'ROWID') THEN

Line 684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);

680: c_handle:=DBMS_SQL.OPEN_CURSOR;
681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');
686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');
687: IF(pSourceType = 'ROWID') THEN
688: DBMS_SQL.BIND_ARRAY(c_handle, ':p_rowid',vCRowidTab);

Line 685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');

681: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');
686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');
687: IF(pSourceType = 'ROWID') THEN
688: DBMS_SQL.BIND_ARRAY(c_handle, ':p_rowid',vCRowidTab);
689: ELSE

Line 686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');

682: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_sequence',i+5000);
683: DBMS_SQL.BIND_VARIABLE(c_handle,':current_category_id',pCategoryId);
684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');
686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');
687: IF(pSourceType = 'ROWID') THEN
688: DBMS_SQL.BIND_ARRAY(c_handle, ':p_rowid',vCRowidTab);
689: ELSE
690: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id',vCItemIdTab);

Line 688: DBMS_SQL.BIND_ARRAY(c_handle, ':p_rowid',vCRowidTab);

684: DBMS_SQL.BIND_VARIABLE(c_handle,':p_category_id',pCategoryId);
685: DBMS_SQL.BIND_VARIABLE(c_handle, ':action_name','SYNC');
686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');
687: IF(pSourceType = 'ROWID') THEN
688: DBMS_SQL.BIND_ARRAY(c_handle, ':p_rowid',vCRowidTab);
689: ELSE
690: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id',vCItemIdTab);
691: END IF;
692:

Line 690: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id',vCItemIdTab);

686: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_system_action','SYNC');
687: IF(pSourceType = 'ROWID') THEN
688: DBMS_SQL.BIND_ARRAY(c_handle, ':p_rowid',vCRowidTab);
689: ELSE
690: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id',vCItemIdTab);
691: END IF;
692:
693: IF (NOT pLanguage IS NULL) THEN
694: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);

Line 694: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);

690: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id',vCItemIdTab);
691: END IF;
692:
693: IF (NOT pLanguage IS NULL) THEN
694: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);
695: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vCLangTab);
696: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
697: END IF;
698:

Line 695: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vCLangTab);

691: END IF;
692:
693: IF (NOT pLanguage IS NULL) THEN
694: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);
695: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vCLangTab);
696: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
697: END IF;
698:
699: c_status := DBMS_SQL.EXECUTE(c_handle);

Line 696: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');

692:
693: IF (NOT pLanguage IS NULL) THEN
694: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language',pLanguage);
695: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vCLangTab);
696: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
697: END IF;
698:
699: c_status := DBMS_SQL.EXECUTE(c_handle);
700: DBMS_SQL.CLOSE_CURSOR(c_handle);

Line 699: c_status := DBMS_SQL.EXECUTE(c_handle);

695: DBMS_SQL.BIND_ARRAY(c_handle, ':language_array', vCLangTab);
696: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
697: END IF;
698:
699: c_status := DBMS_SQL.EXECUTE(c_handle);
700: DBMS_SQL.CLOSE_CURSOR(c_handle);
701: END LOOP;
702:
703: xErrLoc := 700;

Line 700: DBMS_SQL.CLOSE_CURSOR(c_handle);

696: DBMS_SQL.BIND_VARIABLE(c_handle,':p_language_section',''||pLanguage||'');
697: END IF;
698:
699: c_status := DBMS_SQL.EXECUTE(c_handle);
700: DBMS_SQL.CLOSE_CURSOR(c_handle);
701: END LOOP;
702:
703: xErrLoc := 700;
704: IF (pUpdateYN = 'Y') THEN

Line 713: c_handle := DBMS_SQL.OPEN_CURSOR;

709: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||
710: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||
711: ':curr_lang = :p_lang AND language = :p_lang';
712:
713: c_handle := DBMS_SQL.OPEN_CURSOR;
714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);

Line 714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);

710: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||
711: ':curr_lang = :p_lang AND language = :p_lang';
712:
713: c_handle := DBMS_SQL.OPEN_CURSOR;
714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);
718: c_status := DBMS_SQL.EXECUTE(c_handle);

Line 715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);

711: ':curr_lang = :p_lang AND language = :p_lang';
712:
713: c_handle := DBMS_SQL.OPEN_CURSOR;
714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);
718: c_status := DBMS_SQL.EXECUTE(c_handle);
719: DBMS_SQL.CLOSE_CURSOR(c_handle);

Line 716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);

712:
713: c_handle := DBMS_SQL.OPEN_CURSOR;
714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);
718: c_status := DBMS_SQL.EXECUTE(c_handle);
719: DBMS_SQL.CLOSE_CURSOR(c_handle);
720: END LOOP;

Line 717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);

713: c_handle := DBMS_SQL.OPEN_CURSOR;
714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);
718: c_status := DBMS_SQL.EXECUTE(c_handle);
719: DBMS_SQL.CLOSE_CURSOR(c_handle);
720: END LOOP;
721: ELSE

Line 718: c_status := DBMS_SQL.EXECUTE(c_handle);

714: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);
718: c_status := DBMS_SQL.EXECUTE(c_handle);
719: DBMS_SQL.CLOSE_CURSOR(c_handle);
720: END LOOP;
721: ELSE
722: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||

Line 719: DBMS_SQL.CLOSE_CURSOR(c_handle);

715: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
716: DBMS_SQL.BIND_VARIABLE(c_handle, ':curr_lang', p_lang);
717: DBMS_SQL.BIND_ARRAY(c_handle, ':p_lang', vCLangTab);
718: c_status := DBMS_SQL.EXECUTE(c_handle);
719: DBMS_SQL.CLOSE_CURSOR(c_handle);
720: END LOOP;
721: ELSE
722: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||
723: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||

Line 726: c_handle := DBMS_SQL.OPEN_CURSOR;

722: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||
723: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||
724: 'language = :p_lang';
725:
726: c_handle := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);
730: c_status := DBMS_SQL.EXECUTE(c_handle);

Line 727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);

723: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||
724: 'language = :p_lang';
725:
726: c_handle := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);
730: c_status := DBMS_SQL.EXECUTE(c_handle);
731: DBMS_SQL.CLOSE_CURSOR(c_handle);

Line 728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);

724: 'language = :p_lang';
725:
726: c_handle := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);
730: c_status := DBMS_SQL.EXECUTE(c_handle);
731: DBMS_SQL.CLOSE_CURSOR(c_handle);
732: END IF;

Line 729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);

725:
726: c_handle := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);
730: c_status := DBMS_SQL.EXECUTE(c_handle);
731: DBMS_SQL.CLOSE_CURSOR(c_handle);
732: END IF;
733: END IF;

Line 730: c_status := DBMS_SQL.EXECUTE(c_handle);

726: c_handle := DBMS_SQL.OPEN_CURSOR;
727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);
730: c_status := DBMS_SQL.EXECUTE(c_handle);
731: DBMS_SQL.CLOSE_CURSOR(c_handle);
732: END IF;
733: END IF;
734:

Line 731: DBMS_SQL.CLOSE_CURSOR(c_handle);

727: DBMS_SQL.PARSE(c_handle, vSqlString, DBMS_SQL.NATIVE);
728: DBMS_SQL.BIND_ARRAY(c_handle, ':p_item_id', vCItemIdTab);
729: DBMS_SQL.BIND_VARIABLE(c_handle, ':p_lang', pLanguage);
730: c_status := DBMS_SQL.EXECUTE(c_handle);
731: DBMS_SQL.CLOSE_CURSOR(c_handle);
732: END IF;
733: END IF;
734:
735: xErrLoc := 800;

Line 750: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN

746: EXCEPTION
747: WHEN OTHERS THEN
748: ROLLBACK;
749:
750: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN
751: DBMS_SQL.CLOSE_CURSOR(c_handle);
752: END IF;
753:
754: RAISE_APPLICATION_ERROR (-20000,

Line 751: DBMS_SQL.CLOSE_CURSOR(c_handle);

747: WHEN OTHERS THEN
748: ROLLBACK;
749:
750: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN
751: DBMS_SQL.CLOSE_CURSOR(c_handle);
752: END IF;
753:
754: RAISE_APPLICATION_ERROR (-20000,
755: 'Exception at ICX_POR_CTX_DESC.populateCtxDescCatAtt('||xErrLoc||

Line 810: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;

806: CLOSE vItemSourceCv;
807:
808: -- category attributes
809: xErrLoc := 400;
810: vItemSourceCursor := DBMS_SQL.OPEN_CURSOR;
811: xErrLoc := 450;
812:
813: IF (p_lang is NULL) THEN -- update item
814: xErrLoc := 500;

Line 840: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);

836: ' WHERE rt_item_id=:item_id';
837: END IF;
838:
839: xErrLoc := 540;
840: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
841: xErrLoc := 560;
842: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);
843: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',p_category_id);
844:

Line 842: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);

838:
839: xErrLoc := 540;
840: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
841: xErrLoc := 560;
842: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);
843: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',p_category_id);
844:
845: xErrLoc := 580;
846: populateCtxDescCatAtt(p_category_id, vItemSourceCursor,'Y',

Line 843: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',p_category_id);

839: xErrLoc := 540;
840: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
841: xErrLoc := 560;
842: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);
843: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':category_id',p_category_id);
844:
845: xErrLoc := 580;
846: populateCtxDescCatAtt(p_category_id, vItemSourceCursor,'Y',
847: 'Y', p_lang, 'ROWID', p_log_type);

Line 873: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);

869: xErrLoc := 680;
870: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_POR_C'||p_category_id||'_TL' ||
871: ' WHERE rt_item_id=:item_id';
872: xErrLoc := 700;
873: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
874: xErrLoc := 720;
875: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);
876:
877: xErrLoc := 740;

Line 875: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);

871: ' WHERE rt_item_id=:item_id';
872: xErrLoc := 700;
873: DBMS_SQL.PARSE(vItemSourceCursor, vSqlString, DBMS_SQL.NATIVE);
874: xErrLoc := 720;
875: DBMS_SQL.BIND_VARIABLE(vItemSourceCursor,':item_id',p_item_id);
876:
877: xErrLoc := 740;
878: populateCtxDescCatAtt(p_category_id, vItemSourceCursor,'N',
879: 'N', p_lang, 'ROWID');

Line 886: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);

882: xErrLoc := 800;
883: END IF;
884:
885: xErrLoc := 900;
886: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
887: xErrLoc := 1000;
888: --Debugging
889: icx_por_ext_utl.debug('populateCtxDescLang done');
890: xErrLoc := 1001;

Line 899: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN

895: IF (vItemSourceCv%ISOPEN) THEN
896: CLOSE vItemSourceCv;
897: END IF;
898:
899: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN
900: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
901: END IF;
902:
903: RAISE_APPLICATION_ERROR (-20000,

Line 900: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);

896: CLOSE vItemSourceCv;
897: END IF;
898:
899: IF (DBMS_SQL.IS_OPEN(vItemSourceCursor)) THEN
900: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
901: END IF;
902:
903: RAISE_APPLICATION_ERROR (-20000,
904: 'Exception at ICX_POR_CTX_DESC.populateCtxDescLang('||xErrLoc||

Line 948: cursorID := DBMS_SQL.open_cursor;

944: xErrLoc := 40;
945: version := to_number(majorVersion) + (to_number(minorVersion) / 10);
946:
947: xErrLoc := 50;
948: cursorID := DBMS_SQL.open_cursor;
949: xErrLoc := 120;
950: IF version >= 8.1 THEN
951: --smallya Bug: 1713602 commented out the old package call and replaced it with the new one 04/06/2001--
952: --plsqlBlock := 'BEGIN icx_por_intermedia_index.rebuild_index; END;';

Line 963: dbms_sql.parse(cursorID, plsqlBlock, dbms_sql.NATIVE);

959: xErrLoc := 121;
960: --Debugging
961: icx_por_ext_utl.debug('plsql call made in rebuild_indexes:' || plsqlBlock);
962: xErrLoc := 122;
963: dbms_sql.parse(cursorID, plsqlBlock, dbms_sql.NATIVE);
964: xErrLoc := 123;
965: --Debugging
966: icx_por_ext_utl.debug('start to rebuild_indexes');
967: xErrLoc := 130;

Line 968: result := DBMS_SQL.execute(cursorID);

964: xErrLoc := 123;
965: --Debugging
966: icx_por_ext_utl.debug('start to rebuild_indexes');
967: xErrLoc := 130;
968: result := DBMS_SQL.execute(cursorID);
969: xErrLoc := 133;
970: --Debugging
971: icx_por_ext_utl.debug('rebuild_indexes done');
972: xErrLoc := 170;

Line 973: dbms_sql.close_cursor(cursorID);

969: xErrLoc := 133;
970: --Debugging
971: icx_por_ext_utl.debug('rebuild_indexes done');
972: xErrLoc := 170;
973: dbms_sql.close_cursor(cursorID);
974:
975: EXCEPTION
976: WHEN OTHERS THEN
977: RAISE_APPLICATION_ERROR(-20000,

Line 1038: vRowidTab DBMS_SQL.UROWID_TABLE;

1034: pLanguage IN VARCHAR2 DEFAULT NULL,
1035: pSourceType IN VARCHAR2 DEFAULT 'ROWID',
1036: p_log_type IN VARCHAR2 DEFAULT 'LOADER') is
1037: xErrLoc INTEGER := 0; -- execution location for error trapping
1038: vRowidTab DBMS_SQL.UROWID_TABLE;
1039: vItemIdTab DBMS_SQL.NUMBER_TABLE;
1040: vLangTab DBMS_SQL.VARCHAR2_TABLE;
1041: c_handle NUMBER ;
1042: c_status PLS_INTEGER;

Line 1039: vItemIdTab DBMS_SQL.NUMBER_TABLE;

1035: pSourceType IN VARCHAR2 DEFAULT 'ROWID',
1036: p_log_type IN VARCHAR2 DEFAULT 'LOADER') is
1037: xErrLoc INTEGER := 0; -- execution location for error trapping
1038: vRowidTab DBMS_SQL.UROWID_TABLE;
1039: vItemIdTab DBMS_SQL.NUMBER_TABLE;
1040: vLangTab DBMS_SQL.VARCHAR2_TABLE;
1041: c_handle NUMBER ;
1042: c_status PLS_INTEGER;
1043: vSqlString VARCHAR2(4000);

Line 1040: vLangTab DBMS_SQL.VARCHAR2_TABLE;

1036: p_log_type IN VARCHAR2 DEFAULT 'LOADER') is
1037: xErrLoc INTEGER := 0; -- execution location for error trapping
1038: vRowidTab DBMS_SQL.UROWID_TABLE;
1039: vItemIdTab DBMS_SQL.NUMBER_TABLE;
1040: vLangTab DBMS_SQL.VARCHAR2_TABLE;
1041: c_handle NUMBER ;
1042: c_status PLS_INTEGER;
1043: vSqlString VARCHAR2(4000);
1044: v_sequence PLS_INTEGER := 10001;

Line 1130: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN

1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: ROLLBACK;
1129:
1130: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN
1131: DBMS_SQL.CLOSE_CURSOR(c_handle);
1132: END IF;
1133:
1134: RAISE_APPLICATION_ERROR (-20000,

Line 1131: DBMS_SQL.CLOSE_CURSOR(c_handle);

1127: WHEN OTHERS THEN
1128: ROLLBACK;
1129:
1130: IF (DBMS_SQL.IS_OPEN(c_handle)) THEN
1131: DBMS_SQL.CLOSE_CURSOR(c_handle);
1132: END IF;
1133:
1134: RAISE_APPLICATION_ERROR (-20000,
1135: 'Exception at ICX_POR_CTX_DESC.populateCtxDescBuyerInfo('||xErrLoc || '), '||SQLERRM );