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

Line 191: ln_cursor := dbms_sql.open_cursor;

187: ' AND msib.inventory_item_id ='||l_item_id||' '||
188: ' AND msib.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
189: ' AND rownum < '||(row_limit/25);
190:
191: ln_cursor := dbms_sql.open_cursor;
192: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
193: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
194: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
195:

Line 192: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

188: ' AND msib.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
189: ' AND rownum < '||(row_limit/25);
190:
191: ln_cursor := dbms_sql.open_cursor;
192: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
193: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
194: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
195:
196: End Loop;

Line 193: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

189: ' AND rownum < '||(row_limit/25);
190:
191: ln_cursor := dbms_sql.open_cursor;
192: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
193: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
194: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
195:
196: End Loop;
197:

Line 194: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

190:
191: ln_cursor := dbms_sql.open_cursor;
192: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
193: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
194: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
195:
196: End Loop;
197:
198: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 273: ln_cursor := dbms_sql.open_cursor;

269: ' AND rownum < '||(row_limit/25);
270:
271: End If;
272:
273: ln_cursor := dbms_sql.open_cursor;
274: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
275: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
276: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
277:

Line 274: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

270:
271: End If;
272:
273: ln_cursor := dbms_sql.open_cursor;
274: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
275: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
276: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
277:
278: End If; /* l_varchar_col_rec.column_name) IN ('DESCRIPTION','LONG_DESCRIPTION') */

Line 275: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

271: End If;
272:
273: ln_cursor := dbms_sql.open_cursor;
274: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
275: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
276: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
277:
278: End If; /* l_varchar_col_rec.column_name) IN ('DESCRIPTION','LONG_DESCRIPTION') */
279: End Loop;

Line 276: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

272:
273: ln_cursor := dbms_sql.open_cursor;
274: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
275: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
276: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
277:
278: End If; /* l_varchar_col_rec.column_name) IN ('DESCRIPTION','LONG_DESCRIPTION') */
279: End Loop;
280:

Line 323: ln_cursor := dbms_sql.open_cursor;

319: ' AND mirb.inventory_item_id ='||l_item_id||' '||
320: ' AND mirb.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
321: ' AND rownum < '||(row_limit/25);
322:
323: ln_cursor := dbms_sql.open_cursor;
324: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
325: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
326: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
327:

Line 324: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

320: ' AND mirb.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
321: ' AND rownum < '||(row_limit/25);
322:
323: ln_cursor := dbms_sql.open_cursor;
324: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
325: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
326: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
327:
328: End Loop;

Line 325: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

321: ' AND rownum < '||(row_limit/25);
322:
323: ln_cursor := dbms_sql.open_cursor;
324: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
325: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
326: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
327:
328: End Loop;
329:

Line 326: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

322:
323: ln_cursor := dbms_sql.open_cursor;
324: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
325: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
326: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
327:
328: End Loop;
329:
330: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 372: ln_cursor := dbms_sql.open_cursor;

368: ' AND mirtl.inventory_item_id ='||l_item_id||' '||
369: ' AND mirtl.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
370: ' AND rownum < '||(row_limit/25);
371:
372: ln_cursor := dbms_sql.open_cursor;
373: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
374: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
375: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
376:

Line 373: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

369: ' AND mirtl.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
370: ' AND rownum < '||(row_limit/25);
371:
372: ln_cursor := dbms_sql.open_cursor;
373: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
374: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
375: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
376:
377: End Loop;

Line 374: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

370: ' AND rownum < '||(row_limit/25);
371:
372: ln_cursor := dbms_sql.open_cursor;
373: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
374: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
375: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
376:
377: End Loop;
378:

Line 375: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

371:
372: ln_cursor := dbms_sql.open_cursor;
373: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
374: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
375: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
376:
377: End Loop;
378:
379: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 419: ln_cursor := dbms_sql.open_cursor;

