APPS.AP_WEB_CUST_AME_PKG dependencies on DBMS_SQL

Line 385: l_cur_hdl := dbms_sql.open_cursor;

381: BEGIN
382: -----------------------------------------------------
383: l_debug_info := 'open the cursor for processing';
384: -----------------------------------------------------
385: l_cur_hdl := dbms_sql.open_cursor;
386:
387: -----------------------------------------------------
388: l_debug_info := 'Get the Column Name which implements the Cost Center Segment';
389: -----------------------------------------------------

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

430:
431: -----------------------------------------------------
432: l_debug_info := 'parse cursor';
433: -----------------------------------------------------
434: dbms_sql.parse(l_cur_hdl, l_query_stmt,dbms_sql.native);
435:
436: -----------------------------------------------------
437: l_debug_info := 'bind values to the placeholder';
438: -----------------------------------------------------

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

435:
436: -----------------------------------------------------
437: l_debug_info := 'bind values to the placeholder';
438: -----------------------------------------------------
439: dbms_sql.bind_variable(l_cur_hdl, ':costCenter', p_cost_center);
440: dbms_sql.bind_variable(l_cur_hdl, ':charOfAccountsId', l_char_of_accounts_id);
441:
442: -----------------------------------------------------
443: l_debug_info := 'setup output';

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

436: -----------------------------------------------------
437: l_debug_info := 'bind values to the placeholder';
438: -----------------------------------------------------
439: dbms_sql.bind_variable(l_cur_hdl, ':costCenter', p_cost_center);
440: dbms_sql.bind_variable(l_cur_hdl, ':charOfAccountsId', l_char_of_accounts_id);
441:
442: -----------------------------------------------------
443: l_debug_info := 'setup output';
444: -----------------------------------------------------

Line 445: dbms_sql.define_column(l_cur_hdl, 1, l_cc_business_mgr_id, 150);

441:
442: -----------------------------------------------------
443: l_debug_info := 'setup output';
444: -----------------------------------------------------
445: dbms_sql.define_column(l_cur_hdl, 1, l_cc_business_mgr_id, 150);
446:
447: -----------------------------------------------------
448: l_debug_info := 'execute cursor';
449: -----------------------------------------------------

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

446:
447: -----------------------------------------------------
448: l_debug_info := 'execute cursor';
449: -----------------------------------------------------
450: l_rows_processed := dbms_sql.execute(l_cur_hdl);
451:
452: -----------------------------------------------------
453: l_debug_info := 'fetch a row';
454: -----------------------------------------------------

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

451:
452: -----------------------------------------------------
453: l_debug_info := 'fetch a row';
454: -----------------------------------------------------
455: IF dbms_sql.fetch_rows(l_cur_hdl) > 0 then
456: -- fetch columns from the row
457: dbms_sql.column_value(l_cur_hdl, 1, l_cc_business_mgr_id);
458: END IF;
459:

Line 457: dbms_sql.column_value(l_cur_hdl, 1, l_cc_business_mgr_id);

453: l_debug_info := 'fetch a row';
454: -----------------------------------------------------
455: IF dbms_sql.fetch_rows(l_cur_hdl) > 0 then
456: -- fetch columns from the row
457: dbms_sql.column_value(l_cur_hdl, 1, l_cc_business_mgr_id);
458: END IF;
459:
460: -----------------------------------------------------
461: l_debug_info := 'close cursor';

Line 463: dbms_sql.close_cursor(l_cur_hdl);

459:
460: -----------------------------------------------------
461: l_debug_info := 'close cursor';
462: -----------------------------------------------------
463: dbms_sql.close_cursor(l_cur_hdl);
464:
465:
466: END IF;
467: