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

Line 1: PACKAGE body PAY_GB_FPS_NI_AND_OTHERS_13 AS

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

Line 9: PAY_GB_FPS_NI_AND_OTHERS_13

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

Line 1043: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_balances_for_asg.');

1039: and paa.payroll_action_id = ppa.payroll_action_id
1040: and ACTION_TYPE in ('V');
1041:
1042: BEGIN
1043: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_balances_for_asg.');
1044: load_defined_balances_aggr();
1045: -- fetch NI x Total/Able balances for checking whether this assignment
1046: -- reported in the P35 report or not. -- Bug 6271548
1047: hr_utility.trace('fetching NI x Total/Able balances');

Line 1374: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_bal_rti_rpt.');

1370: and paa.payroll_action_id = ppa.payroll_action_id
1371: and ACTION_TYPE in ('V');
1372:
1373: BEGIN
1374: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_bal_rti_rpt.');
1375: load_defined_balances_aggr();
1376: -- fetch NI x Total/Able balances for checking whether this assignment
1377: -- reported in the P35 report or not. -- Bug 6271548
1378: hr_utility.trace('fetching NI x Total/Able balances');

Line 1712: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_balances_for_asg.');

1708: and paa.payroll_action_id = ppa.payroll_action_id
1709: and ACTION_TYPE in ('V');
1710:
1711: BEGIN
1712: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_balances_for_asg.');
1713: load_defined_balances();
1714: -- fetch NI x Total/Able balances for checking whether this assignment
1715: -- reported in the P35 report or not. -- Bug 6271548
1716: hr_utility.trace('fetching NI x Total/Able balances');

Line 2382: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_agg_bal_for_asg.');

2378: and paa.payroll_action_id = ppa.payroll_action_id
2379: and ACTION_TYPE in ('V');
2380:
2381: BEGIN
2382: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_agg_bal_for_asg.');
2383: load_defined_balances();
2384: -- fetch NI x Total/Able balances for checking whether this assignment
2385: -- reported in the P35 report or not. -- Bug 6271548
2386: hr_utility.trace('fetching NI x Total/Able balances');

Line 2660: hr_utility.trace('Entering PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_agg_bal_sum_asg.');

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

Line 2811: hr_utility.trace('Leaving PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_agg_bal_sum_asg.');

2807: --p_ni_l_balance.act_info10 := 100 * hr_dirbal.get_balance(l_asg_action_id, g_nil_e_ptd_id);
2808: l_count_values := l_count_values +1;
2809: END IF;
2810: hr_utility.trace('Number of categories: ' || l_count_values);
2811: hr_utility.trace('Leaving PAY_GB_FPS_NI_AND_OTHERS_13.get_ni_only_agg_bal_sum_asg.');
2812: END get_ni_only_agg_bal_sum_asg;
2813: -- end aggregated assignments
2814: FUNCTION Bacs_random_digit
2815: RETURN VARCHAR2

Line 3361: PAY_GB_FPS_NI_AND_OTHERS_13.FPS_HASH(bacs.RandomStr,bacs.Org_sort_code, bacs.Receipient_sort_code,bacs.Amount) Hash,

3357: bacs.Org_sort_code,
3358: bacs.Receipient_sort_code,
3359: bacs.Amount,
3360: bacs.RandomStr,
3361: PAY_GB_FPS_NI_AND_OTHERS_13.FPS_HASH(bacs.RandomStr,bacs.Org_sort_code, bacs.Receipient_sort_code,bacs.Amount) Hash,
3362: SYSDATE,
3363: P_PROGRAM
3364: FROM
3365: (SELECT lpad(Orgkey.segment3,6,'0') Org_sort_code,

Line 3374: PAY_GB_FPS_NI_AND_OTHERS_13.BACS_RANDOM_DIGIT RandomStr

3370: PAA.ASSIGNMENT_ID,
3371: lpad(ppp.value*100,11,'0') Amount,
3372: PAPF.PER_information10 Aggregation,
3373: 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,
3374: PAY_GB_FPS_NI_AND_OTHERS_13.BACS_RANDOM_DIGIT RandomStr
3375: FROM pay_pre_payments ppp,
3376: pay_payment_types ppt,
3377: pay_org_payment_methods_f popf,
3378: pay_personal_payment_methods_f pppf,

Line 3606: END PAY_GB_FPS_NI_AND_OTHERS_13;

3602: argument8 => 'PAYROLL_ACTION_ID='||p_actid, argument9 => NULL);
3603: hr_utility.set_location('Leaving: '||l_proc,999);
3604: END fps_rollback;
3605: --FPS RollBack End
3606: END PAY_GB_FPS_NI_AND_OTHERS_13;