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

Line 241: sql_cur := dbms_sql.open_cursor;

237: DECLARE
238: BEGIN
239: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
240: --hr_utility.trace(statem);
241: sql_cur := dbms_sql.open_cursor;
242: dbms_sql.parse(sql_cur
243: ,statem
244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);

Line 242: dbms_sql.parse(sql_cur

238: BEGIN
239: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
240: --hr_utility.trace(statem);
241: sql_cur := dbms_sql.open_cursor;
242: dbms_sql.parse(sql_cur
243: ,statem
244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);

Line 244: ,dbms_sql.v7);

240: --hr_utility.trace(statem);
241: sql_cur := dbms_sql.open_cursor;
242: dbms_sql.parse(sql_cur
243: ,statem
244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);

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

241: sql_cur := dbms_sql.open_cursor;
242: dbms_sql.parse(sql_cur
243: ,statem
244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
249: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);

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

242: dbms_sql.parse(sql_cur
243: ,statem
244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
249: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
250: dbms_sql.close_cursor(sql_cur);

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

243: ,statem
244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
249: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
250: dbms_sql.close_cursor(sql_cur);
251: Exception

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

244: ,dbms_sql.v7);
245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
249: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
250: dbms_sql.close_cursor(sql_cur);
251: Exception
252: WHEN OTHERS THEN

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

245: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
249: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
250: dbms_sql.close_cursor(sql_cur);
251: Exception
252: WHEN OTHERS THEN
253: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');

Line 250: dbms_sql.close_cursor(sql_cur);

246: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
247: l_rows := dbms_sql.execute(sql_cur);
248: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
249: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
250: dbms_sql.close_cursor(sql_cur);
251: Exception
252: WHEN OTHERS THEN
253: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');
254: g_cs_token := NVL(g_cs_token,'CONSOLIDATION_SET_ID');

Line 256: IF dbms_sql.IS_OPEN(sql_cur) THEN

252: WHEN OTHERS THEN
253: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');
254: g_cs_token := NVL(g_cs_token,'CONSOLIDATION_SET_ID');
255: --
256: IF dbms_sql.IS_OPEN(sql_cur) THEN
257: dbms_sql.close_cursor(sql_cur);
258: END IF;
259: END;
260: END IF;

Line 257: dbms_sql.close_cursor(sql_cur);

253: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');
254: g_cs_token := NVL(g_cs_token,'CONSOLIDATION_SET_ID');
255: --
256: IF dbms_sql.IS_OPEN(sql_cur) THEN
257: dbms_sql.close_cursor(sql_cur);
258: END IF;
259: END;
260: END IF;
261: --