1 PACKAGE PAY_GB_FPS_NI_AND_OTHERS_13 AUTHID CURRENT_USER AS
2 /* $Header: pygbrtifpsni13.pkh 120.0.12020000.2 2013/03/29 13:44:54 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 19-Dec-2012 rajganga 115.0 15890022 Created.
15 29-Mar-2013 ssarap 115.1 16555308 Added the assignment id OUT
16 param to fetch_HASH_FPS_PER.
17 =============================================================================*/
18 --
19 --
20
21 PROCEDURE get_ni_balances_for_asg(
22 l_last_asg_action_id IN NUMBER,
23 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
24 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
25 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
26 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
27 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
28 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
29 P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC );
30
31 PROCEDURE get_ni_bal_paye_aggr_for_asg(
32 p_asg_id IN NUMBER,
33 l_last_asg_action_id IN NUMBER,
34 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
35 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
36 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
37 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
38 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
39 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
40 P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC );
41
42 PROCEDURE get_ni_only_agg_bal_for_asg(
43 l_last_asg_action_id IN NUMBER,
44 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
45 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
46 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
47 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
48 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
49 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
50 P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC );
51
52 PROCEDURE get_ni_only_agg_bal_sum_asg(
53 l_last_asg_action_id IN NUMBER,
54 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
55 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
56 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
57 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
58 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
59 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
60 P_NI_L_BALANCE IN OUT NOCOPY pay_gb_rti_fps_archive.ACT_INFO_REC );
61
62 PROCEDURE get_ni_only_bal_rti_rpt(
63 l_last_asg_action_id IN NUMBER,
64 p_ni_a_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
65 p_ni_b_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
66 p_ni_c_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
67 p_ni_d_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
68 p_ni_e_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
69 p_ni_j_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec,
70 p_ni_l_balance IN OUT nocopy pay_gb_rti_fps_archive.act_info_rec );
71
72
73 FUNCTION FPS_BACS_SHA_256(
74 P_INPUT IN VARCHAR2)
75 RETURN VARCHAR2
76 AS
77 LANGUAGE JAVA NAME 'oracle.apps.pay.util.PayMessageStack.getFPSHashCode(java.lang.String) return java.lang.String';
78
79 FUNCTION BACS_RANDOM_DIGIT
80 RETURN VARCHAR2;
81
82 FUNCTION fetch_random_digit_bacs(
83 p_ORG_SORT_CODE IN VARCHAR2,
84 p_RECEIPIENT_SORT_CODE IN VARCHAR2,
85 p_amount IN VARCHAR2)
86 RETURN VARCHAR2;
87
88 FUNCTION fetch_HASH_FPS_ASG(
89 P_PAYROLL_ACTION_ID IN NUMBER,
90 P_ASSIGNMENT_ID IN NUMBER,
91 P_LARGE_BACS_AMT OUT NOCOPY NUMBER )
92 RETURN VARCHAR2;
93
94 FUNCTION fetch_HASH_FPS_PER(
95 P_PAYROLL_ACTION_ID IN NUMBER,
96 p_PERSON_ID IN NUMBER,
97 P_LARGE_BACS_AMT OUT NOCOPY NUMBER,
98 P_ASG_ID OUT NOCOPY NUMBER )
99 RETURN VARCHAR2;
100
101 FUNCTION FPS_hash(
102 p_random_string IN VARCHAR2,
103 p_originator_bank IN VARCHAR2,
104 p_recipient_bank IN VARCHAR2,
105 p_payment_amount IN VARCHAR2)
106 RETURN VARCHAR2;
107
108 FUNCTION FPS_BACS_PREPROCESS(
109 P_PAYROLL_ACTION_ID IN NUMBER,
110 P_PROGRAM IN VARCHAR2)
111 RETURN NUMBER;
112
113 PROCEDURE fps_rollback(errbuf out NOCOPY VARCHAR2,
114 retcode out NOCOPY NUMBER,
115 p_year in number,
116 p_actid in number);
117
118 PROCEDURE restored(p_pactid in number);
119 --
120 END PAY_GB_FPS_NI_AND_OTHERS_13;