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 4675: sql_cur := dbms_sql.open_cursor;

4671: --
4672: statem := 'BEGIN '||action_proc||'(:pactid, :stperson,'||
4673: ' :endperson, :chunk); END;';
4674: --
4675: sql_cur := dbms_sql.open_cursor;
4676: dbms_sql.parse(sql_cur,
4677: statem,
4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);

Line 4676: dbms_sql.parse(sql_cur,

4672: statem := 'BEGIN '||action_proc||'(:pactid, :stperson,'||
4673: ' :endperson, :chunk); END;';
4674: --
4675: sql_cur := dbms_sql.open_cursor;
4676: dbms_sql.parse(sql_cur,
4677: statem,
4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);

Line 4678: dbms_sql.v7);

4674: --
4675: sql_cur := dbms_sql.open_cursor;
4676: dbms_sql.parse(sql_cur,
4677: statem,
4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);

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

4675: sql_cur := dbms_sql.open_cursor;
4676: dbms_sql.parse(sql_cur,
4677: statem,
4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4683: ignore := dbms_sql.execute(sql_cur);

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

4676: dbms_sql.parse(sql_cur,
4677: statem,
4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4683: ignore := dbms_sql.execute(sql_cur);
4684: dbms_sql.close_cursor(sql_cur);

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

4677: statem,
4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4683: ignore := dbms_sql.execute(sql_cur);
4684: dbms_sql.close_cursor(sql_cur);
4685: --

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

4678: dbms_sql.v7);
4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4683: ignore := dbms_sql.execute(sql_cur);
4684: dbms_sql.close_cursor(sql_cur);
4685: --
4686: return;

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

4679: dbms_sql.bind_variable(sql_cur, ':pactid', pactid);
4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4683: ignore := dbms_sql.execute(sql_cur);
4684: dbms_sql.close_cursor(sql_cur);
4685: --
4686: return;
4687: --

Line 4684: dbms_sql.close_cursor(sql_cur);

4680: dbms_sql.bind_variable(sql_cur, ':stperson', stperson);
4681: dbms_sql.bind_variable(sql_cur, ':endperson', endperson);
4682: dbms_sql.bind_variable(sql_cur, ':chunk', chunk);
4683: ignore := dbms_sql.execute(sql_cur);
4684: dbms_sql.close_cursor(sql_cur);
4685: --
4686: return;
4687: --
4688: exception

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

4686: return;
4687: --
4688: exception
4689: when others then
4690: if (dbms_sql.is_open(sql_cur)) then
4691: dbms_sql.close_cursor(sql_cur);
4692: end if;
4693: raise;
4694: end procarc;

Line 4691: dbms_sql.close_cursor(sql_cur);

4687: --
4688: exception
4689: when others then
4690: if (dbms_sql.is_open(sql_cur)) then
4691: dbms_sql.close_cursor(sql_cur);
4692: end if;
4693: raise;
4694: end procarc;
4695: --