415: ' WHERE mdev.inventory_item_id ='||l_item_id||' '||
416: ' AND mdev.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
417: ' AND rownum < '||(row_limit/25);
418:
419: ln_cursor := dbms_sql.open_cursor;
420: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
421: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
422: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
423:

Line 420: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

416: ' AND mdev.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
417: ' AND rownum < '||(row_limit/25);
418:
419: ln_cursor := dbms_sql.open_cursor;
420: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
421: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
422: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
423:
424: End Loop;

Line 421: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

417: ' AND rownum < '||(row_limit/25);
418:
419: ln_cursor := dbms_sql.open_cursor;
420: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
421: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
422: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
423:
424: End Loop;
425:

Line 422: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

418:
419: ln_cursor := dbms_sql.open_cursor;
420: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
421: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
422: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
423:
424: End Loop;
425:
426: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 466: ln_cursor := dbms_sql.open_cursor;

462: ' AND mpis.organization_id = '||l_org_id||' '||
463: ' AND mpis.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
464: ' AND rownum < '||(row_limit/25);
465:
466: ln_cursor := dbms_sql.open_cursor;
467: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
468: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
469: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
470:

Line 467: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

463: ' AND mpis.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
464: ' AND rownum < '||(row_limit/25);
465:
466: ln_cursor := dbms_sql.open_cursor;
467: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
468: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
469: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
470:
471: End Loop;

Line 468: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

464: ' AND rownum < '||(row_limit/25);
465:
466: ln_cursor := dbms_sql.open_cursor;
467: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
468: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
469: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
470:
471: End Loop;
472:

Line 469: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

465:
466: ln_cursor := dbms_sql.open_cursor;
467: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
468: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
469: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
470:
471: End Loop;
472:
473: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 516: ln_cursor := dbms_sql.open_cursor;

512: ' or ( mcr.organization_id is null and org_independent_flag=''Y'') ) '||
513: ' AND mcr.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
514: ' AND rownum < '||(row_limit/25);
515:
516: ln_cursor := dbms_sql.open_cursor;
517: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
518: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
519: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
520:

Line 517: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

513: ' AND mcr.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
514: ' AND rownum < '||(row_limit/25);
515:
516: ln_cursor := dbms_sql.open_cursor;
517: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
518: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
519: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
520:
521: End Loop;

Line 518: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

514: ' AND rownum < '||(row_limit/25);
515:
516: ln_cursor := dbms_sql.open_cursor;
517: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
518: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
519: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
520:
521: End Loop;
522:

Line 519: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

515:
516: ln_cursor := dbms_sql.open_cursor;
517: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
518: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
519: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
520:
521: End Loop;
522:
523: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 564: ln_cursor := dbms_sql.open_cursor;

560: ' AND mcrb.cross_reference_id = mcrt.cross_reference_id '||
561: ' AND mcrt.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
562: ' AND rownum < '||(row_limit/25);
563:
564: ln_cursor := dbms_sql.open_cursor;
565: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
566: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
567: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
568:

Line 565: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

561: ' AND mcrt.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
562: ' AND rownum < '||(row_limit/25);
563:
564: ln_cursor := dbms_sql.open_cursor;
565: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
566: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
567: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
568:
569: End Loop;

Line 566: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

562: ' AND rownum < '||(row_limit/25);
563:
564: ln_cursor := dbms_sql.open_cursor;
565: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
566: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
567: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
568:
569: End Loop;
570:

Line 567: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

563:
564: ln_cursor := dbms_sql.open_cursor;
565: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
566: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
567: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
568:
569: End Loop;
570:
571: sqltxt:=' Select num_col1 "Cross Reference Id", '||

Line 611: ln_cursor := dbms_sql.open_cursor;

607: ' where organization_id= '||l_org_id||' ) '||
608: ' AND mcix.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
609: ' AND rownum < '||(row_limit/25);
610:
611: ln_cursor := dbms_sql.open_cursor;
612: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
613: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
614: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
615:

Line 612: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

