APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on DBMS_SQL

Line 894: l_cursor := dbms_sql.open_cursor;

890: 'ps.wip_line_id, ' ||
891: 'bbom.alternate_bom_designator ) '; */
892:
893: -- get a cursor handle
894: l_cursor := dbms_sql.open_cursor;
895:
896: -- parse the sql statement that we just built
897: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
898:

Line 897: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);

893: -- get a cursor handle
894: l_cursor := dbms_sql.open_cursor;
895:
896: -- parse the sql statement that we just built
897: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
898:
899: -- put values into all the bind variables
900: flm_util.add_bind (':b_kanban_plan_id',
901: mrp_kanban_plan_pk.g_kanban_info_rec.kanban_plan_id);

Line 915: l_rows_processed := dbms_sql.execute(l_cursor);

911: mrp_kanban_plan_pk.g_kanban_info_rec.category_set_id);
912: flm_util.do_binds(l_cursor);
913:
914: -- now execute the sql stmt
915: l_rows_processed := dbms_sql.execute(l_cursor);
916:
917: -- close the cursor
918: dbms_sql.close_cursor (l_cursor);
919:

Line 918: dbms_sql.close_cursor (l_cursor);

914: -- now execute the sql stmt
915: l_rows_processed := dbms_sql.execute(l_cursor);
916:
917: -- close the cursor
918: dbms_sql.close_cursor (l_cursor);
919:
920: IF mrp_kanban_plan_pk.g_debug THEN
921: mrp_kanban_plan_pk.g_log_message :=
922: '----------------------------------------------';