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

Line 448: sql_curs := dbms_sql.open_cursor;

444: begin
445: statem := 'BEGIN
446: :header_check := pay_'||lower(l_legislation_code)||'_bee.header_check_supported; END;';
447: --
448: sql_curs := dbms_sql.open_cursor;
449: --
450: dbms_sql.parse(sql_curs,
451: statem,
452: dbms_sql.v7);

Line 450: dbms_sql.parse(sql_curs,

446: :header_check := pay_'||lower(l_legislation_code)||'_bee.header_check_supported; END;';
447: --
448: sql_curs := dbms_sql.open_cursor;
449: --
450: dbms_sql.parse(sql_curs,
451: statem,
452: dbms_sql.v7);
453: --
454: dbms_sql.bind_variable(sql_curs, 'header_check', l_header_check);

Line 452: dbms_sql.v7);

448: sql_curs := dbms_sql.open_cursor;
449: --
450: dbms_sql.parse(sql_curs,
451: statem,
452: dbms_sql.v7);
453: --
454: dbms_sql.bind_variable(sql_curs, 'header_check', l_header_check);
455: --
456: rows_processed := dbms_sql.execute(sql_curs);

Line 454: dbms_sql.bind_variable(sql_curs, 'header_check', l_header_check);

450: dbms_sql.parse(sql_curs,
451: statem,
452: dbms_sql.v7);
453: --
454: dbms_sql.bind_variable(sql_curs, 'header_check', l_header_check);
455: --
456: rows_processed := dbms_sql.execute(sql_curs);
457: --
458: dbms_sql.variable_value(sql_curs, 'header_check', l_header_check);

Line 456: rows_processed := dbms_sql.execute(sql_curs);

452: dbms_sql.v7);
453: --
454: dbms_sql.bind_variable(sql_curs, 'header_check', l_header_check);
455: --
456: rows_processed := dbms_sql.execute(sql_curs);
457: --
458: dbms_sql.variable_value(sql_curs, 'header_check', l_header_check);
459: --
460: dbms_sql.close_cursor(sql_curs);

Line 458: dbms_sql.variable_value(sql_curs, 'header_check', l_header_check);

454: dbms_sql.bind_variable(sql_curs, 'header_check', l_header_check);
455: --
456: rows_processed := dbms_sql.execute(sql_curs);
457: --
458: dbms_sql.variable_value(sql_curs, 'header_check', l_header_check);
459: --
460: dbms_sql.close_cursor(sql_curs);
461: --
462: if l_header_check = 0 then

Line 460: dbms_sql.close_cursor(sql_curs);

456: rows_processed := dbms_sql.execute(sql_curs);
457: --
458: dbms_sql.variable_value(sql_curs, 'header_check', l_header_check);
459: --
460: dbms_sql.close_cursor(sql_curs);
461: --
462: if l_header_check = 0 then
463: l_leg_header_check := TRUE;
464: else

Line 473: if dbms_sql.is_open(sql_curs) then

469: exception
470: when others then
471: l_leg_header_check := FALSE;
472: --
473: if dbms_sql.is_open(sql_curs) then
474: dbms_sql.close_cursor(sql_curs);
475: end if;
476: --
477: end;

Line 474: dbms_sql.close_cursor(sql_curs);

470: when others then
471: l_leg_header_check := FALSE;
472: --
473: if dbms_sql.is_open(sql_curs) then
474: dbms_sql.close_cursor(sql_curs);
475: end if;
476: --
477: end;
478: --

Line 486: -- sql_curs := dbms_sql.open_cursor;

482: -- begin
483: -- statem := 'BEGIN
484: -- :line_check := pay_'||lower(l_legislation_code)||'_bee.line_check_supported; END;';
485: -- --
486: -- sql_curs := dbms_sql.open_cursor;
487: -- --
488: -- dbms_sql.parse(sql_curs,
489: -- statem,
490: -- dbms_sql.v7);

Line 488: -- dbms_sql.parse(sql_curs,

484: -- :line_check := pay_'||lower(l_legislation_code)||'_bee.line_check_supported; END;';
485: -- --
486: -- sql_curs := dbms_sql.open_cursor;
487: -- --
488: -- dbms_sql.parse(sql_curs,
489: -- statem,
490: -- dbms_sql.v7);
491: -- --
492: -- dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);

Line 490: -- dbms_sql.v7);

486: -- sql_curs := dbms_sql.open_cursor;
487: -- --
488: -- dbms_sql.parse(sql_curs,
489: -- statem,
490: -- dbms_sql.v7);
491: -- --
492: -- dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
493: -- --
494: -- rows_processed := dbms_sql.execute(sql_curs);

Line 492: -- dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);

