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 2072: rec_prev_asg.assignment_id := hr_api.g_number;

2068: END IF; -- g_context_id IS NULL
2069: hr_utility.set_location(l_proc,13);
2070: --
2071: -- set asg backup details to unlikely values before loop.
2072: rec_prev_asg.assignment_id := hr_api.g_number;
2073: rec_prev_asg.effective_end_date := hr_api.g_date;
2074: -- loop through assignments
2075: OPEN csr_assignments ( g_min_start_year,
2076: g_max_end_year,

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

2069: hr_utility.set_location(l_proc,13);
2070: --
2071: -- set asg backup details to unlikely values before loop.
2072: rec_prev_asg.assignment_id := hr_api.g_number;
2073: rec_prev_asg.effective_end_date := hr_api.g_date;
2074: -- loop through assignments
2075: OPEN csr_assignments ( g_min_start_year,
2076: g_max_end_year,
2077: g_end_year,

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

2365: --
2366: IF g_payroll_action_id IS NULL
2367: OR g_payroll_action_id <> p_payroll_action_id THEN
2368: g_payroll_action_id := p_payroll_action_id;
2369: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2370: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2371: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2372: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2373: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,

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

2366: IF g_payroll_action_id IS NULL
2367: OR g_payroll_action_id <> p_payroll_action_id THEN
2368: g_payroll_action_id := p_payroll_action_id;
2369: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2370: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2371: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2372: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2373: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2374: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars

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

2367: OR g_payroll_action_id <> p_payroll_action_id THEN
2368: g_payroll_action_id := p_payroll_action_id;
2369: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2370: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2371: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2372: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2373: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2374: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars
2375: -- set up the statutory start and end year

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

2368: g_payroll_action_id := p_payroll_action_id;
2369: g_masg_person_id := nvl(g_masg_person_id,hr_api.g_number);
2370: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2371: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2372: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2373: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2374: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars
2375: -- set up the statutory start and end year
2376: OPEN csr_parameter_info(p_payroll_action_id);

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

2370: g_masg_period_of_service_id := nvl(g_masg_period_of_service_id, hr_api.g_number); -- Bug 3784871
2371: g_masg_active_start := nvl(g_masg_active_start, hr_api.g_sot);
2372: g_masg_active_end := nvl(g_masg_active_end, hr_api.g_eot);
2373: g_masg_tax_ref_num := nvl(g_masg_tax_ref_num,
2374: substr(hr_api.g_varchar2,1,10)); -- 4011263: substr to 10 chars
2375: -- set up the statutory start and end year
2376: OPEN csr_parameter_info(p_payroll_action_id);
2377: FETCH csr_parameter_info INTO g_start_year,
2378: g_end_year,

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

3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,
3285: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3286: FROM pay_assignment_actions act

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

3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,
3285: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3286: FROM pay_assignment_actions act
3287: WHERE act.assignment_action_id = p_asgactid;
3288: --
3289: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS

Line 4036: g_masg_person_id := hr_api.g_number;

4032: END archive_ni_value;
4033: --
4034: PROCEDURE empty_masg_cache IS
4035: BEGIN
4036: g_masg_person_id := hr_api.g_number;
4037: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
4038: g_masg_active_start := hr_api.g_sot;
4039: g_masg_active_end := hr_api.g_eot;
4040: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263

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

4033: --
4034: PROCEDURE empty_masg_cache IS
4035: BEGIN
4036: g_masg_person_id := hr_api.g_number;
4037: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
4038: g_masg_active_start := hr_api.g_sot;
4039: g_masg_active_end := hr_api.g_eot;
4040: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
4041: g_max_gross_pay := NULL;

Line 4038: g_masg_active_start := hr_api.g_sot;

4034: PROCEDURE empty_masg_cache IS
4035: BEGIN
4036: g_masg_person_id := hr_api.g_number;
4037: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
4038: g_masg_active_start := hr_api.g_sot;
4039: g_masg_active_end := hr_api.g_eot;
4040: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
4041: g_max_gross_pay := NULL;
4042: g_primary_action := NULL;

Line 4039: g_masg_active_end := hr_api.g_eot;

4035: BEGIN
4036: g_masg_person_id := hr_api.g_number;
4037: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
4038: g_masg_active_start := hr_api.g_sot;
4039: g_masg_active_end := hr_api.g_eot;
4040: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
4041: g_max_gross_pay := NULL;
4042: g_primary_action := NULL;
4043: g_min_assignment_id := NULL;

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

4036: g_masg_person_id := hr_api.g_number;
4037: g_masg_period_of_service_id := hr_api.g_number; -- Bug 3784871
4038: g_masg_active_start := hr_api.g_sot;
4039: g_masg_active_end := hr_api.g_eot;
4040: g_masg_tax_ref_num := substr(hr_api.g_varchar2,1,10); -- 4011263
4041: g_max_gross_pay := NULL;
4042: g_primary_action := NULL;
4043: g_min_assignment_id := NULL;
4044: g_ni_balance_totals := g_empty_ni_balance_totals;