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

Line 4660: sql_cur := dbms_sql.open_cursor;

4656: --
4657: statem := 'BEGIN '||action_proc||'(:pactid, :stperson,'||
4658: ' :endperson, :chunk); END;';
4659: --
4660: sql_cur := dbms_sql.open_cursor;
4661: dbms_sql.parse(sql_cur,
4662: statem,
4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);

Line 4661: dbms_sql.parse(sql_cur,

4657: statem := 'BEGIN '||action_proc||'(:pactid, :stperson,'||
4658: ' :endperson, :chunk); END;';
4659: --
4660: sql_cur := dbms_sql.open_cursor;
4661: dbms_sql.parse(sql_cur,
4662: statem,
4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);

Line 4663: dbms_sql.v7);

4659: --
4660: sql_cur := dbms_sql.open_cursor;
4661: dbms_sql.parse(sql_cur,
4662: statem,
4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);

Line 4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);

4660: sql_cur := dbms_sql.open_cursor;
4661: dbms_sql.parse(sql_cur,
4662: statem,
4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4668: ignore := dbms_sql.execute(sql_cur);

Line 4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);

4661: dbms_sql.parse(sql_cur,
4662: statem,
4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4668: ignore := dbms_sql.execute(sql_cur);
4669: dbms_sql.close_cursor(sql_cur);

Line 4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);

4662: statem,
4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4668: ignore := dbms_sql.execute(sql_cur);
4669: dbms_sql.close_cursor(sql_cur);
4670: --

Line 4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);

4663: dbms_sql.v7);
4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4668: ignore := dbms_sql.execute(sql_cur);
4669: dbms_sql.close_cursor(sql_cur);
4670: --
4671: return;

Line 4668: ignore := dbms_sql.execute(sql_cur);

4664: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4668: ignore := dbms_sql.execute(sql_cur);
4669: dbms_sql.close_cursor(sql_cur);
4670: --
4671: return;
4672: --

Line 4669: dbms_sql.close_cursor(sql_cur);

4665: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4666: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4667: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4668: ignore := dbms_sql.execute(sql_cur);
4669: dbms_sql.close_cursor(sql_cur);
4670: --
4671: return;
4672: --
4673: exception

Line 4675: if (dbms_sql.is_open(sql_cur)) then

4671: return;
4672: --
4673: exception
4674: when others then
4675: if (dbms_sql.is_open(sql_cur)) then
4676: dbms_sql.close_cursor(sql_cur);
4677: end if;
4678: raise;
4679: end procarc;

Line 4676: dbms_sql.close_cursor(sql_cur);

4672: --
4673: exception
4674: when others then
4675: if (dbms_sql.is_open(sql_cur)) then
4676: dbms_sql.close_cursor(sql_cur);
4677: end if;
4678: raise;
4679: end procarc;
4680: --