APPS.BOM_DIAGUNITTEST_ITMHLCHK dependencies on DBMS_SQL

Line 837: ln_cursor := dbms_sql.open_cursor;

833: sql_stmt :=sql_stmt||' and mif.organization_id = '||l_org_id;
834: end if;
835: /*sql_stmt := sql_stmt || ' and rownum< 5'; -- temporarily limiting the records to 5 */
836:
837: ln_cursor := dbms_sql.open_cursor;
838: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
839: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
840: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
841:

Line 838: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);

834: end if;
835: /*sql_stmt := sql_stmt || ' and rownum< 5'; -- temporarily limiting the records to 5 */
836:
837: ln_cursor := dbms_sql.open_cursor;
838: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
839: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
840: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
841:
842: End Loop;

Line 839: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);

835: /*sql_stmt := sql_stmt || ' and rownum< 5'; -- temporarily limiting the records to 5 */
836:
837: ln_cursor := dbms_sql.open_cursor;
838: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
839: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
840: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
841:
842: End Loop;
843:

Line 840: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

836:
837: ln_cursor := dbms_sql.open_cursor;
838: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
839: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
840: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
841:
842: End Loop;
843:
844: /* Display the records stored in temporary table bom_diag_temp_tab */