APPS.BOM_DIAGUNITTEST_ITMHLCHK dependencies on DBMS_SQL

Line 889: ln_cursor := dbms_sql.open_cursor;

885: sql_stmt :=sql_stmt||' and mif.organization_id = '||l_org_id;
886: end if;
887: /*sql_stmt := sql_stmt || ' and rownum< 5'; -- temporarily limiting the records to 5 */
888:
889: ln_cursor := dbms_sql.open_cursor;
890: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
891: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
892: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
893:

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

886: end if;
887: /*sql_stmt := sql_stmt || ' and rownum< 5'; -- temporarily limiting the records to 5 */
888:
889: ln_cursor := dbms_sql.open_cursor;
890: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
891: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
892: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
893:
894: End Loop;

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

887: /*sql_stmt := sql_stmt || ' and rownum< 5'; -- temporarily limiting the records to 5 */
888:
889: ln_cursor := dbms_sql.open_cursor;
890: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
891: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
892: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
893:
894: End Loop;
895:

Line 892: DBMS_SQL.CLOSE_CURSOR(ln_cursor);

888:
889: ln_cursor := dbms_sql.open_cursor;
890: DBMS_SQL.PARSE(ln_cursor,sql_stmt,dbms_sql.native);
891: ln_rows_proc := DBMS_SQL.EXECUTE(ln_cursor);
892: DBMS_SQL.CLOSE_CURSOR(ln_cursor);
893:
894: End Loop;
895:
896: /* Display the records stored in temporary table bom_diag_temp_tab */