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_RETRO_NOTIF_PKG dependencies on PAY_CORE_UTILS

Line 36: nvl(to_date( pay_core_utils.get_parameter('REPORT_DATE',

32: l_report_date date;
33: begin
34: select legislative_parameters,
35: business_group_id,
36: nvl(to_date( pay_core_utils.get_parameter('REPORT_DATE',
37: l_legparam)
38: ,'DD/MM/YYYYHH24:MI:SS'),
39: effective_date)
40: into l_legparam,

Line 46: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);

42: l_report_date
43: from pay_payroll_actions
44: where payroll_action_id = pactid;
45: --
46: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
47: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
48: l_evt_grp_id := pay_core_utils.get_parameter('EVT_GRP_ID', l_legparam);
49: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
50: --

Line 47: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;

43: from pay_payroll_actions
44: where payroll_action_id = pactid;
45: --
46: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
47: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
48: l_evt_grp_id := pay_core_utils.get_parameter('EVT_GRP_ID', l_legparam);
49: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
50: --
51: p_asg_set_name := l_asg_set_name;

Line 48: l_evt_grp_id := pay_core_utils.get_parameter('EVT_GRP_ID', l_legparam);

44: where payroll_action_id = pactid;
45: --
46: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
47: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
48: l_evt_grp_id := pay_core_utils.get_parameter('EVT_GRP_ID', l_legparam);
49: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
50: --
51: p_asg_set_name := l_asg_set_name;
52: p_payroll := l_payroll_id;

Line 49: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);

45: --
46: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
47: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
48: l_evt_grp_id := pay_core_utils.get_parameter('EVT_GRP_ID', l_legparam);
49: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
50: --
51: p_asg_set_name := l_asg_set_name;
52: p_payroll := l_payroll_id;
53: p_bus_grp := l_bus_grp;

Line 1423: pay_core_utils.get_parameter(''PAYROLL_ID'',

1419: per_assignments_f asg,
1420: pay_payroll_actions pa1
1421: where pa1.payroll_action_id = :payroll_action_id
1422: and asg.payroll_id =
1423: pay_core_utils.get_parameter(''PAYROLL_ID'',
1424: pa1.legislative_parameters)
1425: and pa1.effective_date between asg.effective_start_date
1426: and asg.effective_end_date
1427: order by asg.person_id';

Line 1436: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);

1432: l_bus_grp
1433: from pay_payroll_actions
1434: where payroll_action_id = pactid;
1435: --
1436: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1437: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
1438: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
1439: --
1440: -- if old style then create an assignment set

Line 1437: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;

1433: from pay_payroll_actions
1434: where payroll_action_id = pactid;
1435: --
1436: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1437: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
1438: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
1439: --
1440: -- if old style then create an assignment set
1441: if (l_adv_flag is null) then

Line 1438: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);

1434: where payroll_action_id = pactid;
1435: --
1436: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1437: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
1438: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
1439: --
1440: -- if old style then create an assignment set
1441: if (l_adv_flag is null) then
1442: l_adv_flag := 'N';

Line 1477: pay_core_utils.get_parameter('PAYROLL_ID',

1473: per_assignments_f paf,
1474: pay_payroll_actions ppa
1475: where ppa.payroll_action_id = pactid
1476: and paf.payroll_id =
1477: pay_core_utils.get_parameter('PAYROLL_ID',
1478: ppa.legislative_parameters)
1479: and pos.period_of_service_id = paf.period_of_service_id
1480: and pos.person_id = paf.person_id
1481: and pos.person_id between stperson and endperson

Line 1507: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)

1503: per_periods_of_service pos,
1504: per_assignments_f paf,
1505: pay_payroll_actions ppa
1506: where ppa.payroll_action_id = pactid
1507: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)
1508: and pos.period_of_service_id = paf.period_of_service_id
1509: and pos.person_id = paf.person_id
1510: AND ppa.payroll_action_id = ppr.payroll_action_id
1511: AND ppr.chunk_number = chunk

Line 1643: select pay_core_utils.get_parameter('REMOVE_ACT',

1639: --
1640: -- Now we need to generate the report and delete the
1641: -- output if required
1642: --
1643: select pay_core_utils.get_parameter('REMOVE_ACT',
1644: pa1.legislative_parameters),
1645: pay_core_utils.get_parameter('GEN_REPORT',
1646: pa1.legislative_parameters)
1647: into remove_act,

Line 1645: pay_core_utils.get_parameter('GEN_REPORT',

1641: -- output if required
1642: --
1643: select pay_core_utils.get_parameter('REMOVE_ACT',
1644: pa1.legislative_parameters),
1645: pay_core_utils.get_parameter('GEN_REPORT',
1646: pa1.legislative_parameters)
1647: into remove_act,
1648: l_generate_report
1649: from pay_payroll_actions pa1