eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DELETE_GROUPS_API dependencies on DBMS_SQL

Line 840: cursor_name := dbms_sql.open_cursor;

836: buff => constraint_stmt);
837: end if;
838: stmt_num := 7;
839: begin
840: cursor_name := dbms_sql.open_cursor;
841: DBMS_SQL.PARSE(cursor_name, constraint_stmt,dbms_sql.native);
842: dbms_sql.define_column(cursor_name, 1, cnt);
843: for i in 1..bind_list.COUNT loop
844:

Line 841: DBMS_SQL.PARSE(cursor_name, constraint_stmt,dbms_sql.native);

837: end if;
838: stmt_num := 7;
839: begin
840: cursor_name := dbms_sql.open_cursor;
841: DBMS_SQL.PARSE(cursor_name, constraint_stmt,dbms_sql.native);
842: dbms_sql.define_column(cursor_name, 1, cnt);
843: for i in 1..bind_list.COUNT loop
844:
845: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

Line 842: dbms_sql.define_column(cursor_name, 1, cnt);

838: stmt_num := 7;
839: begin
840: cursor_name := dbms_sql.open_cursor;
841: DBMS_SQL.PARSE(cursor_name, constraint_stmt,dbms_sql.native);
842: dbms_sql.define_column(cursor_name, 1, cnt);
843: for i in 1..bind_list.COUNT loop
844:
845: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
846:

Line 845: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

841: DBMS_SQL.PARSE(cursor_name, constraint_stmt,dbms_sql.native);
842: dbms_sql.define_column(cursor_name, 1, cnt);
843: for i in 1..bind_list.COUNT loop
844:
845: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
846:
847: end loop;
848: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
849: dbms_sql.column_value(cursor_name, 1, cnt);

Line 848: rows_processed := dbms_sql.execute_and_fetch(cursor_name);

844:
845: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
846:
847: end loop;
848: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
849: dbms_sql.column_value(cursor_name, 1, cnt);
850: dbms_sql.close_cursor(cursor_name);
851: exception
852: when no_data_found then

Line 849: dbms_sql.column_value(cursor_name, 1, cnt);

845: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
846:
847: end loop;
848: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
849: dbms_sql.column_value(cursor_name, 1, cnt);
850: dbms_sql.close_cursor(cursor_name);
851: exception
852: when no_data_found then
853: cnt := 0;

Line 850: dbms_sql.close_cursor(cursor_name);

846:
847: end loop;
848: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
849: dbms_sql.column_value(cursor_name, 1, cnt);
850: dbms_sql.close_cursor(cursor_name);
851: exception
852: when no_data_found then
853: cnt := 0;
854: dbms_sql.close_cursor(cursor_name);

Line 854: dbms_sql.close_cursor(cursor_name);

850: dbms_sql.close_cursor(cursor_name);
851: exception
852: when no_data_found then
853: cnt := 0;
854: dbms_sql.close_cursor(cursor_name);
855: when others then
856: if(p_debug = 'Y')then
857: fnd_file.put_line ( Which => FND_FILE.LOG,
858: buff => SUBSTRB(SQLERRM,1,500) );

Line 860: DBMS_SQL.close_cursor(cursor_name);