488: -- dbms_sql.parse(sql_curs,
489: -- statem,
490: -- dbms_sql.v7);
491: -- --
492: -- dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
493: -- --
494: -- rows_processed := dbms_sql.execute(sql_curs);
495: -- --
496: -- dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);

Line 494: -- rows_processed := dbms_sql.execute(sql_curs);

490: -- dbms_sql.v7);
491: -- --
492: -- dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
493: -- --
494: -- rows_processed := dbms_sql.execute(sql_curs);
495: -- --
496: -- dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);
497: -- --
498: -- dbms_sql.close_cursor(sql_curs);

Line 496: -- dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);

492: -- dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
493: -- --
494: -- rows_processed := dbms_sql.execute(sql_curs);
495: -- --
496: -- dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);
497: -- --
498: -- dbms_sql.close_cursor(sql_curs);
499: -- --
500: -- if l_line_check = 0 then

Line 498: -- dbms_sql.close_cursor(sql_curs);

494: -- rows_processed := dbms_sql.execute(sql_curs);
495: -- --
496: -- dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);
497: -- --
498: -- dbms_sql.close_cursor(sql_curs);
499: -- --
500: -- if l_line_check = 0 then
501: -- l_leg_line_check := TRUE;
502: -- else

Line 510: -- if dbms_sql.is_open(sql_curs) then

506: -- exception
507: -- when others then
508: -- l_leg_line_check := FALSE;
509: -- --
510: -- if dbms_sql.is_open(sql_curs) then
511: -- dbms_sql.close_cursor(sql_curs);
512: -- end if;
513: -- --
514: -- end;

Line 511: -- dbms_sql.close_cursor(sql_curs);

507: -- when others then
508: -- l_leg_line_check := FALSE;
509: -- --
510: -- if dbms_sql.is_open(sql_curs) then
511: -- dbms_sql.close_cursor(sql_curs);
512: -- end if;
513: -- --
514: -- end;
515: --

Line 1786: sql_curs := dbms_sql.open_cursor;

1782: begin
1783: statem := 'BEGIN
1784: pay_'||lower(l_legislation_code)||'_bee.validate_header(:batch_id, :valid, :leg_message); END;';
1785: --
1786: sql_curs := dbms_sql.open_cursor;
1787: --
1788: dbms_sql.parse(sql_curs,
1789: statem,
1790: dbms_sql.v7);

Line 1788: dbms_sql.parse(sql_curs,

1784: pay_'||lower(l_legislation_code)||'_bee.validate_header(:batch_id, :valid, :leg_message); END;';
1785: --
1786: sql_curs := dbms_sql.open_cursor;
1787: --
1788: dbms_sql.parse(sql_curs,
1789: statem,
1790: dbms_sql.v7);
1791: --
1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);

Line 1790: dbms_sql.v7);

1786: sql_curs := dbms_sql.open_cursor;
1787: --
1788: dbms_sql.parse(sql_curs,
1789: statem,
1790: dbms_sql.v7);
1791: --
1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);
1793: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);

Line 1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);

1788: dbms_sql.parse(sql_curs,
1789: statem,
1790: dbms_sql.v7);
1791: --
1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);
1793: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
1795: --
1796: rows_processed := dbms_sql.execute(sql_curs);

Line 1793: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);

1789: statem,
1790: dbms_sql.v7);
1791: --
1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);
1793: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
1795: --
1796: rows_processed := dbms_sql.execute(sql_curs);
1797: --

Line 1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);

1790: dbms_sql.v7);
1791: --
1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);
1793: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
1795: --
1796: rows_processed := dbms_sql.execute(sql_curs);
1797: --
1798: dbms_sql.variable_value(sql_curs, 'valid', l_valid);

Line 1796: rows_processed := dbms_sql.execute(sql_curs);

1792: dbms_sql.bind_variable(sql_curs, 'batch_id', p_batch_id);
1793: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
1795: --
1796: rows_processed := dbms_sql.execute(sql_curs);
1797: --
1798: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
1799: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
1800: --

Line 1798: dbms_sql.variable_value(sql_curs, 'valid', l_valid);

1794: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
1795: --
1796: rows_processed := dbms_sql.execute(sql_curs);
1797: --
1798: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
1799: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
1800: --
1801: dbms_sql.close_cursor(sql_curs);
1802: --

Line 1799: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);

1795: --
1796: rows_processed := dbms_sql.execute(sql_curs);
1797: --
1798: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
1799: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
1800: --
1801: dbms_sql.close_cursor(sql_curs);
1802: --
1803: exception

Line 1801: dbms_sql.close_cursor(sql_curs);

1797: --
1798: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
1799: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
1800: --
1801: dbms_sql.close_cursor(sql_curs);
1802: --
1803: exception
1804: when others then
1805: --

