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_INTERNAL dependencies on DBMS_SQL

Line 2954: l_review_cursor:=dbms_sql.open_cursor;

2950: -- with 'ORA-00942') is ignored.
2951: --
2952: begin
2953: --
2954: l_review_cursor:=dbms_sql.open_cursor;
2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2956: where person_id=:x',dbms_sql.v7);
2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);

Line 2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS

2951: --
2952: begin
2953: --
2954: l_review_cursor:=dbms_sql.open_cursor;
2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2956: where person_id=:x',dbms_sql.v7);
2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);
2959: dbms_sql.close_cursor(l_review_cursor);

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

2952: begin
2953: --
2954: l_review_cursor:=dbms_sql.open_cursor;
2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2956: where person_id=:x',dbms_sql.v7);
2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);
2959: dbms_sql.close_cursor(l_review_cursor);
2960: --

Line 2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);

2953: --
2954: l_review_cursor:=dbms_sql.open_cursor;
2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2956: where person_id=:x',dbms_sql.v7);
2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);
2959: dbms_sql.close_cursor(l_review_cursor);
2960: --
2961: exception

Line 2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);

2954: l_review_cursor:=dbms_sql.open_cursor;
2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2956: where person_id=:x',dbms_sql.v7);
2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);
2959: dbms_sql.close_cursor(l_review_cursor);
2960: --
2961: exception
2962: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);

Line 2959: dbms_sql.close_cursor(l_review_cursor);

2955: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
2956: where person_id=:x',dbms_sql.v7);
2957: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);
2959: dbms_sql.close_cursor(l_review_cursor);
2960: --
2961: exception
2962: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);
2963: when OTHERS then

Line 2962: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);

2958: l_rows_processed:=dbms_sql.execute(l_review_cursor);
2959: dbms_sql.close_cursor(l_review_cursor);
2960: --
2961: exception
2962: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);
2963: when OTHERS then
2964: dbms_sql.close_cursor(l_review_cursor);
2965: --
2966: if(substr(sqlerrm,0,9)<>'ORA-00942') then

Line 2964: dbms_sql.close_cursor(l_review_cursor);

2960: --
2961: exception
2962: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);
2963: when OTHERS then
2964: dbms_sql.close_cursor(l_review_cursor);
2965: --
2966: if(substr(sqlerrm,0,9)<>'ORA-00942') then
2967: raise;
2968: end if;