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 368: sql_cursor := dbms_sql.open_cursor;

364: if l_report_type='GENERIC_REPORT' then
365: statem := 'begin pay_'||l_leg_code||'_rules.payslip_range_cursor(';
366: statem := statem||':pactid, :p_sqlstr); end;';
367: --
368: sql_cursor := dbms_sql.open_cursor;
369: --
370: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
371: --
372: dbms_sql.bind_variable(sql_cursor, 'pactid', pactid);

Line 370: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);

366: statem := statem||':pactid, :p_sqlstr); end;';
367: --
368: sql_cursor := dbms_sql.open_cursor;
369: --
370: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
371: --
372: dbms_sql.bind_variable(sql_cursor, 'pactid', pactid);
373: --
374: dbms_sql.bind_variable(sql_cursor, 'p_sqlstr', lv_sqlstr,2000);

Line 372: dbms_sql.bind_variable(sql_cursor, 'pactid', pactid);

368: sql_cursor := dbms_sql.open_cursor;
369: --
370: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
371: --
372: dbms_sql.bind_variable(sql_cursor, 'pactid', pactid);
373: --
374: dbms_sql.bind_variable(sql_cursor, 'p_sqlstr', lv_sqlstr,2000);
375: --
376: Begin

Line 374: dbms_sql.bind_variable(sql_cursor, 'p_sqlstr', lv_sqlstr,2000);

370: dbms_sql.parse(sql_cursor, statem, dbms_sql.v7);
371: --
372: dbms_sql.bind_variable(sql_cursor, 'pactid', pactid);
373: --
374: dbms_sql.bind_variable(sql_cursor, 'p_sqlstr', lv_sqlstr,2000);
375: --
376: Begin
377: l_rows := dbms_sql.execute (sql_cursor);
378: exception when others then

Line 377: l_rows := dbms_sql.execute (sql_cursor);

373: --
374: dbms_sql.bind_variable(sql_cursor, 'p_sqlstr', lv_sqlstr,2000);
375: --
376: Begin
377: l_rows := dbms_sql.execute (sql_cursor);
378: exception when others then
379: l_rows := 0;
380: end;
381: --

Line 383: dbms_sql.variable_value(sql_cursor, 'p_sqlstr', lv_sqlstr);

379: l_rows := 0;
380: end;
381: --
382: if (l_rows = 1) then
383: dbms_sql.variable_value(sql_cursor, 'p_sqlstr', lv_sqlstr);
384: dbms_sql.close_cursor(sql_cursor);
385: else
386: lv_sqlstr := null;
387: dbms_sql.close_cursor(sql_cursor);

Line 384: dbms_sql.close_cursor(sql_cursor);

380: end;
381: --
382: if (l_rows = 1) then
383: dbms_sql.variable_value(sql_cursor, 'p_sqlstr', lv_sqlstr);
384: dbms_sql.close_cursor(sql_cursor);
385: else
386: lv_sqlstr := null;
387: dbms_sql.close_cursor(sql_cursor);
388: end if;

Line 387: dbms_sql.close_cursor(sql_cursor);

383: dbms_sql.variable_value(sql_cursor, 'p_sqlstr', lv_sqlstr);
384: dbms_sql.close_cursor(sql_cursor);
385: else
386: lv_sqlstr := null;
387: dbms_sql.close_cursor(sql_cursor);
388: end if;
389: sqlstr:=lv_sqlstr;
390: end if;
391:

Line 518: sql_cur := dbms_sql.open_cursor;

514: statem := 'BEGIN '||p_qual_proc||'(:objectid, :qual); END;';
515: --
516: hr_utility.trace(statem);
517:
518: sql_cur := dbms_sql.open_cursor;
519: dbms_sql.parse(sql_cur,
520: statem,
521: dbms_sql.v7);
522: --

Line 519: dbms_sql.parse(sql_cur,

515: --
516: hr_utility.trace(statem);
517:
518: sql_cur := dbms_sql.open_cursor;
519: dbms_sql.parse(sql_cur,
520: statem,
521: dbms_sql.v7);
522: --
523: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);

Line 521: dbms_sql.v7);

