APPS.PA_PAY_VALIDATE dependencies on PA_PAY_EXT_INTERFACE_HEADER

Line 38: from pa_pay_ext_interface_header

34: cursor Int_header_details IS
35: select interface_header_id,time_period_start_date,
36: time_period_end_date,payroll_batch_id,payroll_id,
37: payroll_name,business_group_id,business_group_name
38: from pa_pay_ext_interface_header
39: where time_period_start_date >=x_start_date and
40: time_period_end_date <=x_end_date
41: and payroll_id = nvl(x_payroll_id,payroll_id)
42: for update of rejection_code;

Line 49: from pa_pay_ext_interface_header

45: /* Start changes for bug#13531404 */
46:
47: cursor Int_payroll_details IS
48: select payroll_name,interface_header_id
49: from pa_pay_ext_interface_header
50: where payroll_id is null
51: and time_period_start_date >=x_start_date and
52: time_period_end_date <=x_end_date
53: for update of payroll_id;

Line 83: update pa_pay_ext_interface_header

79:
80: IF l_payroll_id is not null THEN
81: --{
82:
83: update pa_pay_ext_interface_header
84: set payroll_id = l_payroll_id
85: where payroll_name = Pay_rec.payroll_name
86: and interface_header_id = Pay_rec.interface_header_id
87: and payroll_id is null;

Line 135: Update pa_pay_ext_interface_header eih

131:
132:
133: /* Validation to check valid business group id */
134:
135: Update pa_pay_ext_interface_header eih
136: set rejection_code = 'RC 150'
137: where interface_header_id = Hdr_rec.interface_header_id
138: and not exists (select null from hr_organization_units hou
139: where hou.business_group_id = nvl(Hdr_rec.business_group_id,l_group_id)

Line 175: Update pa_pay_ext_interface_header eih

171: END IF;
172:
173: /* Validation to check valid payroll */
174:
175: Update pa_pay_ext_interface_header eih
176: set rejection_code = 'RC 155'
177: where interface_header_id = Hdr_rec.interface_header_id
178: and not exists (select null from pa_pay_external_payroll ppep
179: where ppep.business_group_id = nvl(Hdr_rec.business_group_id,l_group_id)

Line 203: select count(1) into l_value_exists from pa_pay_ext_interface_header

199: ELSE
200: --{
201: /* Validation to check whether payroll for the same period is processed */
202:
203: select count(1) into l_value_exists from pa_pay_ext_interface_header
204: where time_period_start_date = Hdr_rec.time_period_start_date
205: and time_period_end_date = Hdr_rec.time_period_end_date
206: and payroll_batch_id = Hdr_rec.payroll_batch_id
207: and payroll_id = nvl(Hdr_rec.payroll_id,l_payroll_id)

Line 217: update pa_pay_ext_interface_header

213: --{
214:
215:
216:
217: update pa_pay_ext_interface_header
218: set rejection_code = 'RC 160'
219: where current of Int_header_details;
220:
221: update pa_pay_ext_interface_details

Line 237: select count(1) into l_value_exists from pa_pay_ext_interface_header

233: --{
234:
235: /* Validation to check whether any overlap in the pay periods */
236:
237: select count(1) into l_value_exists from pa_pay_ext_interface_header
238: where payroll_id = nvl(Hdr_rec.payroll_id,l_payroll_id)
239: and business_group_id = NVL(Hdr_rec.business_group_id,l_group_id)
240: and rejection_code is null
241: and ((Hdr_rec.time_period_start_date between time_period_start_date and time_period_end_date)

Line 252: update pa_pay_ext_interface_header

248: IF l_value_exists >1 THEN
249: --{
250:
251:
252: update pa_pay_ext_interface_header
253: set rejection_code = 'RC 165'
254: where current of Int_header_details;
255:
256: update pa_pay_ext_interface_details