608: ' AND mcix.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
609: ' AND rownum < '||(row_limit/25);
610:
611: ln_cursor := dbms_sql.open_cursor;
612: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
613: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
614: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
615:
616: End Loop;

Line 613: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

609: ' AND rownum < '||(row_limit/25);
610:
611: ln_cursor := dbms_sql.open_cursor;
612: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
613: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
614: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
615:
616: End Loop;
617:

Line 614: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

610:
611: ln_cursor := dbms_sql.open_cursor;
612: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
613: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
614: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
615:
616: End Loop;
617:
618: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 660: ln_cursor := dbms_sql.open_cursor;

656: ' where organization_id= '||l_org_id||' ) '||
657: ' AND mmpn.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
658: ' AND rownum < '||(row_limit/25);
659:
660: ln_cursor := dbms_sql.open_cursor;
661: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
662: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
663: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
664:

Line 661: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

657: ' AND mmpn.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
658: ' AND rownum < '||(row_limit/25);
659:
660: ln_cursor := dbms_sql.open_cursor;
661: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
662: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
663: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
664:
665: End Loop;

Line 662: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

658: ' AND rownum < '||(row_limit/25);
659:
660: ln_cursor := dbms_sql.open_cursor;
661: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
662: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
663: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
664:
665: End Loop;
666:

Line 663: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

659:
660: ln_cursor := dbms_sql.open_cursor;
661: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
662: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
663: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
664:
665: End Loop;
666:
667: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 707: ln_cursor := dbms_sql.open_cursor;

703: ' AND mrir.inventory_item_id ='||l_item_id||' '||
704: ' AND mrir.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
705: ' AND rownum < '||(row_limit/25);
706:
707: ln_cursor := dbms_sql.open_cursor;
708: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
709: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
710: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
711:

Line 708: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

704: ' AND mrir.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
705: ' AND rownum < '||(row_limit/25);
706:
707: ln_cursor := dbms_sql.open_cursor;
708: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
709: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
710: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
711:
712: End Loop;

Line 709: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

705: ' AND rownum < '||(row_limit/25);
706:
707: ln_cursor := dbms_sql.open_cursor;
708: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
709: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
710: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
711:
712: End Loop;
713:

Line 710: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

706:
707: ln_cursor := dbms_sql.open_cursor;
708: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
709: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
710: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
711:
712: End Loop;
713:
714: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 757: ln_cursor := dbms_sql.open_cursor;

753: ' where organization_id= '||l_org_id||' ) '||
754: ' AND mri.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
755: ' AND rownum < '||(row_limit/25);
756:
757: ln_cursor := dbms_sql.open_cursor;
758: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
759: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
760: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
761:

Line 758: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

754: ' AND mri.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
755: ' AND rownum < '||(row_limit/25);
756:
757: ln_cursor := dbms_sql.open_cursor;
758: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
759: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
760: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
761:
762: End Loop;

Line 759: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

755: ' AND rownum < '||(row_limit/25);
756:
757: ln_cursor := dbms_sql.open_cursor;
758: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
759: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
760: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
761:
762: End Loop;
763:

Line 760: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

756:
757: ln_cursor := dbms_sql.open_cursor;
758: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
759: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
760: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
761:
762: End Loop;
763:
764: sqltxt:=' Select Inventory_Item_Id "Inventory Item Id", '||

Line 822: ln_cursor := dbms_sql.open_cursor;

818: ' AND bsb.organization_id = '||l_org_id||' '||
819: ' AND bsb.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
820: ' AND rownum < '||(row_limit/25);
821:
822: ln_cursor := dbms_sql.open_cursor;
823: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
824: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
825: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
826:

Line 823: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

819: ' AND bsb.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
820: ' AND rownum < '||(row_limit/25);
821:
822: ln_cursor := dbms_sql.open_cursor;
823: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
824: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
825: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
826:
827: End Loop;

Line 824: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

