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

Line 4749: l_cursor_id := DBMS_SQL.open_cursor;

4745: 'Select '
4746: || l_sel_column
4747: || ' From Mtl_system_items_b
4748: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4749: l_cursor_id := DBMS_SQL.open_cursor;
4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);

Line 4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);

4746: || l_sel_column
4747: || ' From Mtl_system_items_b
4748: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4749: l_cursor_id := DBMS_SQL.open_cursor;
4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);

Line 4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);

4747: || ' From Mtl_system_items_b
4748: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4749: l_cursor_id := DBMS_SQL.open_cursor;
4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4755:

Line 4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);

4748: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4749: l_cursor_id := DBMS_SQL.open_cursor;
4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4755:
4756: LOOP

Line 4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);

4749: l_cursor_id := DBMS_SQL.open_cursor;
4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4755:
4756: LOOP
4757: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0

Line 4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);

4750: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4751: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4752: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4755:
4756: LOOP
4757: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4758: THEN

Line 4757: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0

4753: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4754: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4755:
4756: LOOP
4757: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4758: THEN
4759: EXIT;
4760: END IF;
4761:

Line 4762: DBMS_SQL.column_value (l_cursor_id, 1, l_name);

4758: THEN
4759: EXIT;
4760: END IF;
4761:
4762: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4763: END LOOP;
4764:
4765: DBMS_SQL.close_cursor (l_cursor_id);
4766: --Dbms_Output.Put_Line('Name: ' || l_name);

Line 4765: DBMS_SQL.close_cursor (l_cursor_id);

4761:
4762: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4763: END LOOP;
4764:
4765: DBMS_SQL.close_cursor (l_cursor_id);
4766: --Dbms_Output.Put_Line('Name: ' || l_name);
4767: RETURN (l_name);
4768: EXCEPTION
4769: WHEN OTHERS

Line 4870: l_cursor_id := DBMS_SQL.open_cursor;

4866: || l_sel_column
4867: || ' ,Description '
4868: || ' From Mtl_system_items_b
4869: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4870: l_cursor_id := DBMS_SQL.open_cursor;
4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);

Line 4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);

4867: || ' ,Description '
4868: || ' From Mtl_system_items_b
4869: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4870: l_cursor_id := DBMS_SQL.open_cursor;
4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);

Line 4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);

4868: || ' From Mtl_system_items_b
4869: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4870: l_cursor_id := DBMS_SQL.open_cursor;
4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);

Line 4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);

4869: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4870: l_cursor_id := DBMS_SQL.open_cursor;
4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4877:

Line 4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);

4870: l_cursor_id := DBMS_SQL.open_cursor;
4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4877:
4878: LOOP

Line 4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);

4871: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4877:
4878: LOOP
4879: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0

Line 4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);

4872: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4873: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4874: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4877:
4878: LOOP
4879: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4880: THEN

Line 4879: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0

4875: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4876: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4877:
4878: LOOP
4879: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4880: THEN
4881: EXIT;
4882: END IF;
4883:

Line 4884: DBMS_SQL.column_value (l_cursor_id, 1, l_name);

4880: THEN
4881: EXIT;
4882: END IF;
4883:
4884: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4885: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);
4886: END LOOP;
4887:
4888: DBMS_SQL.close_cursor (l_cursor_id);

Line 4885: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);

4881: EXIT;
4882: END IF;
4883:
4884: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4885: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);
4886: END LOOP;
4887:
4888: DBMS_SQL.close_cursor (l_cursor_id);
4889: --Dbms_Output.Put_Line('Name: ' || l_name);

Line 4888: DBMS_SQL.close_cursor (l_cursor_id);

4884: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4885: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);
4886: END LOOP;
4887:
4888: DBMS_SQL.close_cursor (l_cursor_id);
4889: --Dbms_Output.Put_Line('Name: ' || l_name);
4890: --Dbms_Output.Put_Line('Description: ' || l_desc);
4891: --RETURN(l_name);
4892: x_name := l_name;