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 190: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 193: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 272: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 275: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 322: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 325: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 371: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 374: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 418: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 421: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 465: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 468: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 515: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 518: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 563: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 566: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 610: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 613: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 659: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 662: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 706: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 709: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 756: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 759: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 821: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 824: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 874: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 877: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 930: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 933: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 985: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 988: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 1040: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 1043: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 1091: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 1094: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 1147: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 1150: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 1207: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 1210: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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

Line 1268: ln_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 1271: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

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