DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on DBMS_SQL

Line 4303: c := dbms_sql.open_cursor;

4299: g_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
4300:
4301: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';
4302: if var_trace then
4303: c := dbms_sql.open_cursor;
4304: statement := 'alter session set sql_trace=true';
4305: dbms_sql.parse(c, statement, dbms_sql.native);
4306: rows_processed := dbms_sql.execute(c);
4307: dbms_sql.close_cursor(c);

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

4301: var_trace := fnd_profile.value('MRP_TRACE') = 'Y';
4302: if var_trace then
4303: c := dbms_sql.open_cursor;
4304: statement := 'alter session set sql_trace=true';
4305: dbms_sql.parse(c, statement, dbms_sql.native);
4306: rows_processed := dbms_sql.execute(c);
4307: dbms_sql.close_cursor(c);
4308: end if;
4309:

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

4302: if var_trace then
4303: c := dbms_sql.open_cursor;
4304: statement := 'alter session set sql_trace=true';
4305: dbms_sql.parse(c, statement, dbms_sql.native);
4306: rows_processed := dbms_sql.execute(c);
4307: dbms_sql.close_cursor(c);
4308: end if;
4309:
4310: g_stmt_num := 10;

Line 4307: dbms_sql.close_cursor(c);

4303: c := dbms_sql.open_cursor;
4304: statement := 'alter session set sql_trace=true';
4305: dbms_sql.parse(c, statement, dbms_sql.native);
4306: rows_processed := dbms_sql.execute(c);
4307: dbms_sql.close_cursor(c);
4308: end if;
4309:
4310: g_stmt_num := 10;
4311: IF g_debug THEN