1 PACKAGE PAY_GB_MULTI_PAYROLL_RUN
2 /* $Header: pygbmps.pkh 120.0.12020000.2 2013/03/09 08:09:53 ssanjays noship $ */
3 AS
4
5 g_package varchar2(30):='PAY_GB_MULTI_PAYROLL_RUN';
6
7
8 TYPE CHILD_REQ IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
9
10
11 /*
12 Cursor to fetch all payroll parameters for a specific payroll
13 */
14 CURSOR CSR_PAYROLL_PARAMETERS(P_PAYROLL_ID IN NUMBER,P_TIME_PERIOD_NAME IN VARCHAR) IS
15 SELECT PAPF.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID,
16 PTP.REGULAR_PAYMENT_DATE REGULAR_PAY_DATE,
17 PTP.END_DATE END_DATE
18 FROM
19 PAY_ALL_PAYROLLS_F PAPF,
20 PER_TIME_PERIODS PTP
21 WHERE PTP.PAYROLL_ID=PAPF.PAYROLL_ID
22 AND PAPF.PAYROLL_ID=P_PAYROLL_ID
23 AND PTP.PERIOD_NAME=P_TIME_PERIOD_NAME;
24
25
26 /*
27 Cursor to fetch all payrolls in a specified payroll group
28 */
29 CURSOR CSR_ALL_PAYROLLS(P_PAYROLL_GROUP_ID IN NUMBER) IS
30 SELECT PAPF.PAYROLL_ID
31 FROM
32 PAY_ALL_PAYROLLS_F PAPF,
33 PAY_GB_PAYROLL_GROUP_MAPPINGS PGPGM,
34 PAY_GB_PAYROLL_GROUPS PGPG
35 WHERE PGPGM.PAYROLL_ID=PAPF.PAYROLL_ID
36 AND PGPGM.PAYROLL_GROUP_ID=PGPG.PAYROLL_GROUP_ID
37 AND PGPG.PAYROLL_GROUP_ID=P_PAYROLL_GROUP_ID;
38
39
40 /*
41 Cursor to fetch the parent request id, to store in Master child tables
42 */
43 CURSOR CSR_PARENT_REQ_ID(CHILD_REQ_ID IN NUMBER) IS
44 SELECT PAR.REQUEST_ID, PAR.ARGUMENT_TEXT
45 FROM FND_CONCURRENT_REQUESTS PAR,
46 FND_CONCURRENT_REQUESTS CHD
47 WHERE CHD.PARENT_REQUEST_ID=PAR.REQUEST_ID
48 AND CHD.REQUEST_ID=CHILD_REQ_ID;
49
50
51 PROCEDURE RUN_PAYROLL_UK(
52 ERRBUF OUT NOCOPY VARCHAR2
53 ,RETCODE OUT NOCOPY NUMBER
54 ,P_PAYROLL_GROUP_ID IN NUMBER
55 ,P_TIME_PERIOD_NAME IN VARCHAR
56 ,P_ELEMENT_SET_NAME IN NUMBER
57 ,P_RUN_TYPE IN NUMBER
58 ,P_ACTION_PARAMETER_GROUP IN VARCHAR2
59 );
60
61 PROCEDURE RUN_PREPAYMENTS_UK(
62 ERRBUF OUT NOCOPY VARCHAR2
63 ,RETCODE OUT NOCOPY NUMBER
64 ,P_PAYROLL_GROUP_ID IN NUMBER
65 ,P_START_DATE IN VARCHAR2
66 ,P_END_DATE IN VARCHAR2
67 ,P_PAYMENT_OVERRIDE_Y_N IN VARCHAR
68 ,P_PAYMENT_OVERRIDE_NAME IN VARCHAR
69 ,P_ACTION_PARAMETER_GROUP IN VARCHAR2
70 );
71
72 PROCEDURE RUN_BACS_UK(
73 ERRBUF OUT NOCOPY VARCHAR2
74 ,RETCODE OUT NOCOPY NUMBER
75 ,P_PAYROLL_GROUP_ID IN NUMBER
76 ,P_START_DATE IN VARCHAR
77 ,P_END_DATE IN VARCHAR
78 ,P_PAYMENT_TYPE IN VARCHAR2
79 ,P_PAYMENT_METHOD IN VARCHAR2
80 ,P_PROCESS_DATE IN VARCHAR
81 ,P_ACTION_PARAMETER_GROUP IN VARCHAR2
82 ,P_SORT_SEQUENCE IN VARCHAR2
83 ,P_SUBMISSION_NUMBER IN NUMBER
84 ,P_EXPIRATION_DATE IN VARCHAR
85 ,P_AUDIT_SAM_FREQ IN NUMBER
86 ,P_B_REPORT_TYPE IN VARCHAR2
87 ,P_B_FORMAT_TYPE IN VARCHAR2
88 );
89
90 PROCEDURE RUN_CHEQUE_WRITER_UK(
91 ERRBUF OUT NOCOPY VARCHAR2
92 ,RETCODE OUT NOCOPY NUMBER
93 ,P_PAYROLL_GROUP_ID IN NUMBER
94 ,P_START_DATE IN VARCHAR2
95 ,P_END_DATE IN VARCHAR2
96 ,P_PAYMENT_TYPE IN VARCHAR2
97 ,P_PAYMENT_METHOD IN VARCHAR2
98 ,P_SORT_SEQUENCE IN VARCHAR2
99 ,P_CHEQUE_STYLE IN VARCHAR2
100 ,P_CHEQUE_START_NUMBER IN NUMBER
101 ,P_CHEQUE_END_NUMBER IN NUMBER
102 ,P_ACTION_PARAMETER_GROUP IN VARCHAR2
103 );
104
105 PROCEDURE RUN_SS_PAY_SLIP_UK(
106
107 ERRBUF OUT NOCOPY VARCHAR2
108 ,RETCODE OUT NOCOPY NUMBER
109 ,P_START_DATE IN VARCHAR
110 ,P_EFFECTIVE_DATE IN VARCHAR
111 ,P_BUSINESS_GROUP_ID IN NUMBER
112 ,P_ACTION_PARAMETER_GROUP IN VARCHAR2
113 ,P_END_DATE IN VARCHAR2
114 ,P_PAYROLL_GROUP_ID IN NUMBER
115 ,P_ARCHIVE_START_DATE IN VARCHAR2
116 ,P_ARCHIVE_END_DATE IN VARCHAR
117 ,P_ARCHIVE_START_DATE_HIDDEN IN VARCHAR2
118 ,P_ARCHIVE_END_DATE_HIDDEN IN VARCHAR2
119 );
120
121 PROCEDURE RUN_RETRO_ENHANCED(
122 ERRBUF OUT NOCOPY VARCHAR2
123 ,RETCODE OUT NOCOPY NUMBER
124 ,P_ELEMENT_SET IN VARCHAR2
125 ,P_START_DATE IN VARCHAR2
126 ,P_EFFECTIVE_DATE IN VARCHAR2
127 ,P_ACTION_PARAMETER_GROUP IN VARCHAR2
128 ,P_RETRO_PAY_DEF IN VARCHAR2
129 ,P_PAYROLL_GROUP_ID IN NUMBER
130 ,P_ENTRY_CREATION_DATE IN VARCHAR2
131 );
132
133 PROCEDURE RUN_TPL_MULTI(
134 ERRBUF OUT NOCOPY VARCHAR2
135 ,RETCODE OUT NOCOPY NUMBER
136 ,P_BUSINESS_GROUP_ID IN NUMBER
137 ,P_PAYROLL_GROUP_ID IN NUMBER
138 ,P_TIME_PERIOD_NAME IN VARCHAR2
139 ,P_SORT_ORDER IN VARCHAR2
140 ,P_SUMMARY_ONLY IN VARCHAR2
141 );
142
143 PROCEDURE RUN_PAY_SUM_REP(
144 ERRBUF OUT NOCOPY VARCHAR2
145 ,RETCODE OUT NOCOPY NUMBER
146 ,P_BUSINESS_GROUP_ID IN NUMBER
147 ,P_PAYROLL_GROUP_ID IN NUMBER
148 ,P_EARLY_START_DATE IN VARCHAR2
149 ,P_EARLY_END_DATE IN VARCHAR2
150 );
151
152 PROCEDURE RUN_GROSS_TO_NET_MULTI(
153 ERRBUF OUT NOCOPY VARCHAR2
154 ,RETCODE OUT NOCOPY NUMBER
155 ,P_BUSINESS_GROUP_ID IN NUMBER
156 ,P_PAYROLL_GROUP_ID IN NUMBER
157 ,P_TIME_PERIOD_NAME IN VARCHAR2
158 ,P_GROSS_PAY_ID IN NUMBER
159 ,P_TOT_DED_ID IN NUMBER
160 ,P_DIR_PAY_ID IN NUMBER
161 ,P_EMP_CHAR_ID IN NUMBER
162 );
163
164
165 PROCEDURE RUN_ROLLBACK_RUN_UK(
166
167 ERRBUF OUT NOCOPY VARCHAR2
168 ,RETCODE OUT NOCOPY NUMBER
169 ,P_PAYROLL_GROUP_ID IN NUMBER
170 ,P_PARENT_REQ_ID IN NUMBER
171 );
172
173 PROCEDURE RUN_ROLLBACK_ALL_UK(
174
175 ERRBUF OUT NOCOPY VARCHAR2
176 ,RETCODE OUT NOCOPY NUMBER
177 ,P_YEAR IN NUMBER
178 ,P_PAYROLL_GROUP_ID IN NUMBER
179 ,P_PROCESS_TYPE IN VARCHAR2
180 ,P_PROCESS_NAME IN NUMBER
181 );
182
183 END PAY_GB_MULTI_PAYROLL_RUN;