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_GB_EOY_ARCHIVE dependencies on HR_API

Line 2023: rec_prev_asg.assignment_id := hr_api.g_number;

2019: END IF; -- g_context_id IS NULL
2020: hr_utility.set_location(l_proc,13);
2021: --
2022: -- set asg backup details to unlikely values before loop.
2023: rec_prev_asg.assignment_id := hr_api.g_number;
2024: rec_prev_asg.effective_end_date := hr_api.g_date;
2025: -- loop through assignments
2026: OPEN csr_assignments ( g_min_start_year,
2027: g_max_end_year,

Line 2024: rec_prev_asg.effective_end_date := hr_api.g_date;

2020: hr_utility.set_location(l_proc,13);
2021: --
2022: -- set asg backup details to unlikely values before loop.
2023: rec_prev_asg.assignment_id := hr_api.g_number;
2024: rec_prev_asg.effective_end_date := hr_api.g_date;
2025: -- loop through assignments
2026: OPEN csr_assignments ( g_min_start_year,
2027: g_max_end_year,
2028: g_end_year,

Line 2320: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);

2316: --
2317: IF g_payroll_action_id IS NULL
2318: OR g_payroll_action_id <> p_payroll_action_id THEN
2319: g_payroll_action_id := p_payroll_action_id;
2320: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2321: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2322: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2323: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2324: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,

Line 2321: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871

2317: IF g_payroll_action_id IS NULL
2318: OR g_payroll_action_id <> p_payroll_action_id THEN
2319: g_payroll_action_id := p_payroll_action_id;
2320: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2321: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2322: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2323: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2324: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2325: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars

Line 2322: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);

2318: OR g_payroll_action_id <> p_payroll_action_id THEN
2319: g_payroll_action_id := p_payroll_action_id;
2320: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2321: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2322: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2323: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2324: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2325: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars
2326: -- set up the statutory start and end year

Line 2323: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);

2319: g_payroll_action_id := p_payroll_action_id;
2320: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2321: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2322: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2323: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2324: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2325: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars
2326: -- set up the statutory start and end year
2327: OPEN csr_parameter_info(p_payroll_action_id);

Line 2325: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars

2321: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2322: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2323: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2324: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2325: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars
2326: -- set up the statutory start and end year
2327: OPEN csr_parameter_info(p_payroll_action_id);
2328: FETCH csr_parameter_info INTO g_start_year,
2329: g_end_year,

Line 3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,

3151: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,
3158: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3159: FROM pay_assignment_actions act

Line 3158: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end

3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,
3158: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3159: FROM pay_assignment_actions act
3160: WHERE act.assignment_action_id = p_asgactid;
3161: --
3162: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS

Line 3873: g_masg_person_id := hr_api.g_number;

3869: END archive_ni_value;
3870: --
3871: PROCEDURE empty_masg_cache IS
3872: BEGIN
3873: g_masg_person_id := hr_api.g_number;
3874: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
3875: g_masg_active_start := hr_api.g_sot;
3876: g_masg_active_end := hr_api.g_eot;
3877: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263

Line 3874: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871

3870: --
3871: PROCEDURE empty_masg_cache IS
3872: BEGIN
3873: g_masg_person_id := hr_api.g_number;
3874: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
3875: g_masg_active_start := hr_api.g_sot;
3876: g_masg_active_end := hr_api.g_eot;
3877: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
3878: g_max_gross_pay := NULL;

Line 3875: g_masg_active_start := hr_api.g_sot;

3871: PROCEDURE empty_masg_cache IS
3872: BEGIN
3873: g_masg_person_id := hr_api.g_number;
3874: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
3875: g_masg_active_start := hr_api.g_sot;
3876: g_masg_active_end := hr_api.g_eot;
3877: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
3878: g_max_gross_pay := NULL;
3879: g_primary_action := NULL;

Line 3876: g_masg_active_end := hr_api.g_eot;

3872: BEGIN
3873: g_masg_person_id := hr_api.g_number;
3874: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
3875: g_masg_active_start := hr_api.g_sot;
3876: g_masg_active_end := hr_api.g_eot;
3877: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
3878: g_max_gross_pay := NULL;
3879: g_primary_action := NULL;
3880: g_min_assignment_id := NULL;

Line 3877: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263

3873: g_masg_person_id := hr_api.g_number;
3874: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
3875: g_masg_active_start := hr_api.g_sot;
3876: g_masg_active_end := hr_api.g_eot;
3877: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
3878: g_max_gross_pay := NULL;
3879: g_primary_action := NULL;
3880: g_min_assignment_id := NULL;
3881: g_ni_balance_totals := g_empty_ni_balance_totals;