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

Line 272: h_cursor := dbms_sql.open_cursor;

268: fa_debug_pkg.add('FAXGFR','+++ stmt:', h_formula, p_log_level_rec);
269: end if;
270:
271: -- Open the cursor for processing.
272: h_cursor := dbms_sql.open_cursor;
273:
274: -- Parse the query.
275: dbms_sql.parse(h_cursor,h_formula,1);
276:

Line 275: dbms_sql.parse(h_cursor,h_formula,1);

271: -- Open the cursor for processing.
272: h_cursor := dbms_sql.open_cursor;
273:
274: -- Parse the query.
275: dbms_sql.parse(h_cursor,h_formula,1);
276:
277: -- Bind X_asset_id to the placeholder.
278: dbms_sql.bind_variable (h_cursor, ':v1', X_Asset_ID);
279: dbms_sql.bind_variable (h_cursor, ':v2', X_Book_Type_Code);

Line 278: dbms_sql.bind_variable (h_cursor, ':v1', X_Asset_ID);

274: -- Parse the query.
275: dbms_sql.parse(h_cursor,h_formula,1);
276:
277: -- Bind X_asset_id to the placeholder.
278: dbms_sql.bind_variable (h_cursor, ':v1', X_Asset_ID);
279: dbms_sql.bind_variable (h_cursor, ':v2', X_Book_Type_Code);
280:
281: -- Define the output variable, rate.
282: dbms_sql.define_column (h_cursor, 1, X_Rate);

Line 279: dbms_sql.bind_variable (h_cursor, ':v2', X_Book_Type_Code);

275: dbms_sql.parse(h_cursor,h_formula,1);
276:
277: -- Bind X_asset_id to the placeholder.
278: dbms_sql.bind_variable (h_cursor, ':v1', X_Asset_ID);
279: dbms_sql.bind_variable (h_cursor, ':v2', X_Book_Type_Code);
280:
281: -- Define the output variable, rate.
282: dbms_sql.define_column (h_cursor, 1, X_Rate);
283:

Line 282: dbms_sql.define_column (h_cursor, 1, X_Rate);

278: dbms_sql.bind_variable (h_cursor, ':v1', X_Asset_ID);
279: dbms_sql.bind_variable (h_cursor, ':v2', X_Book_Type_Code);
280:
281: -- Define the output variable, rate.
282: dbms_sql.define_column (h_cursor, 1, X_Rate);
283:
284: -- Execute the statement. We don't care about the
285: -- return value, but we do need to declare a variable
286: -- for it.

Line 287: h_return_code := dbms_sql.execute(h_cursor);

283:
284: -- Execute the statement. We don't care about the
285: -- return value, but we do need to declare a variable
286: -- for it.
287: h_return_code := dbms_sql.execute(h_cursor);
288:
289: -- This is the fetch loop.
290: loop
291: if dbms_sql.fetch_rows (h_cursor) = 0 then

Line 291: if dbms_sql.fetch_rows (h_cursor) = 0 then

287: h_return_code := dbms_sql.execute(h_cursor);
288:
289: -- This is the fetch loop.
290: loop
291: if dbms_sql.fetch_rows (h_cursor) = 0 then
292: exit;
293: end if;
294:
295: dbms_sql.column_value (h_cursor, 1, X_rate);

Line 295: dbms_sql.column_value (h_cursor, 1, X_rate);

291: if dbms_sql.fetch_rows (h_cursor) = 0 then
292: exit;
293: end if;
294:
295: dbms_sql.column_value (h_cursor, 1, X_rate);
296: end loop;
297:
298: -- Close the cursor.
299: dbms_sql.close_cursor (h_cursor);

Line 299: dbms_sql.close_cursor (h_cursor);

295: dbms_sql.column_value (h_cursor, 1, X_rate);
296: end loop;
297:
298: -- Close the cursor.
299: dbms_sql.close_cursor (h_cursor);
300:
301: -- Fix for Bug #2421998. For a formula that uses remaining life, we
302: -- need to take this into account so that the depreciation is allocated
303: -- correctly in the last year of its life. For example, if there are