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

Line 955: cid := dbms_sql.open_cursor;

951: sqlstr := 'delete from '|| pay_tab(lc_cnt) || ' where ';
952: sqlstr := sqlstr || ' 0 <> ( ';
953: sqlstr := sqlstr || 'select count(*) from '|| hr_s_tab(lc_cnt)||' )';
954:
955: cid := dbms_sql.open_cursor;
956: dbms_sql.parse(cid, sqlstr, dbms_sql.v7);
957: deltabid := dbms_sql.execute(cid);
958: dbms_sql.close_cursor(cid);
959: end if;

Line 956: dbms_sql.parse(cid, sqlstr, dbms_sql.v7);

952: sqlstr := sqlstr || ' 0 <> ( ';
953: sqlstr := sqlstr || 'select count(*) from '|| hr_s_tab(lc_cnt)||' )';
954:
955: cid := dbms_sql.open_cursor;
956: dbms_sql.parse(cid, sqlstr, dbms_sql.v7);
957: deltabid := dbms_sql.execute(cid);
958: dbms_sql.close_cursor(cid);
959: end if;
960: exception

Line 957: deltabid := dbms_sql.execute(cid);

953: sqlstr := sqlstr || 'select count(*) from '|| hr_s_tab(lc_cnt)||' )';
954:
955: cid := dbms_sql.open_cursor;
956: dbms_sql.parse(cid, sqlstr, dbms_sql.v7);
957: deltabid := dbms_sql.execute(cid);
958: dbms_sql.close_cursor(cid);
959: end if;
960: exception
961: when others then

Line 958: dbms_sql.close_cursor(cid);

954:
955: cid := dbms_sql.open_cursor;
956: dbms_sql.parse(cid, sqlstr, dbms_sql.v7);
957: deltabid := dbms_sql.execute(cid);
958: dbms_sql.close_cursor(cid);
959: end if;
960: exception
961: when others then
962: dbms_sql.close_cursor(cid);

Line 962: dbms_sql.close_cursor(cid);

958: dbms_sql.close_cursor(cid);
959: end if;
960: exception
961: when others then
962: dbms_sql.close_cursor(cid);
963: end;
964:
965: end if;
966: