APPS.INV_MWB_QUERY_MANAGER dependencies on DBMS_SQL

Line 375: l_cursor_handle := dbms_sql.open_cursor;

371: insert into rtest1 values(l_query_str);
372: commit;
373: */
374:
375: l_cursor_handle := dbms_sql.open_cursor;
376: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);
377: bind_query(l_cursor_handle);
378:
379: l_rows_affected := dbms_sql.execute(l_cursor_handle);

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

372: commit;
373: */
374:
375: l_cursor_handle := dbms_sql.open_cursor;
376: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);
377: bind_query(l_cursor_handle);
378:
379: l_rows_affected := dbms_sql.execute(l_cursor_handle);
380: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Rows created' ||l_rows_affected);

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

375: l_cursor_handle := dbms_sql.open_cursor;
376: dbms_sql.parse(l_cursor_handle, l_query_str, dbms_sql.native);
377: bind_query(l_cursor_handle);
378:
379: l_rows_affected := dbms_sql.execute(l_cursor_handle);
380: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Rows created' ||l_rows_affected);
381: dbms_sql.close_cursor(l_cursor_handle);
382: post_query; -- Updates id to names.
383:

Line 381: dbms_sql.close_cursor(l_cursor_handle);

377: bind_query(l_cursor_handle);
378:
379: l_rows_affected := dbms_sql.execute(l_cursor_handle);
380: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Rows created' ||l_rows_affected);
381: dbms_sql.close_cursor(l_cursor_handle);
382: post_query; -- Updates id to names.
383:
384: END execute_query;
385:

Line 2030: dbms_sql.bind_variable(

2026: IF g_date_bind_tab.COUNT > 0 THEN
2027:
2028: j := g_date_bind_tab.FIRST;
2029: WHILE j IS NOT NULL LOOP
2030: dbms_sql.bind_variable(
2031: p_cursor_handle,
2032: g_date_bind_tab(j).bind_name,
2033: g_date_bind_tab(j).bind_value
2034: );

Line 2049: dbms_sql.bind_variable(

2045: IF g_number_bind_tab.COUNT > 0 THEN
2046:
2047: j := g_number_bind_tab.FIRST;
2048: WHILE j IS NOT NULL LOOP
2049: dbms_sql.bind_variable(
2050: p_cursor_handle,
2051: g_number_bind_tab(j).bind_name,
2052: g_number_bind_tab(j).bind_value
2053: );

Line 2068: dbms_sql.bind_variable(

2064: IF g_varchar_bind_tab.COUNT > 0 THEN
2065:
2066: j := g_varchar_bind_tab.FIRST;
2067: WHILE j IS NOT NULL LOOP
2068: dbms_sql.bind_variable(
2069: p_cursor_handle,
2070: g_varchar_bind_tab(j).bind_name,
2071: g_varchar_bind_tab(j).bind_value
2072: );