APPS.AP_WEB_AME_PKG dependencies on DBMS_SQL

Line 300: l_cur_hdl := dbms_sql.open_cursor;

296:
297: -----------------------------------------------------
298: l_debug_info := 'open cursor';
299: -----------------------------------------------------
300: l_cur_hdl := dbms_sql.open_cursor;
301:
302: -----------------------------------------------------
303: l_debug_info := 'set query statement';
304: -----------------------------------------------------

Line 325: dbms_sql.parse(l_cur_hdl, l_query_stmt,dbms_sql.native);

321:
322: -----------------------------------------------------
323: l_debug_info := 'parse cursor';
324: -----------------------------------------------------
325: dbms_sql.parse(l_cur_hdl, l_query_stmt,dbms_sql.native);
326:
327: -----------------------------------------------------
328: l_debug_info := 'bind values to the placeholder';
329: -----------------------------------------------------

Line 330: dbms_sql.bind_variable(l_cur_hdl, ':costCenter', p_cost_center);

326:
327: -----------------------------------------------------
328: l_debug_info := 'bind values to the placeholder';
329: -----------------------------------------------------
330: dbms_sql.bind_variable(l_cur_hdl, ':costCenter', p_cost_center);
331: -- Bug: 7558034dbms_sql.bind_variable(l_cur_hdl, ':reportHeaderId', p_report_header_id);
332: dbms_sql.bind_variable(l_cur_hdl, ':charOfAccountsId', l_char_of_accounts_id);
333:
334: -----------------------------------------------------

Line 331: -- Bug: 7558034dbms_sql.bind_variable(l_cur_hdl, ':reportHeaderId', p_report_header_id);

327: -----------------------------------------------------
328: l_debug_info := 'bind values to the placeholder';
329: -----------------------------------------------------
330: dbms_sql.bind_variable(l_cur_hdl, ':costCenter', p_cost_center);
331: -- Bug: 7558034dbms_sql.bind_variable(l_cur_hdl, ':reportHeaderId', p_report_header_id);
332: dbms_sql.bind_variable(l_cur_hdl, ':charOfAccountsId', l_char_of_accounts_id);
333:
334: -----------------------------------------------------
335: l_debug_info := 'setup output';

Line 332: dbms_sql.bind_variable(l_cur_hdl, ':charOfAccountsId', l_char_of_accounts_id);

328: l_debug_info := 'bind values to the placeholder';
329: -----------------------------------------------------
330: dbms_sql.bind_variable(l_cur_hdl, ':costCenter', p_cost_center);
331: -- Bug: 7558034dbms_sql.bind_variable(l_cur_hdl, ':reportHeaderId', p_report_header_id);
332: dbms_sql.bind_variable(l_cur_hdl, ':charOfAccountsId', l_char_of_accounts_id);
333:
334: -----------------------------------------------------
335: l_debug_info := 'setup output';
336: -----------------------------------------------------

Line 337: dbms_sql.define_column(l_cur_hdl, 1, l_cc_owner_id, 150);

333:
334: -----------------------------------------------------
335: l_debug_info := 'setup output';
336: -----------------------------------------------------
337: dbms_sql.define_column(l_cur_hdl, 1, l_cc_owner_id, 150);
338:
339: -----------------------------------------------------
340: l_debug_info := 'execute cursor';
341: -----------------------------------------------------

Line 342: l_rows_processed := dbms_sql.execute(l_cur_hdl);

338:
339: -----------------------------------------------------
340: l_debug_info := 'execute cursor';
341: -----------------------------------------------------
342: l_rows_processed := dbms_sql.execute(l_cur_hdl);
343:
344: -----------------------------------------------------
345: l_debug_info := 'fetch a row';
346: -----------------------------------------------------

Line 347: IF dbms_sql.fetch_rows(l_cur_hdl) > 0 then

343:
344: -----------------------------------------------------
345: l_debug_info := 'fetch a row';
346: -----------------------------------------------------
347: IF dbms_sql.fetch_rows(l_cur_hdl) > 0 then
348: -- fetch columns from the row
349: dbms_sql.column_value(l_cur_hdl, 1, l_cc_owner_id);
350: END IF;
351:

Line 349: dbms_sql.column_value(l_cur_hdl, 1, l_cc_owner_id);

345: l_debug_info := 'fetch a row';
346: -----------------------------------------------------
347: IF dbms_sql.fetch_rows(l_cur_hdl) > 0 then
348: -- fetch columns from the row
349: dbms_sql.column_value(l_cur_hdl, 1, l_cc_owner_id);
350: END IF;
351:
352: -----------------------------------------------------
353: l_debug_info := 'close cursor';

Line 355: dbms_sql.close_cursor(l_cur_hdl);

351:
352: -----------------------------------------------------
353: l_debug_info := 'close cursor';
354: -----------------------------------------------------
355: dbms_sql.close_cursor(l_cur_hdl);
356:
357: END IF;
358:
359: return l_cc_owner_id;