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 PAY_PAYSLIP_REPORT

Line 1: PACKAGE BODY pay_payslip_report AS

1: PACKAGE BODY pay_payslip_report AS
2: /* $Header: pygpsrep.pkb 120.2.12020000.3 2012/07/06 10:46:43 vmaripal ship $ */
3: --
4: -- Globals
5: --

Line 261: IF pay_payslip_report.g_pa_token IS NULL THEN

257: l_start_dt := TO_DATE(l_start_date,'YYYY/MM/DD');
258: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
259: --EXECUTE IMMEDIATE 'SELECT pay_'||l_legislation_code||'_rules.get_payroll_token FROM DUAL' into l_token;
260: --
261: IF pay_payslip_report.g_pa_token IS NULL THEN
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);

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 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 278: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

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');
280: --
281: IF dbms_sql.IS_OPEN(sql_cur) THEN
282: dbms_sql.close_cursor(sql_cur);

Line 279: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');

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');
280: --
281: IF dbms_sql.IS_OPEN(sql_cur) THEN
282: dbms_sql.close_cursor(sql_cur);
283: END IF;

Line 310: ,pay_payslip_report.g_pa_token

306: ,l_payroll_id
307: ,l_consolidation_set_id
308: ,l_start_dt
309: ,l_end_dt
310: ,pay_payslip_report.g_pa_token
311: ,pay_payslip_report.g_cs_token
312: ,l_legislation_code );
313: FETCH csr_asg INTO l_qualifier;
314: CLOSE csr_asg;

Line 311: ,pay_payslip_report.g_cs_token

307: ,l_consolidation_set_id
308: ,l_start_dt
309: ,l_end_dt
310: ,pay_payslip_report.g_pa_token
311: ,pay_payslip_report.g_cs_token
312: ,l_legislation_code );
313: FETCH csr_asg INTO l_qualifier;
314: CLOSE csr_asg;
315: --

Line 337: ,pay_payslip_report.g_pa_token

333: ,l_payroll_id
334: ,l_consolidation_set_id
335: ,l_start_dt
336: ,l_end_dt
337: ,pay_payslip_report.g_pa_token
338: ,pay_payslip_report.g_cs_token
339: ,l_legislation_code
340: ,l_assignment_set_id );
341: FETCH csr_inc_asg INTO l_qualifier;

Line 338: ,pay_payslip_report.g_cs_token

334: ,l_consolidation_set_id
335: ,l_start_dt
336: ,l_end_dt
337: ,pay_payslip_report.g_pa_token
338: ,pay_payslip_report.g_cs_token
339: ,l_legislation_code
340: ,l_assignment_set_id );
341: FETCH csr_inc_asg INTO l_qualifier;
342: CLOSE csr_inc_asg;

Line 431: IF pay_payslip_report.g_pa_token IS NULL THEN

427: ,l_business_group_id
428: ,l_legislation_code);
429:
430: /*Begin Bug 8350884 */
431: IF pay_payslip_report.g_pa_token IS NULL THEN
432: DECLARE
433: BEGIN
434: statem := 'BEGIN pay_'||l_legislation_code||'_rules.get_token_names(:p_pa_token, :p_cs_token); END;';
435: --hr_utility.trace(statem);

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

436: sql_cur := dbms_sql.open_cursor;
437: dbms_sql.parse(sql_cur
438: ,statem
439: ,dbms_sql.v7);
440: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
441: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
442: l_rows := dbms_sql.execute(sql_cur);
443: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
444: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

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

437: dbms_sql.parse(sql_cur
438: ,statem
439: ,dbms_sql.v7);
440: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
441: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
442: l_rows := dbms_sql.execute(sql_cur);
443: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
444: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
445: dbms_sql.close_cursor(sql_cur);

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

439: ,dbms_sql.v7);
440: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
441: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
442: l_rows := dbms_sql.execute(sql_cur);
443: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
444: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
445: dbms_sql.close_cursor(sql_cur);
446: Exception
447: WHEN OTHERS THEN

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

440: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
441: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
442: l_rows := dbms_sql.execute(sql_cur);
443: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
444: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
445: dbms_sql.close_cursor(sql_cur);
446: Exception
447: WHEN OTHERS THEN
448: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

Line 448: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

444: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
445: dbms_sql.close_cursor(sql_cur);
446: Exception
447: WHEN OTHERS THEN
448: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
449: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
450: --
451: IF dbms_sql.IS_OPEN(sql_cur) THEN
452: dbms_sql.close_cursor(sql_cur);

Line 449: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');

445: dbms_sql.close_cursor(sql_cur);
446: Exception
447: WHEN OTHERS THEN
448: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
449: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
450: --
451: IF dbms_sql.IS_OPEN(sql_cur) THEN
452: dbms_sql.close_cursor(sql_cur);
453: END IF;

Line 492: ,pay_payslip_report.g_pa_token

488: FOR csr_archive_act_rec in csr_archive_act(l_payroll_id
489: ,l_consolidation_set_id
490: ,l_start_dt
491: ,l_end_dt
492: ,pay_payslip_report.g_pa_token
493: ,pay_payslip_report.g_cs_token
494: ,l_legislation_code) LOOP
495: --
496: pay_payroll_xml_extract_pkg.generate(

Line 493: ,pay_payslip_report.g_cs_token

489: ,l_consolidation_set_id
490: ,l_start_dt
491: ,l_end_dt
492: ,pay_payslip_report.g_pa_token
493: ,pay_payslip_report.g_cs_token
494: ,l_legislation_code) LOOP
495: --
496: pay_payroll_xml_extract_pkg.generate(
497: P_ACTION_CONTEXT_ID => csr_archive_act_rec.action_context_id

Line 512: END pay_payslip_report;

508: pay_core_files.write_to_magtape_lob('');
509: --
510: END xml_asg;
511: --
512: END pay_payslip_report;