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

Line 763: 'to_char(dbms_sql.last_sql_function_code),00);' ||

759: --
760: dt_text14:= 'end if;commit;l_grkey_prv:=l_grkey_cur;end loop;exception ' ||
761: 'when others then close dt_curs;' ||
762: 'hr_utility.set_location(''ERROR:''||' ||
763: 'to_char(dbms_sql.last_sql_function_code),00);' ||
764: 'hr_utility.set_location(''ERROR:''||' ||
765: 'to_char(dbms_sql.last_error_position),00);' ||
766: 'l_err:=hr_utility.get_message;' ||
767: 'hr_utility.trace(l_err);' ||

Line 765: 'to_char(dbms_sql.last_error_position),00);' ||

761: 'when others then close dt_curs;' ||
762: 'hr_utility.set_location(''ERROR:''||' ||
763: 'to_char(dbms_sql.last_sql_function_code),00);' ||
764: 'hr_utility.set_location(''ERROR:''||' ||
765: 'to_char(dbms_sql.last_error_position),00);' ||
766: 'l_err:=hr_utility.get_message;' ||
767: 'hr_utility.trace(l_err);' ||
768: 'raise;end;';
769: --

Line 925: dt_proc_cursor := dbms_sql.open_cursor;

921: --
922: -- open parse and execute the dynamic sql cursor text
923: --
924: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',30);
925: dt_proc_cursor := dbms_sql.open_cursor;
926: --
927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);
928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);
929: --

Line 928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);

924: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',30);
925: dt_proc_cursor := dbms_sql.open_cursor;
926: --
927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);
928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);
929: --
930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);
931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);
932: --

Line 931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);

927: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',40);
928: dbms_sql.parse(dt_proc_cursor, dt_proc_cursor_text, dbms_sql.v7);
929: --
930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);
931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);
932: --
933: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);
934: if dbms_sql.is_open(dt_proc_cursor) then
935: dbms_sql.close_cursor(dt_proc_cursor);

Line 934: if dbms_sql.is_open(dt_proc_cursor) then

930: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',50);
931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);
932: --
933: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);
934: if dbms_sql.is_open(dt_proc_cursor) then
935: dbms_sql.close_cursor(dt_proc_cursor);
936: end if;
937: --
938: -- commit all transactions

Line 935: dbms_sql.close_cursor(dt_proc_cursor);

931: dt_proc_rows := dbms_sql.execute(dt_proc_cursor);
932: --
933: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',60);
934: if dbms_sql.is_open(dt_proc_cursor) then
935: dbms_sql.close_cursor(dt_proc_cursor);
936: end if;
937: --
938: -- commit all transactions
939: --

Line 1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||

1141: ndt_text21 := 'elsif l_type = ''I'' then null;end if;' ||
1142: 'commit;end if;l_prev_pk:=l_pkval;' ||
1143: 'end loop;exception when others then close ndt_curs;' ||
1144: 'hr_utility.set_location(''ERROR:''||' ||
1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||
1146: 'hr_utility.set_location(''ERROR:''||' ||
1147: 'to_char(dbms_sql.last_error_position),00);' ||
1148: 'l_err:=hr_utility.get_message;' ||
1149: 'hr_utility.trace(l_err);' ||

Line 1147: 'to_char(dbms_sql.last_error_position),00);' ||

1143: 'end loop;exception when others then close ndt_curs;' ||
1144: 'hr_utility.set_location(''ERROR:''||' ||
1145: 'to_char(dbms_sql.last_sql_function_code),00);' ||
1146: 'hr_utility.set_location(''ERROR:''||' ||
1147: 'to_char(dbms_sql.last_error_position),00);' ||
1148: 'l_err:=hr_utility.get_message;' ||
1149: 'hr_utility.trace(l_err);' ||
1150: 'end;';
1151: --

Line 1335: ndt_proc_cursor := dbms_sql.open_CURSOR;