517:
518: sql_cur := dbms_sql.open_cursor;
519: dbms_sql.parse(sql_cur,
520: statem,
521: dbms_sql.v7);
522: --
523: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
524: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
525: l_rows := dbms_sql.execute(sql_cur);

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

519: dbms_sql.parse(sql_cur,
520: statem,
521: dbms_sql.v7);
522: --
523: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
524: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
525: l_rows := dbms_sql.execute(sql_cur);
526: if (l_rows = 1) then
527: dbms_sql.variable_value(sql_cur, 'qual',

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

520: statem,
521: dbms_sql.v7);
522: --
523: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
524: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
525: l_rows := dbms_sql.execute(sql_cur);
526: if (l_rows = 1) then
527: dbms_sql.variable_value(sql_cur, 'qual',
528: l_qualifer);

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

521: dbms_sql.v7);
522: --
523: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
524: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
525: l_rows := dbms_sql.execute(sql_cur);
526: if (l_rows = 1) then
527: dbms_sql.variable_value(sql_cur, 'qual',
528: l_qualifer);
529: dbms_sql.close_cursor(sql_cur);

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

523: dbms_sql.bind_variable(sql_cur, 'objectid', p_object_id);
524: dbms_sql.bind_variable(sql_cur, 'qual', l_qualifer, 10);
525: l_rows := dbms_sql.execute(sql_cur);
526: if (l_rows = 1) then
527: dbms_sql.variable_value(sql_cur, 'qual',
528: l_qualifer);
529: dbms_sql.close_cursor(sql_cur);
530: --
531: else

Line 529: dbms_sql.close_cursor(sql_cur);

525: l_rows := dbms_sql.execute(sql_cur);
526: if (l_rows = 1) then
527: dbms_sql.variable_value(sql_cur, 'qual',
528: l_qualifer);
529: dbms_sql.close_cursor(sql_cur);
530: --
531: else
532: dbms_sql.close_cursor(sql_cur);
533: pay_core_utils.assert_condition(

Line 532: dbms_sql.close_cursor(sql_cur);

528: l_qualifer);
529: dbms_sql.close_cursor(sql_cur);
530: --
531: else
532: dbms_sql.close_cursor(sql_cur);
533: pay_core_utils.assert_condition(
534: 'pay_generic_upgrade.do_qualification:1',
535: 1 = 2);
536: end if;

Line 976: sql_cur := dbms_sql.open_cursor;

972: statem := 'BEGIN '||upgrade_proc||'(:objectid); END;';
973: --
974: hr_utility.trace(statem);
975:
976: sql_cur := dbms_sql.open_cursor;
977: dbms_sql.parse(sql_cur,
978: statem,
979: dbms_sql.v7);
980: --

Line 977: dbms_sql.parse(sql_cur,

973: --
974: hr_utility.trace(statem);
975:
976: sql_cur := dbms_sql.open_cursor;
977: dbms_sql.parse(sql_cur,
978: statem,
979: dbms_sql.v7);
980: --
981: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);

Line 979: dbms_sql.v7);

975:
976: sql_cur := dbms_sql.open_cursor;
977: dbms_sql.parse(sql_cur,
978: statem,
979: dbms_sql.v7);
980: --
981: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
982: ignore := dbms_sql.execute(sql_cur);
983: dbms_sql.close_cursor(sql_cur);

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

977: dbms_sql.parse(sql_cur,
978: statem,
979: dbms_sql.v7);
980: --
981: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
982: ignore := dbms_sql.execute(sql_cur);
983: dbms_sql.close_cursor(sql_cur);
984: --
985: end upgrade_data;

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

978: statem,
979: dbms_sql.v7);
980: --
981: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
982: ignore := dbms_sql.execute(sql_cur);
983: dbms_sql.close_cursor(sql_cur);
984: --
985: end upgrade_data;
986:

Line 983: dbms_sql.close_cursor(sql_cur);

979: dbms_sql.v7);
980: --
981: dbms_sql.bind_variable(sql_cur, 'objectid', object_id);
982: ignore := dbms_sql.execute(sql_cur);
983: dbms_sql.close_cursor(sql_cur);
984: --
985: end upgrade_data;
986:
987: /* Name : deinitialise