DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on DBMS_SQL

Line 3809: c := dbms_sql.open_cursor;

3805: g_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
3806:
3807: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';
3808: if var_trace then
3809: c := dbms_sql.open_cursor;
3810: statement := 'alter session set sql_trace=true';
3811: dbms_sql.parse(c, statement, dbms_sql.native);
3812: rows_processed := dbms_sql.execute(c);
3813: dbms_sql.close_cursor(c);

Line 3811: dbms_sql.parse(c, statement, dbms_sql.native);

3807: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';
3808: if var_trace then
3809: c := dbms_sql.open_cursor;
3810: statement := 'alter session set sql_trace=true';
3811: dbms_sql.parse(c, statement, dbms_sql.native);
3812: rows_processed := dbms_sql.execute(c);
3813: dbms_sql.close_cursor(c);
3814: end if;
3815:

Line 3812: rows_processed := dbms_sql.execute(c);

3808: if var_trace then
3809: c := dbms_sql.open_cursor;
3810: statement := 'alter session set sql_trace=true';
3811: dbms_sql.parse(c, statement, dbms_sql.native);
3812: rows_processed := dbms_sql.execute(c);
3813: dbms_sql.close_cursor(c);
3814: end if;
3815:
3816: g_stmt_num := 10;

Line 3813: dbms_sql.close_cursor(c);

3809: c := dbms_sql.open_cursor;
3810: statement := 'alter session set sql_trace=true';
3811: dbms_sql.parse(c, statement, dbms_sql.native);
3812: rows_processed := dbms_sql.execute(c);
3813: dbms_sql.close_cursor(c);
3814: end if;
3815:
3816: g_stmt_num := 10;
3817: IF g_debug THEN