APPS.INV_MO_LINE_DETAIL_UTIL dependencies on DBMS_SQL

Line 2420: l_sql_p := DBMS_SQL.open_cursor;

2416: l_del_mtlt := l_del_mtlt || ')';
2417: END IF;
2418: END LOOP;
2419:
2420: l_sql_p := DBMS_SQL.open_cursor;
2421: DBMS_SQL.parse(l_sql_p, l_del_mtlt, DBMS_SQL.native);
2422: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2423: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2424: END IF;

Line 2421: DBMS_SQL.parse(l_sql_p, l_del_mtlt, DBMS_SQL.native);

2417: END IF;
2418: END LOOP;
2419:
2420: l_sql_p := DBMS_SQL.open_cursor;
2421: DBMS_SQL.parse(l_sql_p, l_del_mtlt, DBMS_SQL.native);
2422: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2423: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2424: END IF;
2425:

Line 2422: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);

2418: END LOOP;
2419:
2420: l_sql_p := DBMS_SQL.open_cursor;
2421: DBMS_SQL.parse(l_sql_p, l_del_mtlt, DBMS_SQL.native);
2422: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2423: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2424: END IF;
2425:
2426: IF l_mmtt_table.COUNT > 0 THEN

Line 2423: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);

2419:
2420: l_sql_p := DBMS_SQL.open_cursor;
2421: DBMS_SQL.parse(l_sql_p, l_del_mtlt, DBMS_SQL.native);
2422: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2423: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2424: END IF;
2425:
2426: IF l_mmtt_table.COUNT > 0 THEN
2427: i := l_mmtt_table.FIRST;

Line 2443: l_sql_p := DBMS_SQL.open_cursor;

2439:
2440: i := l_mmtt_table.NEXT(i);
2441: END LOOP;
2442:
2443: l_sql_p := DBMS_SQL.open_cursor;
2444: DBMS_SQL.parse(l_sql_p, l_del_mmtt, DBMS_SQL.native);
2445: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2446: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2447: END IF;

Line 2444: DBMS_SQL.parse(l_sql_p, l_del_mmtt, DBMS_SQL.native);

2440: i := l_mmtt_table.NEXT(i);
2441: END LOOP;
2442:
2443: l_sql_p := DBMS_SQL.open_cursor;
2444: DBMS_SQL.parse(l_sql_p, l_del_mmtt, DBMS_SQL.native);
2445: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2446: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2447: END IF;
2448:

Line 2445: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);

2441: END LOOP;
2442:
2443: l_sql_p := DBMS_SQL.open_cursor;
2444: DBMS_SQL.parse(l_sql_p, l_del_mmtt, DBMS_SQL.native);
2445: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2446: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2447: END IF;
2448:
2449: -- Requery the MMTT rows and pass them back as the output parameter

Line 2446: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);

2442:
2443: l_sql_p := DBMS_SQL.open_cursor;
2444: DBMS_SQL.parse(l_sql_p, l_del_mmtt, DBMS_SQL.native);
2445: DBMS_SQL.bind_variable(l_sql_p, 'b_move_order_line_id', p_move_order_line_id);
2446: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
2447: END IF;
2448:
2449: -- Requery the MMTT rows and pass them back as the output parameter
2450: x_mold_table := inv_mo_line_detail_util.query_rows(p_move_order_line_id);