1331: --
1332: -- open parse and execute the dynamic sql cursor text
1333: --
1334: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',70);
1335: ndt_proc_cursor := dbms_sql.open_CURSOR;
1336: --
1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);
1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);
1339: --

Line 1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);

1334: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',70);
1335: ndt_proc_cursor := dbms_sql.open_CURSOR;
1336: --
1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);
1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);
1339: --
1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);
1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);
1342: --

Line 1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);

1337: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',80);
1338: dbms_sql.parse(ndt_proc_cursor, ndt_proc_cursor_text, dbms_sql.v7);
1339: --
1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);
1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);
1342: --
1343: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',100);
1344: if dbms_sql.is_open(ndt_proc_cursor) then
1345: dbms_sql.close_CURSOR(ndt_proc_cursor);

Line 1344: if dbms_sql.is_open(ndt_proc_cursor) then

1340: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',90);
1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);
1342: --
1343: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',100);
1344: if dbms_sql.is_open(ndt_proc_cursor) then
1345: dbms_sql.close_CURSOR(ndt_proc_cursor);
1346: end if;
1347: --
1348: -- commit all transactions

Line 1345: dbms_sql.close_CURSOR(ndt_proc_cursor);

1341: ndt_proc_rows := dbms_sql.EXECUTE(ndt_proc_cursor);
1342: --
1343: hr_utility.set_location('py_audit_rep_pkg.py_audit_rep_proc',100);
1344: if dbms_sql.is_open(ndt_proc_cursor) then
1345: dbms_sql.close_CURSOR(ndt_proc_cursor);
1346: end if;
1347: --
1348: -- commit all transactions
1349: --

Line 1371: if dbms_sql.is_open(dt_proc_cursor) then

1367: when others then
1368: --
1369: -- if the datetrack cursor is open close it.
1370: --
1371: if dbms_sql.is_open(dt_proc_cursor) then
1372: dbms_sql.close_cursor(dt_proc_cursor);
1373: end if;
1374: --
1375: -- if the non datetrack cursor is open close it

Line 1372: dbms_sql.close_cursor(dt_proc_cursor);

1368: --
1369: -- if the datetrack cursor is open close it.
1370: --
1371: if dbms_sql.is_open(dt_proc_cursor) then
1372: dbms_sql.close_cursor(dt_proc_cursor);
1373: end if;
1374: --
1375: -- if the non datetrack cursor is open close it
1376: --

Line 1377: if dbms_sql.is_open(ndt_proc_cursor) then

1373: end if;
1374: --
1375: -- if the non datetrack cursor is open close it
1376: --
1377: if dbms_sql.is_open(ndt_proc_cursor) then
1378: dbms_sql.close_cursor(ndt_proc_cursor);
1379: end if;
1380: --
1381: -- display the error

Line 1378: dbms_sql.close_cursor(ndt_proc_cursor);

1374: --
1375: -- if the non datetrack cursor is open close it
1376: --
1377: if dbms_sql.is_open(ndt_proc_cursor) then
1378: dbms_sql.close_cursor(ndt_proc_cursor);
1379: end if;
1380: --
1381: -- display the error
1382: --

Line 1384: to_char(dbms_sql.last_sql_function_code),00);

1380: --
1381: -- display the error
1382: --
1383: hr_utility.set_location('error is : ' ||
1384: to_char(dbms_sql.last_sql_function_code),00);
1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;
1388: hr_utility.trace(error_message);

Line 1386: to_char(dbms_sql.last_error_position),00);

1382: --
1383: hr_utility.set_location('error is : ' ||
1384: to_char(dbms_sql.last_sql_function_code),00);
1385: hr_utility.set_location('error is : ' ||
1386: to_char(dbms_sql.last_error_position),00);
1387: error_message := hr_utility.get_message;
1388: hr_utility.trace(error_message);
1389: hr_utility.trace('all cursors closed');
1390: raise;