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.PAY_GENERIC_UPGRADE dependencies on DBMS_SQL

Line 467: sql_cur := dbms_sql.open_cursor;

463: statem := 'BEGIN '||p_qual_proc||'(:objectid, :qual); END;';
464: --
465: hr_utility.trace(statem);
466:
467: sql_cur := dbms_sql.open_cursor;
468: dbms_sql.parse(sql_cur,
469: statem,
470: dbms_sql.v7);
471: --

Line 468: dbms_sql.parse(sql_cur,

464: --
465: hr_utility.trace(statem);
466:
467: sql_cur := dbms_sql.open_cursor;
468: dbms_sql.parse(sql_cur,
469: statem,
470: dbms_sql.v7);
471: --
472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);

Line 470: dbms_sql.v7);

466:
467: sql_cur := dbms_sql.open_cursor;
468: dbms_sql.parse(sql_cur,
469: statem,
470: dbms_sql.v7);
471: --
472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
473: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
474: l_rows := dbms_sql.execute(sql_cur);

Line 472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);

468: dbms_sql.parse(sql_cur,
469: statem,
470: dbms_sql.v7);
471: --
472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
473: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
474: l_rows := dbms_sql.execute(sql_cur);
475: if (l_rows = 1) then
476: dbms_sql.variable_value(sql_cur, 'qual',

Line 473: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);

469: statem,
470: dbms_sql.v7);
471: --
472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
473: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
474: l_rows := dbms_sql.execute(sql_cur);
475: if (l_rows = 1) then
476: dbms_sql.variable_value(sql_cur, 'qual',
477: l_qualifer);

Line 474: l_rows := dbms_sql.execute(sql_cur);

470: dbms_sql.v7);
471: --
472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
473: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
474: l_rows := dbms_sql.execute(sql_cur);
475: if (l_rows = 1) then
476: dbms_sql.variable_value(sql_cur, 'qual',
477: l_qualifer);
478: dbms_sql.close_cursor(sql_cur);

Line 476: dbms_sql.variable_value(sql_cur, 'qual',

472: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
473: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
474: l_rows := dbms_sql.execute(sql_cur);
475: if (l_rows = 1) then
476: dbms_sql.variable_value(sql_cur, 'qual',
477: l_qualifer);
478: dbms_sql.close_cursor(sql_cur);
479: --
480: else

Line 478: dbms_sql.close_cursor(sql_cur);

474: l_rows := dbms_sql.execute(sql_cur);
475: if (l_rows = 1) then
476: dbms_sql.variable_value(sql_cur, 'qual',
477: l_qualifer);
478: dbms_sql.close_cursor(sql_cur);
479: --
480: else
481: dbms_sql.close_cursor(sql_cur);
482: pay_core_utils.assert_condition(

Line 481: dbms_sql.close_cursor(sql_cur);

477: l_qualifer);
478: dbms_sql.close_cursor(sql_cur);
479: --
480: else
481: dbms_sql.close_cursor(sql_cur);
482: pay_core_utils.assert_condition(
483: 'pay_generic_upgrade.do_qualification:1',
484: 1 = 2);
485: end if;

Line 889: sql_cur := dbms_sql.open_cursor;

885: statem := 'BEGIN '||upgrade_proc||'(:objectid); END;';
886: --
887: hr_utility.trace(statem);
888:
889: sql_cur := dbms_sql.open_cursor;
890: dbms_sql.parse(sql_cur,
891: statem,
892: dbms_sql.v7);
893: --

Line 890: dbms_sql.parse(sql_cur,

886: --
887: hr_utility.trace(statem);
888:
889: sql_cur := dbms_sql.open_cursor;
890: dbms_sql.parse(sql_cur,
891: statem,
892: dbms_sql.v7);
893: --
894: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);

Line 892: dbms_sql.v7);

888:
889: sql_cur := dbms_sql.open_cursor;
890: dbms_sql.parse(sql_cur,
891: statem,
892: dbms_sql.v7);
893: --
894: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
895: ignore := dbms_sql.execute(sql_cur);
896: dbms_sql.close_cursor(sql_cur);

Line 894: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);

890: dbms_sql.parse(sql_cur,
891: statem,
892: dbms_sql.v7);
893: --
894: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
895: ignore := dbms_sql.execute(sql_cur);
896: dbms_sql.close_cursor(sql_cur);
897: --
898: end upgrade_data;

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

891: statem,
892: dbms_sql.v7);
893: --
894: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
895: ignore := dbms_sql.execute(sql_cur);
896: dbms_sql.close_cursor(sql_cur);
897: --
898: end upgrade_data;
899:

Line 896: dbms_sql.close_cursor(sql_cur);

892: dbms_sql.v7);
893: --
894: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
895: ignore := dbms_sql.execute(sql_cur);
896: dbms_sql.close_cursor(sql_cur);
897: --
898: end upgrade_data;
899:
900: /* Name : deinitialise