1 PACKAGE PAY_GB_FPS_NI_AND_OTHERS AUTHID CURRENT_USER AS
2 /* $Header: pygbrtifpsni.pkh 120.1.12020000.7 2013/03/29 13:43:09 ssarap noship $ */
3 /*===========================================================================+
4 | Copyright (c) 2012 Oracle Corporation |
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:
14 04-May-2012 ssarap 115.0 13076448 Created.
15 04-Jun-2012 krredy 115.1 13076448 Modified fetch_HASH_FPS_ASG declaration for BACS changes.
16 01-Aug-2012 ssarap 115.1 Added functions for FPS Aggregated cases.
17 02-Aug-2012 rajganga 115.2 Removed check file equivalence.
18 31-Oct-2012 krreddy 115.3 14827248 Fixed PAYE Aggregation issues on NI Records.
19 2-Nov -2012 ssarap 115.3 14827248 Added new procedure for NI Only aggregation.
20 5-Nov -2012 ssarap 115.4 14827248 Added new procedure for NI Only aggregation.
21 22-Nov-2012 rajganga 115.5 14827248 Added out parameter to fetch_HASH_FPS_PER.
22 29-Mar-2013 ssarap 115.6 16555308 Added the assignment id OUT
23 param to fetch_HASH_FPS_PER.
24 =============================================================================*/
25 --
26 --
27
28 PROCEDURE get_ni_balances_for_asg(
29 l_last_asg_action_id IN NUMBER,
30 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
31 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
32 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
33 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
34 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
35 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
36 P_NI_L_BALANCE IN OUT NOCOPY PAY_GB_RTI_FPS.ACT_INFO_REC );
37
38 PROCEDURE get_ni_bal_paye_aggr_for_asg(
39 p_asg_id IN NUMBER,
40 l_last_asg_action_id IN NUMBER,
41 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
42 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
43 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
44 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
45 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
46 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
47 P_NI_L_BALANCE IN OUT NOCOPY PAY_GB_RTI_FPS.ACT_INFO_REC );
48
49 PROCEDURE get_ni_only_agg_bal_for_asg(
50 l_last_asg_action_id IN NUMBER,
51 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
52 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
53 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
54 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
55 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
56 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
57 P_NI_L_BALANCE IN OUT NOCOPY PAY_GB_RTI_FPS.ACT_INFO_REC );
58
59 PROCEDURE get_ni_only_agg_bal_sum_asg(
60 l_last_asg_action_id IN NUMBER,
61 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
62 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
63 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
64 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
65 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
66 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
67 P_NI_L_BALANCE IN OUT NOCOPY PAY_GB_RTI_FPS.ACT_INFO_REC );
68
69 PROCEDURE get_ni_only_bal_rti_rpt(
70 l_last_asg_action_id IN NUMBER,
71 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
72 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
73 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
74 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
75 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
76 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec,
77 p_ni_l_balance IN OUT nocopy pay_gb_rti_fps.act_info_rec );
78
79
80 FUNCTION FPS_BACS_SHA_256(
81 P_INPUT IN VARCHAR2)
82 RETURN VARCHAR2
83 AS
84 LANGUAGE JAVA NAME 'oracle.apps.pay.util.PayMessageStack.getFPSHashCode(java.lang.String) return java.lang.String';
85
86 FUNCTION BACS_RANDOM_DIGIT
87 RETURN VARCHAR2;
88
89 FUNCTION fetch_random_digit_bacs(
90 p_ORG_SORT_CODE IN VARCHAR2,
91 p_RECEIPIENT_SORT_CODE IN VARCHAR2,
92 p_amount IN VARCHAR2)
93 RETURN VARCHAR2;
94
95 FUNCTION fetch_HASH_FPS_ASG(
96 P_PAYROLL_ACTION_ID IN NUMBER,
97 P_ASSIGNMENT_ID IN NUMBER,
98 P_LARGE_BACS_AMT OUT NOCOPY NUMBER )
99 RETURN VARCHAR2;
100
101 FUNCTION fetch_HASH_FPS_PER(
102 P_PAYROLL_ACTION_ID IN NUMBER,
103 p_PERSON_ID IN NUMBER,
104 P_LARGE_BACS_AMT OUT NOCOPY NUMBER,
105 P_ASG_ID OUT NOCOPY NUMBER )
106 RETURN VARCHAR2;
107
108 FUNCTION FPS_hash(
109 p_random_string IN VARCHAR2,
110 p_originator_bank IN VARCHAR2,
111 p_recipient_bank IN VARCHAR2,
112 p_payment_amount IN VARCHAR2)
113 RETURN VARCHAR2;
114
115 FUNCTION FPS_BACS_PREPROCESS(
116 P_PAYROLL_ACTION_ID IN NUMBER,
117 P_PROGRAM IN VARCHAR2)
118 RETURN NUMBER;
119
120 PROCEDURE fps_rollback(errbuf out NOCOPY VARCHAR2,
121 retcode out NOCOPY NUMBER,
122 p_year in number,
123 p_actid in number);
124
125 PROCEDURE restored(p_pactid in number);
126 --
127 END PAY_GB_FPS_NI_AND_OTHERS;