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

Line 2259: v_review_cursor:=dbms_sql.open_cursor;

2255: -- table will not exist if the database has not been upgraded to new salary admin
2256: -- (introduced April 1998). The procedure would not compile if this was not dynamic.
2257: -- if the table is not found then the error (which starts with 'ORA-00942') is ignored.
2258: begin
2259: v_review_cursor:=dbms_sql.open_cursor;
2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2261: where person_id=:x',dbms_sql.v7);
2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);

Line 2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS

2256: -- (introduced April 1998). The procedure would not compile if this was not dynamic.
2257: -- if the table is not found then the error (which starts with 'ORA-00942') is ignored.
2258: begin
2259: v_review_cursor:=dbms_sql.open_cursor;
2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2261: where person_id=:x',dbms_sql.v7);
2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2264: dbms_sql.close_cursor(v_review_cursor);

Line 2261: where person_id=:x',dbms_sql.v7);

2257: -- if the table is not found then the error (which starts with 'ORA-00942') is ignored.
2258: begin
2259: v_review_cursor:=dbms_sql.open_cursor;
2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2261: where person_id=:x',dbms_sql.v7);
2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2264: dbms_sql.close_cursor(v_review_cursor);
2265: exception

Line 2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);

2258: begin
2259: v_review_cursor:=dbms_sql.open_cursor;
2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2261: where person_id=:x',dbms_sql.v7);
2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2264: dbms_sql.close_cursor(v_review_cursor);
2265: exception
2266: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);

Line 2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);

2259: v_review_cursor:=dbms_sql.open_cursor;
2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2261: where person_id=:x',dbms_sql.v7);
2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2264: dbms_sql.close_cursor(v_review_cursor);
2265: exception
2266: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2267: when OTHERS then

Line 2264: dbms_sql.close_cursor(v_review_cursor);

2260: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2261: where person_id=:x',dbms_sql.v7);
2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2264: dbms_sql.close_cursor(v_review_cursor);
2265: exception
2266: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2267: when OTHERS then
2268: dbms_sql.close_cursor(v_review_cursor);

Line 2266: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);

2262: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2263: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2264: dbms_sql.close_cursor(v_review_cursor);
2265: exception
2266: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2267: when OTHERS then
2268: dbms_sql.close_cursor(v_review_cursor);
2269: if(substr(sqlerrm,0,9)<>'ORA-00942') then
2270: raise;

Line 2268: dbms_sql.close_cursor(v_review_cursor);

2264: dbms_sql.close_cursor(v_review_cursor);
2265: exception
2266: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2267: when OTHERS then
2268: dbms_sql.close_cursor(v_review_cursor);
2269: if(substr(sqlerrm,0,9)<>'ORA-00942') then
2270: raise;
2271: end if;
2272: end;