Line 1806: if dbms_sql.is_open(sql_curs) then

1802: --
1803: exception
1804: when others then
1805: --
1806: if dbms_sql.is_open(sql_curs) then
1807: dbms_sql.close_cursor(sql_curs);
1808: end if;
1809: --
1810: -- update pay_batch_headers bah

Line 1807: dbms_sql.close_cursor(sql_curs);

1803: exception
1804: when others then
1805: --
1806: if dbms_sql.is_open(sql_curs) then
1807: dbms_sql.close_cursor(sql_curs);
1808: end if;
1809: --
1810: -- update pay_batch_headers bah
1811: -- set bah.batch_status = 'E'

Line 3141: dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);

3137: :line_check := pay_'||lower(l_legislation_code)||'_bee.line_check_supported; END;';
3138: --
3139: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3140: --
3141: dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
3142: --
3143: rows_processed := dbms_sql.execute(sql_curs);
3144: --
3145: dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);

Line 3143: rows_processed := dbms_sql.execute(sql_curs);

3139: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3140: --
3141: dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
3142: --
3143: rows_processed := dbms_sql.execute(sql_curs);
3144: --
3145: dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);
3146: --
3147: if l_line_check = 0 then

Line 3145: dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);

3141: dbms_sql.bind_variable(sql_curs, 'line_check', l_line_check);
3142: --
3143: rows_processed := dbms_sql.execute(sql_curs);
3144: --
3145: dbms_sql.variable_value(sql_curs, 'line_check', l_line_check);
3146: --
3147: if l_line_check = 0 then
3148: l_leg_line_check := TRUE;
3149: else

Line 3918: dbms_sql.bind_variable(sql_curs, 'batch_line_id', g_line_record.batch_line_id);

3914: pay_'||lower(l_legislation_code)||'_bee.validate_line(:batch_line_id, :valid, :leg_message, :line_changed); END;';
3915: --
3916: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3917: --
3918: dbms_sql.bind_variable(sql_curs, 'batch_line_id', g_line_record.batch_line_id);
3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);
3922: --

Line 3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);

3915: --
3916: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3917: --
3918: dbms_sql.bind_variable(sql_curs, 'batch_line_id', g_line_record.batch_line_id);
3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);
3922: --
3923: rows_processed := dbms_sql.execute(sql_curs);

Line 3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);

3916: if pay_core_utils.get_sql_cursor(statem,sql_curs) then
3917: --
3918: dbms_sql.bind_variable(sql_curs, 'batch_line_id', g_line_record.batch_line_id);
3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);
3922: --
3923: rows_processed := dbms_sql.execute(sql_curs);
3924: --

Line 3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);

3917: --
3918: dbms_sql.bind_variable(sql_curs, 'batch_line_id', g_line_record.batch_line_id);
3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);
3922: --
3923: rows_processed := dbms_sql.execute(sql_curs);
3924: --
3925: dbms_sql.variable_value(sql_curs, 'valid', l_valid);

Line 3923: rows_processed := dbms_sql.execute(sql_curs);

3919: dbms_sql.bind_variable(sql_curs, 'valid', l_valid);
3920: dbms_sql.bind_variable(sql_curs, 'leg_message', l_leg_message, 240);
3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);
3922: --
3923: rows_processed := dbms_sql.execute(sql_curs);
3924: --
3925: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
3926: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
3927: dbms_sql.variable_value(sql_curs, 'line_changed', l_line_changed);

Line 3925: dbms_sql.variable_value(sql_curs, 'valid', l_valid);

3921: dbms_sql.bind_variable(sql_curs, 'line_changed', l_line_changed);
3922: --
3923: rows_processed := dbms_sql.execute(sql_curs);
3924: --
3925: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
3926: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
3927: dbms_sql.variable_value(sql_curs, 'line_changed', l_line_changed);
3928: --
3929: else

Line 3926: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);

3922: --
3923: rows_processed := dbms_sql.execute(sql_curs);
3924: --
3925: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
3926: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
3927: dbms_sql.variable_value(sql_curs, 'line_changed', l_line_changed);
3928: --
3929: else
3930: raise error_occurred;

Line 3927: dbms_sql.variable_value(sql_curs, 'line_changed', l_line_changed);

3923: rows_processed := dbms_sql.execute(sql_curs);
3924: --
3925: dbms_sql.variable_value(sql_curs, 'valid', l_valid);
3926: dbms_sql.variable_value(sql_curs, 'leg_message', l_leg_message);
3927: dbms_sql.variable_value(sql_curs, 'line_changed', l_line_changed);
3928: --
3929: else
3930: raise error_occurred;
3931: end if;