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 2188: v_review_cursor:=dbms_sql.open_cursor;

2184: -- table will not exist if the database has not been upgraded to new salary admin
2185: -- (introduced April 1998). The procedure would not compile if this was not dynamic.
2186: -- if the table is not found then the error (which starts with 'ORA-00942') is ignored.
2187: begin
2188: v_review_cursor:=dbms_sql.open_cursor;
2189: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2190: where person_id=:x',dbms_sql.v7);
2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);

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

2185: -- (introduced April 1998). The procedure would not compile if this was not dynamic.
2186: -- if the table is not found then the error (which starts with 'ORA-00942') is ignored.
2187: begin
2188: v_review_cursor:=dbms_sql.open_cursor;
2189: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2190: where person_id=:x',dbms_sql.v7);
2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2193: dbms_sql.close_cursor(v_review_cursor);

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

2186: -- if the table is not found then the error (which starts with 'ORA-00942') is ignored.
2187: begin
2188: v_review_cursor:=dbms_sql.open_cursor;
2189: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2190: where person_id=:x',dbms_sql.v7);
2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2193: dbms_sql.close_cursor(v_review_cursor);
2194: exception

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

2187: begin
2188: v_review_cursor:=dbms_sql.open_cursor;
2189: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2190: where person_id=:x',dbms_sql.v7);
2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2193: dbms_sql.close_cursor(v_review_cursor);
2194: exception
2195: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);

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

2188: v_review_cursor:=dbms_sql.open_cursor;
2189: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2190: where person_id=:x',dbms_sql.v7);
2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2193: dbms_sql.close_cursor(v_review_cursor);
2194: exception
2195: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2196: when OTHERS then

Line 2193: dbms_sql.close_cursor(v_review_cursor);

2189: dbms_sql.parse(v_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2190: where person_id=:x',dbms_sql.v7);
2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2193: dbms_sql.close_cursor(v_review_cursor);
2194: exception
2195: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2196: when OTHERS then
2197: dbms_sql.close_cursor(v_review_cursor);

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

2191: dbms_sql.bind_variable(v_review_cursor, ':x',P_PERSON_ID);
2192: v_rows_processed:=dbms_sql.execute(v_review_cursor);
2193: dbms_sql.close_cursor(v_review_cursor);
2194: exception
2195: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2196: when OTHERS then
2197: dbms_sql.close_cursor(v_review_cursor);
2198: if(substr(sqlerrm,0,9)<>'ORA-00942') then
2199: raise;

Line 2197: dbms_sql.close_cursor(v_review_cursor);

2193: dbms_sql.close_cursor(v_review_cursor);
2194: exception
2195: when NO_DATA_FOUND then dbms_sql.close_cursor(v_review_cursor);
2196: when OTHERS then
2197: dbms_sql.close_cursor(v_review_cursor);
2198: if(substr(sqlerrm,0,9)<>'ORA-00942') then
2199: raise;
2200: end if;
2201: end;