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

Line 273: sql_cur := dbms_sql.open_cursor;

269: DECLARE
270: BEGIN
271: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
272: --hr_utility.trace(statem);
273: sql_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(sql_cur
275: ,statem
276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);

Line 274: dbms_sql.parse(sql_cur

270: BEGIN
271: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
272: --hr_utility.trace(statem);
273: sql_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(sql_cur
275: ,statem
276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);

Line 276: ,dbms_sql.v7);

272: --hr_utility.trace(statem);
273: sql_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(sql_cur
275: ,statem
276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);

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

273: sql_cur := dbms_sql.open_cursor;
274: dbms_sql.parse(sql_cur
275: ,statem
276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
281: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);

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

274: dbms_sql.parse(sql_cur
275: ,statem
276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
281: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
282: dbms_sql.close_cursor(sql_cur);

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

275: ,statem
276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
281: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
282: dbms_sql.close_cursor(sql_cur);
283: Exception

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

276: ,dbms_sql.v7);
277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
281: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
282: dbms_sql.close_cursor(sql_cur);
283: Exception
284: WHEN OTHERS THEN

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

277: dbms_sql.bind_variable(sql_cur, 'p_pa_token', g_pa_token, 50);
278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
281: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
282: dbms_sql.close_cursor(sql_cur);
283: Exception
284: WHEN OTHERS THEN
285: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');

Line 282: dbms_sql.close_cursor(sql_cur);

278: dbms_sql.bind_variable(sql_cur, 'p_cs_token', g_cs_token, 50);
279: l_rows := dbms_sql.execute(sql_cur);
280: dbms_sql.variable_value(sql_cur, 'p_pa_token', g_pa_token);
281: dbms_sql.variable_value(sql_cur, 'p_cs_token', g_cs_token);
282: dbms_sql.close_cursor(sql_cur);
283: Exception
284: WHEN OTHERS THEN
285: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');
286: g_cs_token := NVL(g_cs_token,'CONSOLIDATION_SET_ID');

Line 288: IF dbms_sql.IS_OPEN(sql_cur) THEN

284: WHEN OTHERS THEN
285: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');
286: g_cs_token := NVL(g_cs_token,'CONSOLIDATION_SET_ID');
287: --
288: IF dbms_sql.IS_OPEN(sql_cur) THEN
289: dbms_sql.close_cursor(sql_cur);
290: END IF;
291: END;
292: END IF;

Line 289: dbms_sql.close_cursor(sql_cur);

285: g_pa_token := NVL(g_pa_token,'PAYROLL_ID');
286: g_cs_token := NVL(g_cs_token,'CONSOLIDATION_SET_ID');
287: --
288: IF dbms_sql.IS_OPEN(sql_cur) THEN
289: dbms_sql.close_cursor(sql_cur);
290: END IF;
291: END;
292: END IF;
293: --