APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on DBMS_SQL

Line 446: l_cursor := dbms_sql.open_cursor;

442: l_where_clause ||
443: ' and order_type IN (2, 3, 5))';
444:
445: -- get a cursor handle
446: l_cursor := dbms_sql.open_cursor;
447:
448:
449: -- parse the sql statement that we just built
450: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);

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

446: l_cursor := dbms_sql.open_cursor;
447:
448:
449: -- parse the sql statement that we just built
450: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
451:
452: -- now execute the sql stmt
453: l_rows_processed := dbms_sql.execute(l_cursor);
454:

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

449: -- parse the sql statement that we just built
450: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
451:
452: -- now execute the sql stmt
453: l_rows_processed := dbms_sql.execute(l_cursor);
454:
455: -- close the cursor
456: dbms_sql.close_cursor (l_cursor);
457:

Line 456: dbms_sql.close_cursor (l_cursor);

452: -- now execute the sql stmt
453: l_rows_processed := dbms_sql.execute(l_cursor);
454:
455: -- close the cursor
456: dbms_sql.close_cursor (l_cursor);
457:
458: return l_rows_processed;
459:
460: END;

Line 511: l_cursor := dbms_sql.open_cursor;

507: ' and order_type =13)'||
508: ' AND nvl(status,0) <> 3' ; --bug2797945
509:
510: -- get a cursor handle
511: l_cursor := dbms_sql.open_cursor;
512:
513:
514: -- parse the sql statement that we just built
515: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);

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

511: l_cursor := dbms_sql.open_cursor;
512:
513:
514: -- parse the sql statement that we just built
515: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
516:
517: -- now execute the sql stmt
518: l_rows_processed := dbms_sql.execute(l_cursor);
519:

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

514: -- parse the sql statement that we just built
515: dbms_sql.parse (l_cursor, l_sql_stmt, dbms_sql.native);
516:
517: -- now execute the sql stmt
518: l_rows_processed := dbms_sql.execute(l_cursor);
519:
520: -- close the cursor
521: dbms_sql.close_cursor (l_cursor);
522:

Line 521: dbms_sql.close_cursor (l_cursor);

517: -- now execute the sql stmt
518: l_rows_processed := dbms_sql.execute(l_cursor);
519:
520: -- close the cursor
521: dbms_sql.close_cursor (l_cursor);
522:
523: return l_rows_processed;
524:
525: END;