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

Line 483: sql_curs := dbms_sql.open_cursor;

479: into :identifier_value
480: from dual;
481: END;';
482: --
483: sql_curs := dbms_sql.open_cursor;
484: --
485: dbms_sql.parse(sql_curs,
486: statem,
487: dbms_sql.v7);

Line 485: dbms_sql.parse(sql_curs,

481: END;';
482: --
483: sql_curs := dbms_sql.open_cursor;
484: --
485: dbms_sql.parse(sql_curs,
486: statem,
487: dbms_sql.v7);
488: --
489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);

Line 487: dbms_sql.v7);

483: sql_curs := dbms_sql.open_cursor;
484: --
485: dbms_sql.parse(sql_curs,
486: statem,
487: dbms_sql.v7);
488: --
489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);
490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);

Line 489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);

485: dbms_sql.parse(sql_curs,
486: statem,
487: dbms_sql.v7);
488: --
489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);
490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);

Line 490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);

486: statem,
487: dbms_sql.v7);
488: --
489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);
490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);

Line 491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);

487: dbms_sql.v7);
488: --
489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);
490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);

Line 492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);

488: --
489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);
490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);

Line 493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);

489: dbms_sql.bind_variable(sql_curs, 'p_effective_date', p_effective_date);
490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);

Line 494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);

490: dbms_sql.bind_variable(sql_curs, 'p_identifier_name', p_identifier_name);
491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);
498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);

Line 495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);

491: dbms_sql.bind_variable(sql_curs, 'p_payroll_action_id', p_payroll_action_id);
492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);
498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);
499: --

Line 496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);

492: dbms_sql.bind_variable(sql_curs, 'p_payment_type_id', p_payment_type_id);
493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);
498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);
499: --
500: rows_processed := dbms_sql.execute(sql_curs);

Line 497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);

493: dbms_sql.bind_variable(sql_curs, 'p_org_payment_method_id', p_org_payment_method_id);
494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);
498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);
499: --
500: rows_processed := dbms_sql.execute(sql_curs);
501: --

Line 498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);

494: dbms_sql.bind_variable(sql_curs, 'p_personal_payment_method_id', p_personal_payment_method_id);
495: dbms_sql.bind_variable(sql_curs, 'p_assignment_action_id', p_assignment_action_id);
496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);
498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);
499: --
500: rows_processed := dbms_sql.execute(sql_curs);
501: --
502: dbms_sql.variable_value(sql_curs, 'identifier_value', l_identifier_value);

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

496: dbms_sql.bind_variable(sql_curs, 'p_pre_payment_id', p_pre_payment_id);
497: dbms_sql.bind_variable(sql_curs, 'p_delimiter_string', p_delimiter_string);
498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);
499: --
500: rows_processed := dbms_sql.execute(sql_curs);
501: --
502: dbms_sql.variable_value(sql_curs, 'identifier_value', l_identifier_value);
503: --
504: dbms_sql.close_cursor(sql_curs);

Line 502: dbms_sql.variable_value(sql_curs, 'identifier_value', l_identifier_value);

498: dbms_sql.bind_variable(sql_curs, 'identifier_value', l_identifier_value,255);
499: --
500: rows_processed := dbms_sql.execute(sql_curs);
501: --
502: dbms_sql.variable_value(sql_curs, 'identifier_value', l_identifier_value);
503: --
504: dbms_sql.close_cursor(sql_curs);
505: --
506: exception

Line 504: dbms_sql.close_cursor(sql_curs);

500: rows_processed := dbms_sql.execute(sql_curs);
501: --
502: dbms_sql.variable_value(sql_curs, 'identifier_value', l_identifier_value);
503: --
504: dbms_sql.close_cursor(sql_curs);
505: --
506: exception
507: when others then
508: --

Line 509: if dbms_sql.is_open(sql_curs) then

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

Line 510: dbms_sql.close_cursor(sql_curs);

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