856: if(p_debug = 'Y')then
857: fnd_file.put_line ( Which => FND_FILE.LOG,
858: buff => SUBSTRB(SQLERRM,1,500) );
859: end if;
860: DBMS_SQL.close_cursor(cursor_name);
861: end;
862:
863: if(p_debug = 'Y')then
864: fnd_file.put_line (Which => FND_FILE.LOG,

Line 1246: cursor_name := dbms_sql.open_cursor;

1242: end if;
1243: end if;
1244:
1245:
1246: cursor_name := dbms_sql.open_cursor;
1247: DBMS_SQL.PARSE(cursor_name, delete_stmt,dbms_sql.native);
1248: for i in 1..bind_list.COUNT loop
1249:
1250:

Line 1247: DBMS_SQL.PARSE(cursor_name, delete_stmt,dbms_sql.native);

1243: end if;
1244:
1245:
1246: cursor_name := dbms_sql.open_cursor;
1247: DBMS_SQL.PARSE(cursor_name, delete_stmt,dbms_sql.native);
1248: for i in 1..bind_list.COUNT loop
1249:
1250:
1251: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

Line 1251: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

1247: DBMS_SQL.PARSE(cursor_name, delete_stmt,dbms_sql.native);
1248: for i in 1..bind_list.COUNT loop
1249:
1250:
1251: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1252:
1253: end loop;
1254: rows_processed:= DBMS_SQL.execute(cursor_name);
1255: dbms_sql.close_cursor(cursor_name);

Line 1254: rows_processed:= DBMS_SQL.execute(cursor_name);

1250:
1251: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1252:
1253: end loop;
1254: rows_processed:= DBMS_SQL.execute(cursor_name);
1255: dbms_sql.close_cursor(cursor_name);
1256: END LOOP;
1257: action_status := 4; -- deleted successfully
1258: return 0;

Line 1255: dbms_sql.close_cursor(cursor_name);

1251: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1252:
1253: end loop;
1254: rows_processed:= DBMS_SQL.execute(cursor_name);
1255: dbms_sql.close_cursor(cursor_name);
1256: END LOOP;
1257: action_status := 4; -- deleted successfully
1258: return 0;
1259:

Line 1345: cursor_name := DBMS_SQL.OPEN_CURSOR;

1341: buff => delete_stmt );
1342: END IF;
1343: END IF ;
1344:
1345: cursor_name := DBMS_SQL.OPEN_CURSOR;
1346:
1347: DBMS_SQL.PARSE( cursor_name, delete_stmt, DBMS_SQL.NATIVE );
1348:
1349: FOR i IN 1 .. bind_list.COUNT

Line 1347: DBMS_SQL.PARSE( cursor_name, delete_stmt, DBMS_SQL.NATIVE );

1343: END IF ;
1344:
1345: cursor_name := DBMS_SQL.OPEN_CURSOR;
1346:
1347: DBMS_SQL.PARSE( cursor_name, delete_stmt, DBMS_SQL.NATIVE );
1348:
1349: FOR i IN 1 .. bind_list.COUNT
1350: LOOP
1351: DBMS_SQL.BIND_VARIABLE( cursor_name, bind_list(i).bind_name, bind_list(i).bind_value );

Line 1351: DBMS_SQL.BIND_VARIABLE( cursor_name, bind_list(i).bind_name, bind_list(i).bind_value );

1347: DBMS_SQL.PARSE( cursor_name, delete_stmt, DBMS_SQL.NATIVE );
1348:
1349: FOR i IN 1 .. bind_list.COUNT
1350: LOOP
1351: DBMS_SQL.BIND_VARIABLE( cursor_name, bind_list(i).bind_name, bind_list(i).bind_value );
1352: END LOOP;
1353:
1354: rows_processed:= DBMS_SQL.EXECUTE(cursor_name);
1355:

Line 1354: rows_processed:= DBMS_SQL.EXECUTE(cursor_name);

1350: LOOP
1351: DBMS_SQL.BIND_VARIABLE( cursor_name, bind_list(i).bind_name, bind_list(i).bind_value );
1352: END LOOP;
1353:
1354: rows_processed:= DBMS_SQL.EXECUTE(cursor_name);
1355:
1356: DBMS_SQL.CLOSE_CURSOR( cursor_name );
1357:
1358: END LOOP; -- end FOR cur_rec IN delete_cursor

Line 1356: DBMS_SQL.CLOSE_CURSOR( cursor_name );

1352: END LOOP;
1353:
1354: rows_processed:= DBMS_SQL.EXECUTE(cursor_name);
1355:
1356: DBMS_SQL.CLOSE_CURSOR( cursor_name );
1357:
1358: END LOOP; -- end FOR cur_rec IN delete_cursor
1359:
1360: action_status := 4; -- deleted successfully

Line 1494: cursor_name := dbms_sql.open_cursor;

1490: buff => update_stmt);
1491: end if;
1492: update_stmt := update_stmt ||' WHERE '||where_clause;
1493: stmt_num := 2;
1494: cursor_name := dbms_sql.open_cursor;
1495: DBMS_SQL.PARSE(cursor_name, update_stmt,dbms_sql.native);
1496: for i in 1..bind_list.COUNT loop
1497: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1498: end loop;

