1 PACKAGE PAY_GB_EPS_13 AUTHID CURRENT_USER as
2 /* $Header: pygbeps13.pkh 120.1.12020000.1 2013/03/09 07:00:08 ssanjays noship $ */
3 /*===========================================================================+
4 | Copyright (c) 1993 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================
8 Name:
9 PAY_GB_EPS_13
10 Purpose:
11 It fetches the live data and generates RTI EPS Records.
12 This is a UK Specific payroll package.
13
14 History:
15 12-Dec-2012 sampmand 120.1 15890006 Created.
16
17 =============================================================================*/
18 --
19 --
20
21 PROCEDURE insert_eps_record
22 (
23 p_effective_date IN DATE,
24 p_emp_paye_reference IN VARCHAR2,
25 p_account_office_number IN VARCHAR2,
26 p_business_group_id IN NUMBER,
27 p_employer_name IN VARCHAR2,
28 p_econ_number IN VARCHAR2,
29 p_related_tax_year IN VARCHAR2,
30 p_final_submission_ceased IN VARCHAR2,
31 p_final_submission_year IN VARCHAR2,
32 p_smp_sap_spp_recovery IN NUMBER,
33 p_ssp_recovery IN NUMBER,
34 p_nic_recovery IN NUMBER,
35 p_service_company IN VARCHAR2,
36 p_smp_amt_recovered_calc IN NUMBER,
37 p_sap_amt_recovered_calc IN NUMBER,
38 p_ospp_amt_recovered_calc IN NUMBER,
39 p_aspp_amt_recovered_calc IN NUMBER,
40 p_ssp_amt_recovered_calc IN NUMBER,
41 p_nic_comp_smp_calc IN NUMBER,
42 p_nic_comp_sap_calc IN NUMBER,
43 p_nic_comp_ospp_calc IN NUMBER,
44 p_nic_comp_aspp_calc IN NUMBER,
45 p_nic_comp_ssp_calc IN NUMBER,
46 p_status IN VARCHAR2,
47 p_user_id IN NUMBER,
48 p_approver_id IN NUMBER,
49 p_request_id IN NUMBER,
50 p_program_application_id IN NUMBER,
51 p_program_id IN NUMBER,
52 p_update_date IN DATE
53 );
54
55 PROCEDURE delete_eps_record
56 ( p_effective_date IN VARCHAR2,
57 p_emp_paye_reference IN VARCHAR2,
58 p_business_group_id IN VARCHAR2,
59 p_return_status OUT NOCOPY VARCHAR2
60 );
61
62 PROCEDURE update_status_eps_record
63 ( p_effective_date IN VARCHAR2,
64 p_emp_paye_reference IN VARCHAR2,
65 p_business_group_id IN VARCHAR2,
66 p_status IN VARCHAR2,
67 p_object_version_number IN NUMBER,
68 p_workflow IN VARCHAR2,
69 p_return_status OUT NOCOPY VARCHAR2
70 );
71
72 PROCEDURE update_eps_record
73 (
74 p_effective_date IN VARCHAR2,
75 p_emp_paye_reference IN VARCHAR2,
76 p_tax_free_pymt IN VARCHAR2,
77 p_emp_third_party IN VARCHAR2,
78 p_exp_ben_othrs IN VARCHAR2,
79 p_p11d_due IN VARCHAR2,
80 p_emp_outside_uk IN VARCHAR2,
81 p_payment_due IN VARCHAR2,
82 p_final_submission_ceased IN VARCHAR2,
83 p_final_submission_year IN VARCHAR2,
84 p_service_company IN VARCHAR2,
85 p_smp_amt_recovered_calc IN NUMBER,
86 p_sap_amt_recovered_calc IN NUMBER,
87 p_ospp_amt_recovered_calc IN NUMBER,
88 p_aspp_amt_recovered_calc IN NUMBER,
89 p_ssp_amt_recovered_calc IN NUMBER,
90 p_nic_comp_smp_calc IN NUMBER,
91 p_nic_comp_sap_calc IN NUMBER,
92 p_nic_comp_ospp_calc IN NUMBER,
93 p_nic_comp_aspp_calc IN NUMBER,
94 p_nic_comp_ssp_calc IN NUMBER,
95 p_cis_deductions_suff IN NUMBER,
96 p_nic_holiday_val IN NUMBER,
97 p_adv_from_hmrc IN NUMBER,
98 p_status IN VARCHAR2,
99 p_approver_id IN NUMBER,
100 p_object_version_number IN NUMBER,
101 p_business_group_id IN VARCHAR2,
102 p_no_payment_date_from IN VARCHAR2,
103 p_no_payment_date_to IN VARCHAR2,
104 p_period_of_inactivity_from IN VARCHAR2,
105 p_period_of_inactivity_to IN VARCHAR2,
106 p_date_scheme_ceased IN VARCHAR2,
107 p_return_status OUT NOCOPY VARCHAR2
108 );
109
110 PROCEDURE set_wf_approver_role
111 (
112 itemtype IN VARCHAR2
113 ,itemkey IN VARCHAR2
114 ,actid IN NUMBER
115 ,funcmode IN VARCHAR2
116 ,RESULT IN OUT NOCOPY VARCHAR2
117 );
118
119 PROCEDURE start_eps_wf(eps_id IN VARCHAR2,status IN VARCHAR2,email_address IN VARCHAR2,user_name IN VARCHAR2);
120
121 procedure submit_eps
122 (
123 errbuf OUT NOCOPY VARCHAR2,
124 retcode OUT NOCOPY NUMBER,
125 p_emp_paye_reference in varchar2,
126 p_effective_date in varchar2,
127 p_test_submission in varchar2,
128 p_business_group_id in varchar2
129 );
130
131 procedure rollback_eps
132 (
133 errbuf OUT NOCOPY VARCHAR2,
134 retcode OUT NOCOPY NUMBER,
135 p_emp_paye_reference in varchar2,
136 p_effective_date in varchar2,
137 p_business_group_id in varchar2
138 );
139
140 function validate_payments(p_emp_paye_reference varchar2,p_effective_date varchar2,p_business_group_id varchar2) return number;
141
142 function validate(emp_paye_reference varchar2,acc_off_no varchar2,employer_name varchar2,econ varchar2,tax_year varchar2,
143 final_submission_ceased varchar2 default null,final_submission_year varchar2 default null) return number;
144
145 function validate_input(p_input_value varchar2,
146 p_validate_mode varchar2)
147 return number;
148
149 function econ_validate(econ varchar2)
150 return number;
151
152 PROCEDURE profile_option_value
153 (
154 p_return_status OUT NOCOPY VARCHAR2
155 );
156
157 PROCEDURE check_sequence
158 ( p_effective_date IN VARCHAR2,
159 p_emp_paye_reference IN VARCHAR2,
160 p_business_group_id IN VARCHAR2,
161 p_return_status OUT NOCOPY VARCHAR2
162 );
163
164 function tax_year return number;
165
166 END PAY_GB_EPS_13;