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 1488: pay_core_utils.get_parameter(''PAYROLL_ID'',

1484: per_assignments_f asg,
1485: pay_payroll_actions pa1
1486: where pa1.payroll_action_id = :payroll_action_id
1487: and asg.payroll_id =
1488: pay_core_utils.get_parameter(''PAYROLL_ID'',
1489: pa1.legislative_parameters)
1490: and pa1.effective_date between asg.effective_start_date
1491: and asg.effective_end_date
1492: order by asg.person_id';

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

1497: l_bus_grp
1498: from pay_payroll_actions
1499: where payroll_action_id = pactid;
1500: --
1501: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1502: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
1503: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
1504: --
1505: -- if old style then create an assignment set

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

1498: from pay_payroll_actions
1499: where payroll_action_id = pactid;
1500: --
1501: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1502: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
1503: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
1504: --
1505: -- if old style then create an assignment set
1506: if (l_adv_flag is null) then

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

1499: where payroll_action_id = pactid;
1500: --
1501: l_payroll_id := pay_core_utils.get_parameter('PAYROLL_ID', l_legparam);
1502: l_asg_set_name := pay_core_utils.get_parameter('ASG_SET', l_legparam)||'_'||pactid;
1503: l_adv_flag := pay_core_utils.get_parameter('ADV_FLAG', l_legparam);
1504: --
1505: -- if old style then create an assignment set
1506: if (l_adv_flag is null) then
1507: l_adv_flag := 'N';

Line 1542: pay_core_utils.get_parameter('PAYROLL_ID',

1538: per_assignments_f paf,
1539: pay_payroll_actions ppa
1540: where ppa.payroll_action_id = pactid
1541: and paf.payroll_id =
1542: pay_core_utils.get_parameter('PAYROLL_ID',
1543: ppa.legislative_parameters)
1544: and pos.period_of_service_id = paf.period_of_service_id
1545: and pos.person_id = paf.person_id
1546: and pos.person_id between stperson and endperson

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

1568: per_periods_of_service pos,
1569: per_assignments_f paf,
1570: pay_payroll_actions ppa
1571: where ppa.payroll_action_id = pactid
1572: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)
1573: and pos.period_of_service_id = paf.period_of_service_id
1574: and pos.person_id = paf.person_id
1575: AND ppa.payroll_action_id = ppr.payroll_action_id
1576: AND ppr.chunk_number = chunk

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

1704: --
1705: -- Now we need to generate the report and delete the
1706: -- output if required
1707: --
1708: select pay_core_utils.get_parameter('REMOVE_ACT',
1709: pa1.legislative_parameters),
1710: pay_core_utils.get_parameter('GEN_REPORT',
1711: pa1.legislative_parameters)
1712: into remove_act,

Line 1710: pay_core_utils.get_parameter('GEN_REPORT',

1706: -- output if required
1707: --
1708: select pay_core_utils.get_parameter('REMOVE_ACT',
1709: pa1.legislative_parameters),
1710: pay_core_utils.get_parameter('GEN_REPORT',
1711: pa1.legislative_parameters)
1712: into remove_act,
1713: l_generate_report
1714: from pay_payroll_actions pa1