Line 1495: DBMS_SQL.PARSE(cursor_name, update_stmt,dbms_sql.native);

1491: end if;
1492: update_stmt := update_stmt ||' WHERE '||where_clause;
1493: stmt_num := 2;
1494: cursor_name := dbms_sql.open_cursor;
1495: DBMS_SQL.PARSE(cursor_name, update_stmt,dbms_sql.native);
1496: for i in 1..bind_list.COUNT loop
1497: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1498: end loop;
1499: rows_processed:= DBMS_SQL.execute(cursor_name);

Line 1497: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

1493: stmt_num := 2;
1494: cursor_name := dbms_sql.open_cursor;
1495: DBMS_SQL.PARSE(cursor_name, update_stmt,dbms_sql.native);
1496: for i in 1..bind_list.COUNT loop
1497: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1498: end loop;
1499: rows_processed:= DBMS_SQL.execute(cursor_name);
1500: dbms_sql.close_cursor(cursor_name);
1501: stmt_num := 3;

Line 1499: rows_processed:= DBMS_SQL.execute(cursor_name);

1495: DBMS_SQL.PARSE(cursor_name, update_stmt,dbms_sql.native);
1496: for i in 1..bind_list.COUNT loop
1497: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1498: end loop;
1499: rows_processed:= DBMS_SQL.execute(cursor_name);
1500: dbms_sql.close_cursor(cursor_name);
1501: stmt_num := 3;
1502: archive_table := insert_table;
1503: prod_table := table_name;

Line 1500: dbms_sql.close_cursor(cursor_name);

1496: for i in 1..bind_list.COUNT loop
1497: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1498: end loop;
1499: rows_processed:= DBMS_SQL.execute(cursor_name);
1500: dbms_sql.close_cursor(cursor_name);
1501: stmt_num := 3;
1502: archive_table := insert_table;
1503: prod_table := table_name;
1504: /*

Line 1589: cursor_name := dbms_sql.open_cursor;

1585: if(p_debug = 'Y')then
1586: fnd_file.put_line (Which => FND_FILE.LOG,
1587: buff => insert_stmt);
1588: end if;
1589: cursor_name := dbms_sql.open_cursor;
1590: DBMS_SQL.PARSE(cursor_name, insert_stmt,dbms_sql.native);
1591: for i in 1..bind_list.COUNT loop
1592:
1593: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

Line 1590: DBMS_SQL.PARSE(cursor_name, insert_stmt,dbms_sql.native);

1586: fnd_file.put_line (Which => FND_FILE.LOG,
1587: buff => insert_stmt);
1588: end if;
1589: cursor_name := dbms_sql.open_cursor;
1590: DBMS_SQL.PARSE(cursor_name, insert_stmt,dbms_sql.native);
1591: for i in 1..bind_list.COUNT loop
1592:
1593: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1594:

Line 1593: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);

1589: cursor_name := dbms_sql.open_cursor;
1590: DBMS_SQL.PARSE(cursor_name, insert_stmt,dbms_sql.native);
1591: for i in 1..bind_list.COUNT loop
1592:
1593: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1594:
1595: end loop;
1596: rows_processed:= DBMS_SQL.execute(cursor_name);
1597: dbms_sql.close_cursor(cursor_name);

Line 1596: rows_processed:= DBMS_SQL.execute(cursor_name);

1592:
1593: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1594:
1595: end loop;
1596: rows_processed:= DBMS_SQL.execute(cursor_name);
1597: dbms_sql.close_cursor(cursor_name);
1598: return 0;
1599:
1600: EXCEPTION

Line 1597: dbms_sql.close_cursor(cursor_name);

1593: DBMS_SQL.BIND_VARIABLE(cursor_name, bind_list(i).bind_name, bind_list(i).bind_value);
1594:
1595: end loop;
1596: rows_processed:= DBMS_SQL.execute(cursor_name);
1597: dbms_sql.close_cursor(cursor_name);
1598: return 0;
1599:
1600: EXCEPTION
1601: WHEN others THEN