[Home] [Help]
PACKAGE: APPS.PAY_GB_EPS
Source
1 PACKAGE PAY_GB_EPS AUTHID CURRENT_USER as
2 /* $Header: pygbeps.pkh 120.6.12020000.1 2013/02/14 06:49:44 rajganga noship $ */
3 /*===========================================================================+
4 | Copyright (c) 1993 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +============================================================================
8 Name:
9 PAY_GB_EPS
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 06-Feb-2012 rajganga 120.0 13654836 Created.
16 07-Feb-2012 rajganga 120.1 13654836 Added NOCOPY to OUT Params(GSCC).
17 06-Apr-2012 rajganga 120.3 13741983 Added Validations.
18 20-Apr-2012 rajganga 120.4 13975222 Added Econ and Tax Year Validations.
19 24-Apr-2012 rajganga 120.5 13799118 Modified for Workflow Notification.
20 25-Apr-2012 rajganga 120.6 13994148 Added Payment Validations.
21 29-Jul-2012 rajganga 120.7 14124206 Added Business Group ID.
22 27-Aug-2012 rajganga 120.8 14503452 Added Sequence Check.
23 11-Sep-2012 rajganga 120.9 14576477 Created a function for valueset.
24 08-Oct-2012 rajganga 120.24 14704814 Added concurrent Program who columns.
25 =============================================================================*/
26 --
27 --
28
29 PROCEDURE insert_eps_record
30 (
31 p_effective_date IN DATE,
32 p_emp_paye_reference IN VARCHAR2,
33 p_account_office_number IN VARCHAR2,
34 p_business_group_id IN NUMBER,
35 p_employer_name IN VARCHAR2,
36 p_econ_number IN VARCHAR2,
37 p_related_tax_year IN VARCHAR2,
38 p_smp_sap_spp_recovery IN NUMBER,
39 p_ssp_recovery IN NUMBER,
40 p_nic_recovery IN NUMBER,
41 p_service_company IN VARCHAR2,
42 p_smp_amt_recovered_calc IN NUMBER,
43 p_sap_amt_recovered_calc IN NUMBER,
44 p_ospp_amt_recovered_calc IN NUMBER,
45 p_aspp_amt_recovered_calc IN NUMBER,
46 p_ssp_amt_recovered_calc IN NUMBER,
47 p_nic_comp_smp_calc IN NUMBER,
48 p_nic_comp_sap_calc IN NUMBER,
49 p_nic_comp_ospp_calc IN NUMBER,
50 p_nic_comp_aspp_calc IN NUMBER,
51 p_nic_comp_ssp_calc IN NUMBER,
52 p_status IN VARCHAR2,
53 p_user_id IN NUMBER,
54 p_approver_id IN NUMBER,
55 p_request_id IN NUMBER,
56 p_program_application_id IN NUMBER,
57 p_program_id IN NUMBER,
58 p_update_date IN DATE
59 );
60
61 PROCEDURE delete_eps_record
62 ( p_effective_date IN VARCHAR2,
63 p_emp_paye_reference IN VARCHAR2,
64 p_business_group_id IN VARCHAR2,
65 p_return_status OUT NOCOPY VARCHAR2
66 );
67
68 PROCEDURE update_status_eps_record
69 ( p_effective_date IN VARCHAR2,
70 p_emp_paye_reference IN VARCHAR2,
71 p_business_group_id IN VARCHAR2,
72 p_status IN VARCHAR2,
73 p_object_version_number IN NUMBER,
74 p_workflow IN VARCHAR2,
75 p_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE update_eps_record
79 ( p_effective_date IN VARCHAR2,
80 p_emp_paye_reference IN VARCHAR2,
81 p_tax_free_pymt IN VARCHAR2,
82 p_emp_third_party IN VARCHAR2,
83 p_exp_ben_othrs IN VARCHAR2,
84 p_p11d_due IN VARCHAR2,
85 p_emp_outside_uk IN VARCHAR2,
86 p_payment_due IN VARCHAR2,
87 p_final_submission_ceased IN VARCHAR2,
88 p_final_submission_year IN VARCHAR2,
89 p_service_company IN VARCHAR2,
90 p_smp_amt_recovered_calc IN NUMBER,
91 p_sap_amt_recovered_calc IN NUMBER,
92 p_ospp_amt_recovered_calc IN NUMBER,
93 p_aspp_amt_recovered_calc IN NUMBER,
94 p_ssp_amt_recovered_calc IN NUMBER,
95 p_nic_comp_smp_calc IN NUMBER,
96 p_nic_comp_sap_calc IN NUMBER,
97 p_nic_comp_ospp_calc IN NUMBER,
98 p_nic_comp_aspp_calc IN NUMBER,
99 p_nic_comp_ssp_calc IN NUMBER,
100 p_cis_deductions_suff IN NUMBER,
101 p_nic_holiday_val IN NUMBER,
102 p_adv_from_hmrc IN NUMBER,
103 p_status IN VARCHAR2,
104 p_approver_id IN NUMBER,
105 p_object_version_number IN NUMBER,
106 p_business_group_id 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_final_submission in varchar2,
128 p_test_submission in varchar2,
129 p_business_group_id in varchar2
130 );
131
132 procedure rollback_eps
133 (
134 errbuf OUT NOCOPY VARCHAR2,
135 retcode OUT NOCOPY NUMBER,
136 p_emp_paye_reference in varchar2,
137 p_effective_date in varchar2,
138 p_business_group_id in varchar2
139 );
140
141 function validate_payments(p_emp_paye_reference varchar2,p_effective_date varchar2,p_business_group_id varchar2) return number;
142
143 function validate(emp_paye_reference varchar2,acc_off_no varchar2,employer_name varchar2,econ varchar2,tax_year varchar2,final_submission 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;