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 3007: l_review_cursor:=dbms_sql.open_cursor;

3003: -- with 'ORA-00942') is ignored.
3004: --
3005: begin
3006: --
3007: l_review_cursor:=dbms_sql.open_cursor;
3008: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
3009: where person_id=:x',dbms_sql.v7);
3010: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);

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

3004: --
3005: begin
3006: --
3007: l_review_cursor:=dbms_sql.open_cursor;
3008: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
3009: where person_id=:x',dbms_sql.v7);
3010: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);
3012: dbms_sql.close_cursor(l_review_cursor);

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

3005: begin
3006: --
3007: l_review_cursor:=dbms_sql.open_cursor;
3008: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
3009: where person_id=:x',dbms_sql.v7);
3010: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);
3012: dbms_sql.close_cursor(l_review_cursor);
3013: --

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

3006: --
3007: l_review_cursor:=dbms_sql.open_cursor;
3008: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
3009: where person_id=:x',dbms_sql.v7);
3010: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);
3012: dbms_sql.close_cursor(l_review_cursor);
3013: --
3014: exception

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

3007: l_review_cursor:=dbms_sql.open_cursor;
3008: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
3009: where person_id=:x',dbms_sql.v7);
3010: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);
3012: dbms_sql.close_cursor(l_review_cursor);
3013: --
3014: exception
3015: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);

Line 3012: dbms_sql.close_cursor(l_review_cursor);

3008: dbms_sql.parse(l_review_cursor,'DELETE from PER_PERFORMANCE_REVIEWS
3009: where person_id=:x',dbms_sql.v7);
3010: dbms_sql.bind_variable(l_review_cursor, ':x',P_PERSON_ID);
3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);
3012: dbms_sql.close_cursor(l_review_cursor);
3013: --
3014: exception
3015: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);
3016: when OTHERS then

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

3011: l_rows_processed:=dbms_sql.execute(l_review_cursor);
3012: dbms_sql.close_cursor(l_review_cursor);
3013: --
3014: exception
3015: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);
3016: when OTHERS then
3017: dbms_sql.close_cursor(l_review_cursor);
3018: --
3019: if(substr(sqlerrm,0,9)<>'ORA-00942') then

Line 3017: dbms_sql.close_cursor(l_review_cursor);

3013: --
3014: exception
3015: when NO_DATA_FOUND then dbms_sql.close_cursor(l_review_cursor);
3016: when OTHERS then
3017: dbms_sql.close_cursor(l_review_cursor);
3018: --
3019: if(substr(sqlerrm,0,9)<>'ORA-00942') then
3020: raise;
3021: end if;