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

Line 266: sql_cur := dbms_sql.open_cursor;

262: DECLARE
263: BEGIN
264: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
265: --hr_utility.trace(statem);
266: sql_cur := dbms_sql.open_cursor;
267: dbms_sql.parse(sql_cur
268: ,statem
269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);

Line 267: dbms_sql.parse(sql_cur

263: BEGIN
264: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
265: --hr_utility.trace(statem);
266: sql_cur := dbms_sql.open_cursor;
267: dbms_sql.parse(sql_cur
268: ,statem
269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);

Line 269: ,dbms_sql.v7);

265: --hr_utility.trace(statem);
266: sql_cur := dbms_sql.open_cursor;
267: dbms_sql.parse(sql_cur
268: ,statem
269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);

Line 270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);

266: sql_cur := dbms_sql.open_cursor;
267: dbms_sql.parse(sql_cur
268: ,statem
269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

Line 271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);

267: dbms_sql.parse(sql_cur
268: ,statem
269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
275: dbms_sql.close_cursor(sql_cur);

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

268: ,statem
269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
275: dbms_sql.close_cursor(sql_cur);
276: Exception

Line 273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);

269: ,dbms_sql.v7);
270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
275: dbms_sql.close_cursor(sql_cur);
276: Exception
277: WHEN OTHERS THEN

Line 274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

270: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
275: dbms_sql.close_cursor(sql_cur);
276: Exception
277: WHEN OTHERS THEN
278: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

Line 275: dbms_sql.close_cursor(sql_cur);

271: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
272: l_rows := dbms_sql.execute(sql_cur);
273: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
274: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
275: dbms_sql.close_cursor(sql_cur);
276: Exception
277: WHEN OTHERS THEN
278: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
279: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');

Line 281: IF dbms_sql.IS_OPEN(sql_cur) THEN

277: WHEN OTHERS THEN
278: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
279: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
280: --
281: IF dbms_sql.IS_OPEN(sql_cur) THEN
282: dbms_sql.close_cursor(sql_cur);
283: END IF;
284: END;
285: END IF;

Line 282: dbms_sql.close_cursor(sql_cur);

278: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
279: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
280: --
281: IF dbms_sql.IS_OPEN(sql_cur) THEN
282: dbms_sql.close_cursor(sql_cur);
283: END IF;
284: END;
285: END IF;
286: --