820: ' AND rownum < '||(row_limit/25);
821:
822: ln_cursor := dbms_sql.open_cursor;
823: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
824: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
825: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
826:
827: End Loop;
828:

Line 825: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

821:
822: ln_cursor := dbms_sql.open_cursor;
823: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
824: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
825: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
826:
827: End Loop;
828:
829: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 875: ln_cursor := dbms_sql.open_cursor;

871: ' AND bsb.organization_id = '||l_org_id||' '||
872: ' AND bcb.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
873: ' AND rownum < '||(row_limit/25);
874:
875: ln_cursor := dbms_sql.open_cursor;
876: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
877: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
878: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
879:

Line 876: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

872: ' AND bcb.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
873: ' AND rownum < '||(row_limit/25);
874:
875: ln_cursor := dbms_sql.open_cursor;
876: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
877: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
878: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
879:
880: End Loop;

Line 877: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

873: ' AND rownum < '||(row_limit/25);
874:
875: ln_cursor := dbms_sql.open_cursor;
876: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
877: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
878: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
879:
880: End Loop;
881:

Line 878: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

874:
875: ln_cursor := dbms_sql.open_cursor;
876: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
877: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
878: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
879:
880: End Loop;
881:
882: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 931: ln_cursor := dbms_sql.open_cursor;

927: ' AND bsb.organization_id = '||l_org_id||' '||
928: ' AND brd.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
929: ' AND rownum < '||(row_limit/25);
930:
931: ln_cursor := dbms_sql.open_cursor;
932: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
933: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
934: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
935:

Line 932: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

928: ' AND brd.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
929: ' AND rownum < '||(row_limit/25);
930:
931: ln_cursor := dbms_sql.open_cursor;
932: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
933: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
934: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
935:
936: End Loop;

Line 933: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

929: ' AND rownum < '||(row_limit/25);
930:
931: ln_cursor := dbms_sql.open_cursor;
932: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
933: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
934: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
935:
936: End Loop;
937:

Line 934: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

930:
931: ln_cursor := dbms_sql.open_cursor;
932: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
933: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
934: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
935:
936: End Loop;
937:
938: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 986: ln_cursor := dbms_sql.open_cursor;

982: ' AND bsb.organization_id = '||l_org_id||' '||
983: ' AND bsc.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
984: ' AND rownum < '||(row_limit/25);
985:
986: ln_cursor := dbms_sql.open_cursor;
987: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
988: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
989: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
990:

Line 987: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

983: ' AND bsc.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
984: ' AND rownum < '||(row_limit/25);
985:
986: ln_cursor := dbms_sql.open_cursor;
987: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
988: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
989: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
990:
991: End Loop;

Line 988: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

984: ' AND rownum < '||(row_limit/25);
985:
986: ln_cursor := dbms_sql.open_cursor;
987: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
988: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
989: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
990:
991: End Loop;
992:

Line 989: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

985:
986: ln_cursor := dbms_sql.open_cursor;
987: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
988: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
989: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
990:
991: End Loop;
992:
993: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 1041: ln_cursor := dbms_sql.open_cursor;

1037: ' AND bor.organization_id = '||l_org_id||' '||
1038: ' AND bor.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1039: ' AND rownum < '||(row_limit/25);
1040:
1041: ln_cursor := dbms_sql.open_cursor;
1042: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1043: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1044: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1045:

Line 1042: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

1038: ' AND bor.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1039: ' AND rownum < '||(row_limit/25);
1040:
1041: ln_cursor := dbms_sql.open_cursor;
1042: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1043: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1044: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1045:
1046: End Loop;

Line 1043: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

1039: ' AND rownum < '||(row_limit/25);
1040:
1041: ln_cursor := dbms_sql.open_cursor;
1042: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1043: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1044: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1045:
1046: End Loop;
1047:

Line 1044: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

1040:
1041: ln_cursor := dbms_sql.open_cursor;
1042: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1043: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1044: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1045:
1046: End Loop;
1047:
1048: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 1092: ln_cursor := dbms_sql.open_cursor;

