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

Line 1: PACKAGE body PAY_GB_FPS_NI_AND_OTHERS AS

1: PACKAGE body PAY_GB_FPS_NI_AND_OTHERS AS
2: /* $Header: pygbrtifpsni.pkb 120.1.12020000.30 2013/03/29 13:40:19 ssarap noship $ */
3: /*===========================================================================+
4: | Copyright (c) 2012 Oracle Corporation |
5: | Redwood Shores, California, USA |

Line 9: PAY_GB_FPS_NI_AND_OTHERS

5: | Redwood Shores, California, USA |
6: | All rights reserved. |
7: +============================================================================
8: Name:
9: PAY_GB_FPS_NI_AND_OTHERS
10: Purpose:
11: It fetches the live data and for NI Balances for FPS RTI Processes.
12: This is a UK Specific payroll package.
13: History:

Line 1079: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_balances_for_asg.');

1075: and paa.payroll_action_id = ppa.payroll_action_id
1076: and ACTION_TYPE in ('V');
1077:
1078: BEGIN
1079: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_balances_for_asg.');
1080: load_defined_balances_aggr();
1081: -- fetch NI x Total/Able balances for checking whether this assignment
1082: -- reported in the P35 report or not. -- Bug 6271548
1083: hr_utility.trace('fetching NI x Total/Able balances');

Line 1403: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_bal_rti_rpt.');

1399: and paa.payroll_action_id = ppa.payroll_action_id
1400: and ACTION_TYPE in ('V');
1401:
1402: BEGIN
1403: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_bal_rti_rpt.');
1404: load_defined_balances_aggr();
1405: -- fetch NI x Total/Able balances for checking whether this assignment
1406: -- reported in the P35 report or not. -- Bug 6271548
1407: hr_utility.trace('fetching NI x Total/Able balances');

Line 1737: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_balances_for_asg.');

1733: and ACTION_TYPE in ('V');
1734:
1735:
1736: BEGIN
1737: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_balances_for_asg.');
1738: load_defined_balances();
1739: -- fetch NI x Total/Able balances for checking whether this assignment
1740: -- reported in the P35 report or not. -- Bug 6271548
1741: hr_utility.trace('fetching NI x Total/Able balances');

Line 2394: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_for_asg.');

2390: and paa.payroll_action_id = ppa.payroll_action_id
2391: and ACTION_TYPE in ('V');
2392:
2393: BEGIN
2394: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_for_asg.');
2395: load_defined_balances();
2396: -- fetch NI x Total/Able balances for checking whether this assignment
2397: -- reported in the P35 report or not. -- Bug 6271548
2398: hr_utility.trace('fetching NI x Total/Able balances');

Line 2665: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_sum_asg.');

2661: IS
2662: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2663: FROM dual;
2664: BEGIN
2665: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_sum_asg.');
2666: load_defined_balances();
2667: -- fetch NI x Total/Able balances for checking whether this assignment
2668: -- reported in the P35 report or not. -- Bug 6271548
2669: hr_utility.trace('fetching NI x Total/Able balances');

Line 2816: hr_utility.trace('Leaving PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_sum_asg.');

2812: --p_ni_l_balance.act_info10 := 100 * hr_dirbal.get_balance(l_asg_action_id, g_nil_e_ptd_id);
2813: l_count_values := l_count_values +1;
2814: END IF;
2815: hr_utility.trace('Number of categories: ' || l_count_values);
2816: hr_utility.trace('Leaving PAY_GB_FPS_NI_AND_OTHERS.get_ni_only_agg_bal_sum_asg.');
2817: END get_ni_only_agg_bal_sum_asg;
2818: -- end aggregated assignments
2819: FUNCTION Bacs_random_digit
2820: RETURN VARCHAR2

Line 3366: PAY_GB_FPS_NI_AND_OTHERS.FPS_HASH(bacs.RandomStr,bacs.Org_sort_code, bacs.Receipient_sort_code,bacs.Amount) Hash,

3362: bacs.Org_sort_code,
3363: bacs.Receipient_sort_code,
3364: bacs.Amount,
3365: bacs.RandomStr,
3366: PAY_GB_FPS_NI_AND_OTHERS.FPS_HASH(bacs.RandomStr,bacs.Org_sort_code, bacs.Receipient_sort_code,bacs.Amount) Hash,
3367: SYSDATE,
3368: P_PROGRAM
3369: FROM
3370: (SELECT lpad(Orgkey.segment3,6,'0') Org_sort_code,

Line 3379: PAY_GB_FPS_NI_AND_OTHERS.BACS_RANDOM_DIGIT RandomStr

3375: PAA.ASSIGNMENT_ID,
3376: lpad(ppp.value*100,11,'0') Amount,
3377: PAPF.PER_information10 Aggregation,
3378: DECODE(PAPF.PER_information10,'Y',RANK() OVER (PARTITION BY PAA.PAYROLL_ACTION_ID,PAPF.PERSON_ID order by ppp.value DESC),RANK() OVER (PARTITION BY PAA.PAYROLL_ACTION_ID,PAA.ASSIGNMENT_ID order by ppp.value DESC)) highest,
3379: PAY_GB_FPS_NI_AND_OTHERS.BACS_RANDOM_DIGIT RandomStr
3380: FROM pay_pre_payments ppp,
3381: pay_payment_types ppt,
3382: pay_org_payment_methods_f popf,
3383: pay_personal_payment_methods_f pppf,

Line 3611: END PAY_GB_FPS_NI_AND_OTHERS;

3607: argument8 => 'PAYROLL_ACTION_ID='||p_actid, argument9 => NULL);
3608: hr_utility.set_location('Leaving: '||l_proc,999);
3609: END fps_rollback;
3610: --FPS RollBack End
3611: END PAY_GB_FPS_NI_AND_OTHERS;