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.JTF_TAE_CONTROL_PVT dependencies on DBMS_SQL

Line 175: l_terr_analyze_id_arr DBMS_SQL.NUMBER_TABLE;

171: l_counter number := 0;
172: l_exist_qual_detail_count number;
173: startime date;
174: looptime date;
175: l_terr_analyze_id_arr DBMS_SQL.NUMBER_TABLE;
176: l_qual_prod_counter number;
177: l_counter_qtype_offset number;
178: l_char_tx_id varchar2(30);
179:

Line 1364: l_dyn_csr := dbms_sql.open_cursor;

1360:
1361: -- Commented out since OSO TAP
1362: -- sets these parameters
1363:
1364: l_dyn_csr := dbms_sql.open_cursor;
1365: dbms_sql.parse( l_dyn_csr
1366: , 'ALTER SESSION SET sort_area_size=' || TO_CHAR(p_sort_area_size)
1367: , dbms_sql.native );
1368: l_result := dbms_sql.execute(l_dyn_csr);

Line 1365: dbms_sql.parse( l_dyn_csr

1361: -- Commented out since OSO TAP
1362: -- sets these parameters
1363:
1364: l_dyn_csr := dbms_sql.open_cursor;
1365: dbms_sql.parse( l_dyn_csr
1366: , 'ALTER SESSION SET sort_area_size=' || TO_CHAR(p_sort_area_size)
1367: , dbms_sql.native );
1368: l_result := dbms_sql.execute(l_dyn_csr);
1369: dbms_sql.close_cursor(l_dyn_csr);

Line 1367: , dbms_sql.native );

1363:
1364: l_dyn_csr := dbms_sql.open_cursor;
1365: dbms_sql.parse( l_dyn_csr
1366: , 'ALTER SESSION SET sort_area_size=' || TO_CHAR(p_sort_area_size)
1367: , dbms_sql.native );
1368: l_result := dbms_sql.execute(l_dyn_csr);
1369: dbms_sql.close_cursor(l_dyn_csr);
1370:
1371: l_dyn_csr := dbms_sql.open_cursor;

Line 1368: l_result := dbms_sql.execute(l_dyn_csr);

