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 4795: l_cursor_id := DBMS_SQL.open_cursor;

4791: 'Select '
4792: || l_sel_column
4793: || ' From Mtl_system_items_b
4794: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4795: l_cursor_id := DBMS_SQL.open_cursor;
4796: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4797: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4798: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);

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

4792: || l_sel_column
4793: || ' From Mtl_system_items_b
4794: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4795: l_cursor_id := DBMS_SQL.open_cursor;
4796: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4797: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4798: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4800: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);

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

4793: || ' From Mtl_system_items_b
4794: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4795: l_cursor_id := DBMS_SQL.open_cursor;
4796: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4797: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4798: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4800: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4801:

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

4794: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4795: l_cursor_id := DBMS_SQL.open_cursor;
4796: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4797: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4798: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4800: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4801:
4802: LOOP

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

4795: l_cursor_id := DBMS_SQL.open_cursor;
4796: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4797: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4798: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4800: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4801:
4802: LOOP
4803: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0

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

4796: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4797: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4798: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4800: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4801:
4802: LOOP
4803: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4804: THEN

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

4799: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4800: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4801:
4802: LOOP
4803: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4804: THEN
4805: EXIT;
4806: END IF;
4807:

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

4804: THEN
4805: EXIT;
4806: END IF;
4807:
4808: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4809: END LOOP;
4810:
4811: DBMS_SQL.close_cursor (l_cursor_id);
4812: --Dbms_Output.Put_Line('Name: ' || l_name);

Line 4811: DBMS_SQL.close_cursor (l_cursor_id);

4807:
4808: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4809: END LOOP;
4810:
4811: DBMS_SQL.close_cursor (l_cursor_id);
4812: --Dbms_Output.Put_Line('Name: ' || l_name);
4813: RETURN (l_name);
4814: EXCEPTION
4815: WHEN OTHERS

Line 4916: l_cursor_id := DBMS_SQL.open_cursor;

4912: || l_sel_column
4913: || ' ,Description '
4914: || ' From Mtl_system_items_b
4915: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4916: l_cursor_id := DBMS_SQL.open_cursor;
4917: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);

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

4913: || ' ,Description '
4914: || ' From Mtl_system_items_b
4915: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4916: l_cursor_id := DBMS_SQL.open_cursor;
4917: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);

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

4914: || ' From Mtl_system_items_b
4915: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4916: l_cursor_id := DBMS_SQL.open_cursor;
4917: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4922: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);

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

4915: Where Inventory_item_id = :d1 And Organization_id = :d2 ';
4916: l_cursor_id := DBMS_SQL.open_cursor;
4917: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4922: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4923:

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

4916: l_cursor_id := DBMS_SQL.open_cursor;
4917: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4922: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4923:
4924: LOOP

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

4917: DBMS_SQL.parse (l_cursor_id, l_select_stmt, DBMS_SQL.native);
4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4922: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4923:
4924: LOOP
4925: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0

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

4918: DBMS_SQL.bind_variable (l_cursor_id, ':d1', p_inventory_item_id);
4919: DBMS_SQL.bind_variable (l_cursor_id, ':d2', p_organization_id);
4920: l_exe_count := DBMS_SQL.EXECUTE (l_cursor_id);
4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4922: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4923:
4924: LOOP
4925: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4926: THEN

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

4921: DBMS_SQL.define_column (l_cursor_id, 1, l_name, 200);
4922: DBMS_SQL.define_column (l_cursor_id, 2, l_desc, 500);
4923:
4924: LOOP
4925: IF DBMS_SQL.fetch_rows (l_cursor_id) = 0
4926: THEN
4927: EXIT;
4928: END IF;
4929:

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

4926: THEN
4927: EXIT;
4928: END IF;
4929:
4930: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4931: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);
4932: END LOOP;
4933:
4934: DBMS_SQL.close_cursor (l_cursor_id);

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

4927: EXIT;
4928: END IF;
4929:
4930: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4931: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);
4932: END LOOP;
4933:
4934: DBMS_SQL.close_cursor (l_cursor_id);
4935: --Dbms_Output.Put_Line('Name: ' || l_name);

Line 4934: DBMS_SQL.close_cursor (l_cursor_id);

4930: DBMS_SQL.column_value (l_cursor_id, 1, l_name);
4931: DBMS_SQL.column_value (l_cursor_id, 2, l_desc);
4932: END LOOP;
4933:
4934: DBMS_SQL.close_cursor (l_cursor_id);
4935: --Dbms_Output.Put_Line('Name: ' || l_name);
4936: --Dbms_Output.Put_Line('Description: ' || l_desc);
4937: --RETURN(l_name);
4938: x_name := l_name;