1088: ' AND bor.organization_id = '||l_org_id||' '||
1089: ' AND bos.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1090: ' AND rownum < '||(row_limit/25);
1091:
1092: ln_cursor := dbms_sql.open_cursor;
1093: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1094: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1095: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1096:

Line 1093: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

1089: ' AND bos.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1090: ' AND rownum < '||(row_limit/25);
1091:
1092: ln_cursor := dbms_sql.open_cursor;
1093: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1094: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1095: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1096:
1097: End Loop;

Line 1094: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

1090: ' AND rownum < '||(row_limit/25);
1091:
1092: ln_cursor := dbms_sql.open_cursor;
1093: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1094: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1095: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1096:
1097: End Loop;
1098:

Line 1095: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

1091:
1092: ln_cursor := dbms_sql.open_cursor;
1093: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1094: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1095: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1096:
1097: End Loop;
1098:
1099: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 1148: ln_cursor := dbms_sql.open_cursor;

1144: ' AND bor.organization_id = '||l_org_id||' '||
1145: ' AND bore.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1146: ' AND rownum < '||(row_limit/25);
1147:
1148: ln_cursor := dbms_sql.open_cursor;
1149: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1150: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1151: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1152:

Line 1149: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

1145: ' AND bore.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1146: ' AND rownum < '||(row_limit/25);
1147:
1148: ln_cursor := dbms_sql.open_cursor;
1149: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1150: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1151: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1152:
1153: End Loop;

Line 1150: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

1146: ' AND rownum < '||(row_limit/25);
1147:
1148: ln_cursor := dbms_sql.open_cursor;
1149: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1150: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1151: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1152:
1153: End Loop;
1154:

Line 1151: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

1147:
1148: ln_cursor := dbms_sql.open_cursor;
1149: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1150: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1151: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1152:
1153: End Loop;
1154:
1155: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 1208: ln_cursor := dbms_sql.open_cursor;

1204: ' AND bor.organization_id = '||l_org_id||' '||
1205: ' AND bsor.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1206: ' AND rownum < '||(row_limit/25);
1207:
1208: ln_cursor := dbms_sql.open_cursor;
1209: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1210: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1211: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1212:

Line 1209: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

1205: ' AND bsor.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1206: ' AND rownum < '||(row_limit/25);
1207:
1208: ln_cursor := dbms_sql.open_cursor;
1209: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1210: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1211: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1212:
1213: End Loop;

Line 1210: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

1206: ' AND rownum < '||(row_limit/25);
1207:
1208: ln_cursor := dbms_sql.open_cursor;
1209: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1210: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1211: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1212:
1213: End Loop;
1214:

Line 1211: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

1207:
1208: ln_cursor := dbms_sql.open_cursor;
1209: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1210: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1211: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1212:
1213: End Loop;
1214:
1215: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||

Line 1269: ln_cursor := dbms_sql.open_cursor;

1265: ' AND bor.organization_id = '||l_org_id||' '||
1266: ' AND bon.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1267: ' AND rownum < '||(row_limit/25);
1268:
1269: ln_cursor := dbms_sql.open_cursor;
1270: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1271: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1272: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1273:

Line 1270: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

1266: ' AND bon.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
1267: ' AND rownum < '||(row_limit/25);
1268:
1269: ln_cursor := dbms_sql.open_cursor;
1270: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1271: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1272: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1273:
1274: End Loop;

Line 1271: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

1267: ' AND rownum < '||(row_limit/25);
1268:
1269: ln_cursor := dbms_sql.open_cursor;
1270: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1271: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1272: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1273:
1274: End Loop;
1275:

Line 1272: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

1268:
1269: ln_cursor := dbms_sql.open_cursor;
1270: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
1271: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
1272: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
1273:
1274: End Loop;
1275:
1276: sqltxt:=' Select Inventory_Item_Id "Assembly Item Id", '||