APPS.MRP_KANBAN_SNAPSHOT_PK dependencies on DBMS_SQL

Line 895: l_cursor := dbms_sql.open_cursor;

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

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

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

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

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

Line 919: dbms_sql.close_cursor (l_cursor);

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