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 dependencies on PAY_GB_FPS_NI_AND_OTHERS

Line 6068: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');

6064: FETCH csr_parameter_info INTO g_pre_pact_id,l_first_fps_ind,l_tax_ref,l_first_fps_date;
6065: CLOSE csr_parameter_info;
6066: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
6067: hr_utility.trace('l_tax_ref: '||l_tax_ref);
6068: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');
6069: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');
6070:
6071: /*Below code generates the HASH CODE for All Prepayments ran within 30 days.
6072: This will avoid generating duplicate records when it is called from Archive Code*/

Line 6069: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');

6065: CLOSE csr_parameter_info;
6066: hr_utility.trace('g_pre_pact_id: '||g_pre_pact_id);
6067: hr_utility.trace('l_tax_ref: '||l_tax_ref);
6068: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');
6069: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');
6070:
6071: /*Below code generates the HASH CODE for All Prepayments ran within 30 days.
6072: This will avoid generating duplicate records when it is called from Archive Code*/
6073:

Line 6078: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);

6074: OPEN csr_other_prepay_pactid(l_tax_ref);
6075: LOOP
6076: FETCH csr_other_prepay_pactid INTO l_other_prepay_pactid;
6077: EXIT WHEN csr_other_prepay_pactid%notfound;
6078: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6079: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_other_prepay_pactid, 'FPS');
6080: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6081: END LOOP;
6082: CLOSE csr_other_prepay_pactid;

Line 6079: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_other_prepay_pactid, 'FPS');

6075: LOOP
6076: FETCH csr_other_prepay_pactid INTO l_other_prepay_pactid;
6077: EXIT WHEN csr_other_prepay_pactid%notfound;
6078: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6079: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_other_prepay_pactid, 'FPS');
6080: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6081: END LOOP;
6082: CLOSE csr_other_prepay_pactid;
6083:

Line 6080: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);

6076: FETCH csr_other_prepay_pactid INTO l_other_prepay_pactid;
6077: EXIT WHEN csr_other_prepay_pactid%notfound;
6078: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6079: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_other_prepay_pactid, 'FPS');
6080: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for: '||l_other_prepay_pactid);
6081: END LOOP;
6082: CLOSE csr_other_prepay_pactid;
6083:
6084: OPEN csr_get_payroll_id(g_pre_pact_id);

Line 7542: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');