1364: l_dyn_csr := dbms_sql.open_cursor;
1365: dbms_sql.parse( l_dyn_csr
1366: , 'ALTER SESSION SET sort_area_size=' || TO_CHAR(p_sort_area_size)
1367: , dbms_sql.native );
1368: l_result := dbms_sql.execute(l_dyn_csr);
1369: dbms_sql.close_cursor(l_dyn_csr);
1370:
1371: l_dyn_csr := dbms_sql.open_cursor;
1372: dbms_sql.parse( l_dyn_csr

Line 1369: dbms_sql.close_cursor(l_dyn_csr);

1365: dbms_sql.parse( l_dyn_csr
1366: , 'ALTER SESSION SET sort_area_size=' || TO_CHAR(p_sort_area_size)
1367: , dbms_sql.native );
1368: l_result := dbms_sql.execute(l_dyn_csr);
1369: dbms_sql.close_cursor(l_dyn_csr);
1370:
1371: l_dyn_csr := dbms_sql.open_cursor;
1372: dbms_sql.parse( l_dyn_csr
1373: , 'ALTER SESSION SET hash_area_size=' || TO_CHAR(p_hash_area_size)

Line 1371: l_dyn_csr := dbms_sql.open_cursor;

1367: , dbms_sql.native );
1368: l_result := dbms_sql.execute(l_dyn_csr);
1369: dbms_sql.close_cursor(l_dyn_csr);
1370:
1371: l_dyn_csr := dbms_sql.open_cursor;
1372: dbms_sql.parse( l_dyn_csr
1373: , 'ALTER SESSION SET hash_area_size=' || TO_CHAR(p_hash_area_size)
1374: , dbms_sql.native);
1375: l_result := dbms_sql.execute(l_dyn_csr);

Line 1372: dbms_sql.parse( l_dyn_csr

1368: l_result := dbms_sql.execute(l_dyn_csr);
1369: dbms_sql.close_cursor(l_dyn_csr);
1370:
1371: l_dyn_csr := dbms_sql.open_cursor;
1372: dbms_sql.parse( l_dyn_csr
1373: , 'ALTER SESSION SET hash_area_size=' || TO_CHAR(p_hash_area_size)
1374: , dbms_sql.native);
1375: l_result := dbms_sql.execute(l_dyn_csr);
1376: dbms_sql.close_cursor(l_dyn_csr);

Line 1374: , dbms_sql.native);

1370:
1371: l_dyn_csr := dbms_sql.open_cursor;
1372: dbms_sql.parse( l_dyn_csr
1373: , 'ALTER SESSION SET hash_area_size=' || TO_CHAR(p_hash_area_size)
1374: , dbms_sql.native);
1375: l_result := dbms_sql.execute(l_dyn_csr);
1376: dbms_sql.close_cursor(l_dyn_csr);
1377:
1378: l_dyn_csr := dbms_sql.open_cursor;

Line 1375: l_result := dbms_sql.execute(l_dyn_csr);

1371: l_dyn_csr := dbms_sql.open_cursor;
1372: dbms_sql.parse( l_dyn_csr
1373: , 'ALTER SESSION SET hash_area_size=' || TO_CHAR(p_hash_area_size)
1374: , dbms_sql.native);
1375: l_result := dbms_sql.execute(l_dyn_csr);
1376: dbms_sql.close_cursor(l_dyn_csr);
1377:
1378: l_dyn_csr := dbms_sql.open_cursor;
1379: dbms_sql.parse( l_dyn_csr

Line 1376: dbms_sql.close_cursor(l_dyn_csr);

1372: dbms_sql.parse( l_dyn_csr
1373: , 'ALTER SESSION SET hash_area_size=' || TO_CHAR(p_hash_area_size)
1374: , dbms_sql.native);
1375: l_result := dbms_sql.execute(l_dyn_csr);
1376: dbms_sql.close_cursor(l_dyn_csr);
1377:
1378: l_dyn_csr := dbms_sql.open_cursor;
1379: dbms_sql.parse( l_dyn_csr
1380: , 'ALTER SESSION ENABLE PARALLEL DML'

Line 1378: l_dyn_csr := dbms_sql.open_cursor;

1374: , dbms_sql.native);
1375: l_result := dbms_sql.execute(l_dyn_csr);
1376: dbms_sql.close_cursor(l_dyn_csr);
1377:
1378: l_dyn_csr := dbms_sql.open_cursor;
1379: dbms_sql.parse( l_dyn_csr
1380: , 'ALTER SESSION ENABLE PARALLEL DML'
1381: , dbms_sql.native);
1382: l_result := dbms_sql.execute(l_dyn_csr);

Line 1379: dbms_sql.parse( l_dyn_csr

1375: l_result := dbms_sql.execute(l_dyn_csr);
1376: dbms_sql.close_cursor(l_dyn_csr);
1377:
1378: l_dyn_csr := dbms_sql.open_cursor;
1379: dbms_sql.parse( l_dyn_csr
1380: , 'ALTER SESSION ENABLE PARALLEL DML'
1381: , dbms_sql.native);
1382: l_result := dbms_sql.execute(l_dyn_csr);
1383: dbms_sql.close_cursor(l_dyn_csr);

Line 1381: , dbms_sql.native);

1377:
1378: l_dyn_csr := dbms_sql.open_cursor;
1379: dbms_sql.parse( l_dyn_csr
1380: , 'ALTER SESSION ENABLE PARALLEL DML'
1381: , dbms_sql.native);
1382: l_result := dbms_sql.execute(l_dyn_csr);
1383: dbms_sql.close_cursor(l_dyn_csr);
1384:
1385: *****/

Line 1382: l_result := dbms_sql.execute(l_dyn_csr);

1378: l_dyn_csr := dbms_sql.open_cursor;
1379: dbms_sql.parse( l_dyn_csr
1380: , 'ALTER SESSION ENABLE PARALLEL DML'
1381: , dbms_sql.native);
1382: l_result := dbms_sql.execute(l_dyn_csr);
1383: dbms_sql.close_cursor(l_dyn_csr);
1384:
1385: *****/
1386:

Line 1383: dbms_sql.close_cursor(l_dyn_csr);

1379: dbms_sql.parse( l_dyn_csr
1380: , 'ALTER SESSION ENABLE PARALLEL DML'
1381: , dbms_sql.native);
1382: l_result := dbms_sql.execute(l_dyn_csr);
1383: dbms_sql.close_cursor(l_dyn_csr);
1384:
1385: *****/
1386:
1387: NULL;

Line 1447: l_dyn_csr := dbms_sql.open_cursor;

1443: errbuf varchar2(3000);
1444:
1445: BEGIN
1446:
1447: l_dyn_csr := dbms_sql.open_cursor;
1448: dbms_sql.parse( l_dyn_csr
1449: , 'ALTER TABLE ' || l_schema_name || '.' || p_table_name || ' NOLOGGING '
1450: , dbms_sql.native );
1451: l_result := dbms_sql.execute(l_dyn_csr);

Line 1448: dbms_sql.parse( l_dyn_csr

1444:
1445: BEGIN
1446:
1447: l_dyn_csr := dbms_sql.open_cursor;
1448: dbms_sql.parse( l_dyn_csr
1449: , 'ALTER TABLE ' || l_schema_name || '.' || p_table_name || ' NOLOGGING '
1450: , dbms_sql.native );
1451: l_result := dbms_sql.execute(l_dyn_csr);
1452: dbms_sql.close_cursor(l_dyn_csr);

Line 1450: , dbms_sql.native );

1446:
1447: l_dyn_csr := dbms_sql.open_cursor;
1448: dbms_sql.parse( l_dyn_csr
1449: , 'ALTER TABLE ' || l_schema_name || '.' || p_table_name || ' NOLOGGING '
1450: , dbms_sql.native );
1451: l_result := dbms_sql.execute(l_dyn_csr);
1452: dbms_sql.close_cursor(l_dyn_csr);
1453:
1454: EXCEPTION

Line 1451: l_result := dbms_sql.execute(l_dyn_csr);

1447: l_dyn_csr := dbms_sql.open_cursor;
1448: dbms_sql.parse( l_dyn_csr
1449: , 'ALTER TABLE ' || l_schema_name || '.' || p_table_name || ' NOLOGGING '
1450: , dbms_sql.native );
1451: l_result := dbms_sql.execute(l_dyn_csr);
1452: dbms_sql.close_cursor(l_dyn_csr);
1453:
1454: EXCEPTION
1455:

Line 1452: dbms_sql.close_cursor(l_dyn_csr);

1448: dbms_sql.parse( l_dyn_csr
1449: , 'ALTER TABLE ' || l_schema_name || '.' || p_table_name || ' NOLOGGING '
1450: , dbms_sql.native );
1451: l_result := dbms_sql.execute(l_dyn_csr);
1452: dbms_sql.close_cursor(l_dyn_csr);
1453:
1454: EXCEPTION
1455:
1456: WHEN utl_file.invalid_path OR