APPS.INV_MWB_QUERY_MANAGER dependencies on DBMS_SQL

Line 410: l_cursor_handle := dbms_sql.open_cursor;

406: insert into rtest1 values(l_query_str);
407: commit;
408: */
409:
410: l_cursor_handle := dbms_sql.open_cursor;
411: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);
412: bind_query(l_cursor_handle);
413:
414: l_rows_affected := dbms_sql.execute(l_cursor_handle);

Line 411: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);

407: commit;
408: */
409:
410: l_cursor_handle := dbms_sql.open_cursor;
411: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);
412: bind_query(l_cursor_handle);
413:
414: l_rows_affected := dbms_sql.execute(l_cursor_handle);
415: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Rows created' ||l_rows_affected);

Line 414: l_rows_affected := dbms_sql.execute(l_cursor_handle);

410: l_cursor_handle := dbms_sql.open_cursor;
411: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);
412: bind_query(l_cursor_handle);
413:
414: l_rows_affected := dbms_sql.execute(l_cursor_handle);
415: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Rows created' ||l_rows_affected);
416: dbms_sql.close_cursor(l_cursor_handle);
417: post_query; -- Updates id to names.
418:

Line 416: dbms_sql.close_cursor(l_cursor_handle);

412: bind_query(l_cursor_handle);
413:
414: l_rows_affected := dbms_sql.execute(l_cursor_handle);
415: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Rows created' ||l_rows_affected);
416: dbms_sql.close_cursor(l_cursor_handle);
417: post_query; -- Updates id to names.
418:
419: END execute_query;
420:

Line 2313: dbms_sql.bind_variable(

2309: IF g_date_bind_tab.COUNT > 0 THEN
2310:
2311: j := g_date_bind_tab.FIRST;
2312: WHILE j IS NOT NULL LOOP
2313: dbms_sql.bind_variable(
2314: p_cursor_handle,
2315: g_date_bind_tab(j).bind_name,
2316: g_date_bind_tab(j).bind_value
2317: );

Line 2332: dbms_sql.bind_variable(

2328: IF g_number_bind_tab.COUNT > 0 THEN
2329:
2330: j := g_number_bind_tab.FIRST;
2331: WHILE j IS NOT NULL LOOP
2332: dbms_sql.bind_variable(
2333: p_cursor_handle,
2334: g_number_bind_tab(j).bind_name,
2335: g_number_bind_tab(j).bind_value
2336: );

Line 2351: dbms_sql.bind_variable(

2347: IF g_varchar_bind_tab.COUNT > 0 THEN
2348:
2349: j := g_varchar_bind_tab.FIRST;
2350: WHILE j IS NOT NULL LOOP
2351: dbms_sql.bind_variable(
2352: p_cursor_handle,
2353: g_varchar_bind_tab(j).bind_name,
2354: g_varchar_bind_tab(j).bind_value
2355: );