7538: raise_application_error(-20001,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7539: end if;
7540:
7541: /*
7542: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');
7543: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');
7544: */
7545:
7546: OPEN csr_ni_details;

Line 7543: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');

7539: end if;
7540:
7541: /*
7542: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS: ');
7543: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(g_pre_pact_id, 'FPS');
7544: */
7545:
7546: OPEN csr_ni_details;
7547: FETCH csr_ni_details INTO g_ni_pt_eid, g_ni_pt_ivid;

Line 9475: pay_gb_fps_ni_and_others.get_ni_bal_paye_aggr_for_asg(l_asg_f_id,

9471: hr_utility.trace(l_asg_f_id||' FIRST FPS ASG Inside NI calculation.');
9472:
9473: IF l_per_paye_agg_flag1 = 'Y' THEN
9474: hr_utility.set_location('Calling get_ni_bal_paye_aggr_for_asg',30);
9475: pay_gb_fps_ni_and_others.get_ni_bal_paye_aggr_for_asg(l_asg_f_id,
9476: l_last_asg_action_id,
9477: p_ni_a_balance,
9478: p_ni_b_balance,
9479: p_ni_c_balance,

Line 9498: pay_gb_fps_ni_and_others.get_ni_balances_for_asg(l_last_asg_action_id,

9494:
9495: if l_ni_rpt_asg_id <> l_asg_f_id then
9496: -- Non RTI reporting assignment
9497: hr_utility.set_location('Calling get_ni_balances_for_asg for non Ni RTI reporting assignment',30);
9498: pay_gb_fps_ni_and_others.get_ni_balances_for_asg(l_last_asg_action_id,
9499: p_ni_a_balance,
9500: p_ni_b_balance,
9501: p_ni_c_balance,
9502: p_ni_d_balance,

Line 9516: pay_gb_fps_ni_and_others.get_ni_only_bal_rti_rpt(l_last_asg_action_id,

9512: fetch csr_get_max_asg_actid_person INTO l_last_asg_action_id,l_last_effective_date;
9513: close csr_get_max_asg_actid_person;
9514:
9515: -- Fetching Person Level YTDs
9516: pay_gb_fps_ni_and_others.get_ni_only_bal_rti_rpt(l_last_asg_action_id,
9517: p_ni_a_balance,
9518: p_ni_b_balance,
9519: p_ni_c_balance,
9520: p_ni_d_balance,

Line 9530: pay_gb_fps_ni_and_others.get_ni_balances_for_asg(l_last_asg_action_id,

9526:
9527: ELSE
9528: -- Non Aggregation
9529: hr_utility.set_location('Calling get_ni_balances_for_asg',30);
9530: pay_gb_fps_ni_and_others.get_ni_balances_for_asg(l_last_asg_action_id,
9531: p_ni_a_balance,
9532: p_ni_b_balance,
9533: p_ni_c_balance,
9534: p_ni_d_balance,

Line 9825: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);

9821: CLOSE csr_bacs_payment_exists;
9822:
9823: begin
9824: if (l_bacs_payment_exists = 'Y') then
9825: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);
9826: else
9827: l_hash_code := null;
9828: end if;
9829: exception

Line 9886: pay_gb_fps_ni_and_others.get_ni_balances_for_asg(l_last_asg_action_id,

9882: l_last_effective_date;
9883: EXIT
9884: WHEN csr_all_payroll_actions%NOTFOUND;
9885:
9886: pay_gb_fps_ni_and_others.get_ni_balances_for_asg(l_last_asg_action_id,
9887: p_ni_a_balance,
9888: p_ni_b_balance,
9889: p_ni_c_balance,
9890: p_ni_d_balance,

Line 10489: Below we are calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for any other prepayment.

10485: hr_utility.trace('Fetching HASH Code Inside if');
10486: l_hash_code := NULL;
10487:
10488: /*
10489: Below we are calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS for any other prepayment.
10490: This may be needed incase if the Prepayment is run prior to 30 days from sysdate.
10491: All Prepayments ran within 30 days are already processed in Range_Cursor to generate the HASH CODE.
10492: */
10493:

Line 10496: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');

10492: */
10493:
10494: BEGIN
10495: IF (l_bacs_payment_exists = 'Y') THEN
10496: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10497: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
10498: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10499: --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);
10500: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);

Line 10497: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');

10493:
10494: BEGIN
10495: IF (l_bacs_payment_exists = 'Y') THEN
10496: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10497: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
10498: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10499: --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);
10500: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
10501: ELSE

Line 10498: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');

10494: BEGIN
10495: IF (l_bacs_payment_exists = 'Y') THEN
10496: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10497: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
10498: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10499: --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);
10500: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
10501: ELSE
10502: l_hash_code := NULL;

Line 10499: --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);

10495: IF (l_bacs_payment_exists = 'Y') THEN
10496: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10497: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
10498: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10499: --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);
10500: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
10501: ELSE
10502: l_hash_code := NULL;
10503: END IF;

Line 10500: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);

10496: hr_utility.trace('Before calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10497: l_dummy := PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS(l_cur_prepay_payroll_action_id, 'FPS');
10498: hr_utility.trace('After calling PAY_GB_FPS_NI_AND_OTHERS.FPS_BACS_PREPROCESS from Archive');
10499: --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);
10500: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (l_cur_prepay_payroll_action_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
10501: ELSE
10502: l_hash_code := NULL;
10503: END IF;
10504: EXCEPTION

Line 10631: pay_gb_fps_ni_and_others.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,

10627: end if;
10628: end if;
10629: l_ni_emp_run := 0;
10630: -- for ni balances
10631: pay_gb_fps_ni_and_others.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,
10632: l_cur_asg_action_id,
10633: p_ni_a_balance,
10634: p_ni_b_balance,
10635: p_ni_c_balance,

Line 10899: --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);

10895: hr_utility.trace('Fetching HASH Code Inside else');
10896: l_hash_code := NULL;
10897: BEGIN
10898: IF (l_bacs_payment_exists = 'Y') THEN
10899: --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);
10900: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (g_pre_pact_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
10901: ELSE
10902: l_hash_code := NULL;
10903: END IF;

Line 10900: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (g_pre_pact_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);

10896: l_hash_code := NULL;
10897: BEGIN
10898: IF (l_bacs_payment_exists = 'Y') THEN
10899: --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);
10900: l_hash_code := pay_gb_fps_ni_and_others.fetch_hash_fps_per (g_pre_pact_id, l_person_id,l_large_bacs_payment,l_bacs_large_asg_id);
10901: ELSE
10902: l_hash_code := NULL;
10903: END IF;
10904: EXCEPTION

Line 11045: pay_gb_fps_ni_and_others.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,

11041: end if;
11042: end if;
11043: l_ni_emp_run := 0;
11044: -- for ni balances
11045: pay_gb_fps_ni_and_others.get_ni_bal_paye_aggr_for_asg(l_cur_asg_id,
11046: l_cur_asg_action_id,
11047: p_ni_a_balance,
11048: p_ni_b_balance,
11049: p_ni_c_balance,

Line 11534: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);

11530: CLOSE csr_bacs_payment_exists;
11531:
11532: begin
11533: if (l_bacs_payment_exists = 'Y') then
11534: l_hash_code := PAY_GB_FPS_NI_AND_OTHERS.fetch_HASH_FPS_ASG(g_pre_pact_id, l_asg_id, l_large_bacs_payment);
11535: else
11536: l_hash_code := null;
11537: end if;
11538: exception

Line 11596: pay_gb_fps_ni_and_others.get_ni_only_agg_bal_for_asg(l_last_asg_action_id,

11592: EXIT
11593: WHEN csr_all_payroll_actions%NOTFOUND;
11594:
11595:
11596: pay_gb_fps_ni_and_others.get_ni_only_agg_bal_for_asg(l_last_asg_action_id,
11597: p_ni_a_balance,
11598: p_ni_b_balance,
11599: p_ni_c_balance,
11600: p_ni_d_balance,

Line 11842: pay_gb_fps_ni_and_others.get_ni_only_bal_rti_rpt(l_max_prepay_act_id,

11838: open csr_aggr_max_act_id(l_person_id,g_pre_pact_id,l_last_effective_date);
11839: fetch csr_aggr_max_act_id into l_count_asg,l_max_prepay_act_id;
11840: close csr_aggr_max_act_id;
11841:
11842: pay_gb_fps_ni_and_others.get_ni_only_bal_rti_rpt(l_max_prepay_act_id,
11843: p_per_ni_a_balance,
11844: p_per_ni_b_balance,
11845: p_per_ni_c_balance,
11846: p_per_ni_d_balance,

Line 11853: pay_gb_fps_ni_and_others.get_ni_only_agg_bal_sum_asg(l_asg_act_rec.asg_act_id,

11849: p_per_ni_l_balance);
11850: -----
11851: /*FOR l_asg_act_rec in csr_asg_in_prepay(l_person_id)
11852: loop
11853: pay_gb_fps_ni_and_others.get_ni_only_agg_bal_sum_asg(l_asg_act_rec.asg_act_id,
11854: p_per_ni_a_balance,
11855: p_per_ni_b_balance,
11856: p_per_ni_c_balance,
11857: p_per_ni_d_balance,

Line 12963: PAY_GB_FPS_NI_AND_OTHERS.restored(pactid);

12959: write_body('W',pactid,l_is_etext_report);
12960: write_footer;
12961: --Footer Validations
12962: if l_flag = 'Y' then
12963: PAY_GB_FPS_NI_AND_OTHERS.restored(pactid);
12964: raise l_exp;
12965: end if;
12966:
12967: if l_parameter_info_rec.version = 'Pre October' then