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.PYCADAR_PKG dependencies on PAY_PAYSLIP_REPORT

Line 1281: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))

1277: AND c_end_date
1278: AND ppa.report_type = hrl.meaning
1279: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1280: AND hrl.lookup_code = c_legislation_code
1281: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1282: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1283: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1284:
1285: --

Line 1282: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)

1278: AND ppa.report_type = hrl.meaning
1279: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1280: AND hrl.lookup_code = c_legislation_code
1281: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1282: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1283: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1284:
1285: --
1286: --

Line 1283: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)

1279: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1280: AND hrl.lookup_code = c_legislation_code
1281: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1282: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1283: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1284:
1285: --
1286: --
1287: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1326: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))

1322: AND c_end_date
1323: AND ppa.report_type = hrl.meaning
1324: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1325: AND hrl.lookup_code = c_legislation_code
1326: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1327: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1328: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1329: AND ppa.payroll_action_id = paa.payroll_action_id
1330: --AND paa.source_action_id IS NULL --RLN P1 894102

Line 1327: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)

1323: AND ppa.report_type = hrl.meaning
1324: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1325: AND hrl.lookup_code = c_legislation_code
1326: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1327: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1328: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1329: AND ppa.payroll_action_id = paa.payroll_action_id
1330: --AND paa.source_action_id IS NULL --RLN P1 894102
1331: AND paa.assignment_id = hasa.assignment_id

Line 1328: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)

1324: AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
1325: AND hrl.lookup_code = c_legislation_code
1326: AND NVL(c_payroll_id,NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1))
1327: = NVL(pay_payslip_report.get_parameter(ppa.legislative_parameters,c_pa_token),-1)
1328: AND c_consolidation_set_id = pay_payslip_report.get_parameter(ppa.legislative_parameters,c_cs_token)
1329: AND ppa.payroll_action_id = paa.payroll_action_id
1330: --AND paa.source_action_id IS NULL --RLN P1 894102
1331: AND paa.assignment_id = hasa.assignment_id
1332: AND hasa.assignment_set_id = c_assignment_set_id

Line 1372: pay_payslip_report.get_all_parameters(l_actid

1368:
1369: IF pycadar_pkg.g_payroll_act_id <> ln_curr_payroll_act_id THEN
1370: pycadar_pkg.g_payroll_act_id := ln_curr_payroll_act_id;
1371:
1372: pay_payslip_report.get_all_parameters(l_actid
1373: ,l_payroll_id
1374: ,l_consolidation_set_id
1375: ,l_start_date
1376: ,l_end_date

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

1421: sql_cur := dbms_sql.open_cursor;
1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);

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

1422: dbms_sql.parse(sql_cur
1423: ,statem
1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);

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

1424: ,dbms_sql.v7);
1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN

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

1425: dbms_sql.bind_variable(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token, 50);
1426: dbms_sql.bind_variable(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token, 50);
1427: l_rows := dbms_sql.execute(sql_cur);
1428: dbms_sql.variable_value(sql_cur, 'p_pa_token', pay_payslip_report.g_pa_token);
1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN
1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');

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

1429: dbms_sql.variable_value(sql_cur, 'p_cs_token', pay_payslip_report.g_cs_token);
1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN
1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1434: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1435: --
1436: IF dbms_sql.IS_OPEN(sql_cur) THEN
1437: dbms_sql.close_cursor(sql_cur);

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

1430: dbms_sql.close_cursor(sql_cur);
1431: Exception
1432: WHEN OTHERS THEN
1433: pay_payslip_report.g_pa_token := NVL(pay_payslip_report.g_pa_token,'PAYROLL_ID');
1434: pay_payslip_report.g_cs_token := NVL(pay_payslip_report.g_cs_token,'CONSOLIDATION_SET_ID');
1435: --
1436: IF dbms_sql.IS_OPEN(sql_cur) THEN
1437: dbms_sql.close_cursor(sql_cur);
1438: END IF;

Line 1442: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);

1438: END IF;
1439: END;
1440: --
1441: --
1442: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1443: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1444:
1445: IF pycadar_pkg.g_assignment_set_id IS NULL THEN
1446: OPEN csr_asg(pycadar_pkg.g_payroll_id

Line 1443: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);

1439: END;
1440: --
1441: --
1442: --hr_utility.trace('pay_payslip_report.g_pa_token :='||pay_payslip_report.g_pa_token);
1443: --hr_utility.trace('pay_payslip_report.g_cs_token :='||pay_payslip_report.g_cs_token);
1444:
1445: IF pycadar_pkg.g_assignment_set_id IS NULL THEN
1446: OPEN csr_asg(pycadar_pkg.g_payroll_id
1447: ,pycadar_pkg.g_consolidation_set_id

Line 1450: ,pay_payslip_report.g_pa_token

1446: OPEN csr_asg(pycadar_pkg.g_payroll_id
1447: ,pycadar_pkg.g_consolidation_set_id
1448: ,pycadar_pkg.g_start_dt
1449: ,pycadar_pkg.g_end_dt
1450: ,pay_payslip_report.g_pa_token
1451: ,pay_payslip_report.g_cs_token
1452: ,pycadar_pkg.g_legislation_code);
1453: LOOP
1454:

Line 1451: ,pay_payslip_report.g_cs_token

1447: ,pycadar_pkg.g_consolidation_set_id
1448: ,pycadar_pkg.g_start_dt
1449: ,pycadar_pkg.g_end_dt
1450: ,pay_payslip_report.g_pa_token
1451: ,pay_payslip_report.g_cs_token
1452: ,pycadar_pkg.g_legislation_code);
1453: LOOP
1454:
1455: ln_assignment_id := -1;

Line 1485: ,pay_payslip_report.g_pa_token

1481: OPEN csr_inc_asg(pycadar_pkg.g_payroll_id
1482: ,pycadar_pkg.g_consolidation_set_id
1483: ,pycadar_pkg.g_start_dt
1484: ,pycadar_pkg.g_end_dt
1485: ,pay_payslip_report.g_pa_token
1486: ,pay_payslip_report.g_cs_token
1487: ,pycadar_pkg.g_legislation_code
1488: ,pycadar_pkg.g_assignment_set_id);
1489: LOOP

Line 1486: ,pay_payslip_report.g_cs_token

1482: ,pycadar_pkg.g_consolidation_set_id
1483: ,pycadar_pkg.g_start_dt
1484: ,pycadar_pkg.g_end_dt
1485: ,pay_payslip_report.g_pa_token
1486: ,pay_payslip_report.g_cs_token
1487: ,pycadar_pkg.g_legislation_code
1488: ,pycadar_pkg.g_assignment_set_id);
1489: LOOP
1490: