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_RTI_FPS_ARCHIVE dependencies on PAY_GB_FPS_NI_AND_OTHERS_13

Line 6708: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');

6704: CLOSE csr_parameter_info;
6705: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
6706: hr_utility.trace('l_tax_ref: '||l_tax_ref);
6707: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');
6708: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');
6709:
6710: /*Below code generates the HASH CODE for All Prepayments ran within 30 days.
6711: This will avoid generating duplicate records when it is called from Archive Code*/
6712:

Line 6718: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(l_other_prepay_pactid, 'FPS');

6714: LOOP
6715: FETCH csr_other_prepay_pactid INTO l_other_prepay_pactid;
6716: EXIT WHEN csr_other_prepay_pactid%notfound;
6717: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6718: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(l_other_prepay_pactid, 'FPS');
6719: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6720: END LOOP;
6721: CLOSE csr_other_prepay_pactid;
6722:

Line 10130: pay_gb_fps_ni_and_others_13.get_ni_bal_paye_aggr_for_asg(l_asg_f_id,

10126: hr_utility.trace(l_asg_f_id||' FIRST FPS ASG Inside NI calculation.');
10127:
10128: IF l_per_paye_agg_flag1 = 'Y' THEN
10129: hr_utility.set_location('Calling get_ni_bal_paye_aggr_for_asg',30);
10130: pay_gb_fps_ni_and_others_13.get_ni_bal_paye_aggr_for_asg(l_asg_f_id,
10131: l_last_asg_action_id,
10132: p_ni_a_balance,
10133: p_ni_b_balance,
10134: p_ni_c_balance,

Line 10153: pay_gb_fps_ni_and_others_13.get_ni_balances_for_asg(l_last_asg_action_id,

10149:
10150: if l_ni_rpt_asg_id <> l_asg_f_id then
10151: -- Non RTI reporting assignment
10152: hr_utility.set_location('Calling get_ni_balances_for_asg for non Ni RTI reporting assignment',30);
10153: pay_gb_fps_ni_and_others_13.get_ni_balances_for_asg(l_last_asg_action_id,
10154: p_ni_a_balance,
10155: p_ni_b_balance,
10156: p_ni_c_balance,
10157: p_ni_d_balance,

Line 10171: pay_gb_fps_ni_and_others_13.get_ni_only_bal_rti_rpt(l_last_asg_action_id,

10167: fetch csr_get_max_asg_actid_person INTO l_last_asg_action_id,l_last_effective_date;
10168: close csr_get_max_asg_actid_person;
10169:
10170: -- Fetching Person Level YTDs
10171: pay_gb_fps_ni_and_others_13.get_ni_only_bal_rti_rpt(l_last_asg_action_id,
10172: p_ni_a_balance,
10173: p_ni_b_balance,
10174: p_ni_c_balance,
10175: p_ni_d_balance,

Line 10185: pay_gb_fps_ni_and_others_13.get_ni_balances_for_asg(l_last_asg_action_id,

10181:
10182: ELSE
10183: -- Non Aggregation
10184: hr_utility.set_location('Calling get_ni_balances_for_asg',30);
10185: pay_gb_fps_ni_and_others_13.get_ni_balances_for_asg(l_last_asg_action_id,
10186: p_ni_a_balance,
10187: p_ni_b_balance,
10188: p_ni_c_balance,
10189: p_ni_d_balance,

Line 10487: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS_13.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);

10483: CLOSE csr_bacs_payment_exists;
10484:
10485: begin
10486: if (l_bacs_payment_exists = 'Y') then
10487: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS_13.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);
10488: else
10489: l_hash_code := null;
10490: end if;
10491: exception

Line 10556: pay_gb_fps_ni_and_others_13.get_ni_balances_for_asg(l_last_asg_action_id,

10552: l_last_effective_date;
10553: EXIT
10554: WHEN csr_all_payroll_actions%NOTFOUND;
10555:
10556: pay_gb_fps_ni_and_others_13.get_ni_balances_for_asg(l_last_asg_action_id,
10557: p_ni_a_balance,
10558: p_ni_b_balance,
10559: p_ni_c_balance,
10560: p_ni_d_balance,

Line 11174: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');

11170:
11171: BEGIN
11172: IF (l_bacs_payment_exists = 'Y') THEN
11173: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
11174: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
11175: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
11176: --l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_asg (l_cur_prepay_payroll_action_id, l_cur_asg_id, l_large_bacs_payment);
11177: l_hash_code := pay_gb_fps_ni_and_others_13.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
11178: ELSE

Line 11177: l_hash_code := pay_gb_fps_ni_and_others_13.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);

11173: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
11174: l_dummy := PAY_GB_FPS_NI_AND_OTHERS_13.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
11175: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
11176: --l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_asg (l_cur_prepay_payroll_action_id, l_cur_asg_id, l_large_bacs_payment);
11177: l_hash_code := pay_gb_fps_ni_and_others_13.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
11178: ELSE
11179: l_hash_code := NULL;
11180: END IF;
11181: EXCEPTION

Line 11322: pay_gb_fps_ni_and_others_13.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,

11318: end if;
11319: end if;
11320: l_ni_emp_run := 0;
11321: -- for ni balances
11322: pay_gb_fps_ni_and_others_13.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,
11323: l_cur_asg_action_id,
11324: p_ni_a_balance,
11325: p_ni_b_balance,
11326: p_ni_c_balance,

Line 11600: l_hash_code := pay_gb_fps_ni_and_others_13.fetch_hash_fps_per (g_pre_pact_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);

11596: l_hash_code := NULL;
11597: BEGIN
11598: IF (l_bacs_payment_exists = 'Y') THEN
11599: --l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_asg (g_pre_pact_id, l_cur_asg_id, l_large_bacs_payment);
11600: l_hash_code := pay_gb_fps_ni_and_others_13.fetch_hash_fps_per (g_pre_pact_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
11601: ELSE
11602: l_hash_code := NULL;
11603: END IF;
11604: EXCEPTION

Line 11752: pay_gb_fps_ni_and_others_13.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,

11748: end if;
11749: end if;
11750: l_ni_emp_run := 0;
11751: -- for ni balances
11752: pay_gb_fps_ni_and_others_13.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,
11753: l_cur_asg_action_id,
11754: p_ni_a_balance,
11755: p_ni_b_balance,
11756: p_ni_c_balance,

Line 12250: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS_13.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);

12246: CLOSE csr_bacs_payment_exists;
12247:
12248: begin
12249: if (l_bacs_payment_exists = 'Y') then
12250: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS_13.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);
12251: else
12252: l_hash_code := null;
12253: end if;
12254: exception

Line 12318: pay_gb_fps_ni_and_others_13.get_ni_only_agg_bal_for_asg(l_last_asg_action_id,

12314: EXIT
12315: WHEN csr_all_payroll_actions%NOTFOUND;
12316:
12317:
12318: pay_gb_fps_ni_and_others_13.get_ni_only_agg_bal_for_asg(l_last_asg_action_id,
12319: p_ni_a_balance,
12320: p_ni_b_balance,
12321: p_ni_c_balance,
12322: p_ni_d_balance,

Line 12572: pay_gb_fps_ni_and_others_13.get_ni_only_bal_rti_rpt(l_max_prepay_act_id,

12568: open csr_aggr_max_act_id(l_person_id,g_pre_pact_id,l_last_effective_date);
12569: fetch csr_aggr_max_act_id into l_count_asg,l_max_prepay_act_id;
12570: close csr_aggr_max_act_id;
12571:
12572: pay_gb_fps_ni_and_others_13.get_ni_only_bal_rti_rpt(l_max_prepay_act_id,
12573: p_per_ni_a_balance,
12574: p_per_ni_b_balance,
12575: p_per_ni_c_balance,
12576: p_per_ni_d_balance,

Line 13725: PAY_GB_FPS_NI_AND_OTHERS_13.restored(pactid);

13721: write_body('W',pactid,l_is_etext_report);
13722: write_footer;
13723: --Footer Validations
13724: if l_flag = 'Y' then
13725: PAY_GB_FPS_NI_AND_OTHERS_13.restored(pactid);
13726: raise l_exp;
13727: end if;
13728:
13729: if l_parameter_info_rec.version = 'Pre October' then