eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_PAY_BASES

Line 197: SELECT * FROM hr_h2pi_pay_bases

193:
194: pay_bases_tab pay_bases_tab_type;
195:
196: CURSOR csr_pay_bases IS
197: SELECT * FROM hr_h2pi_pay_bases
198: WHERE client_id = p_from_client_id;
199:
200: CURSOR csr_pay_pay_bases IS
201: SELECT pay_basis_id

Line 202: FROM hr_h2pi_pay_bases_v

198: WHERE client_id = p_from_client_id;
199:
200: CURSOR csr_pay_pay_bases IS
201: SELECT pay_basis_id
202: FROM hr_h2pi_pay_bases_v
203: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
204:
205: CURSOR csr_hr_data_removed (p_pay_basis_id NUMBER) IS
206: SELECT pay_basis_id

Line 207: FROM hr_h2pi_pay_bases_v pay

203: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
204:
205: CURSOR csr_hr_data_removed (p_pay_basis_id NUMBER) IS
206: SELECT pay_basis_id
207: FROM hr_h2pi_pay_bases_v pay
208: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
209: AND pay.pay_basis_id = p_pay_basis_id
210: AND NOT EXISTS (SELECT 'X'
211: FROM hr_h2pi_id_mapping him,

Line 212: hr_h2pi_pay_bases pay1

208: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_Id
209: AND pay.pay_basis_id = p_pay_basis_id
210: AND NOT EXISTS (SELECT 'X'
211: FROM hr_h2pi_id_mapping him,
212: hr_h2pi_pay_bases pay1
213: WHERE him.to_id = pay.pay_basis_id
214: AND pay1.pay_basis_id = him.from_id
215: AND him.table_name = 'PER_PAY_BASES'
216: AND him.to_business_group_id = pay.business_group_id);

Line 220: FROM hr_h2pi_pay_bases_v pay

216: AND him.to_business_group_id = pay.business_group_id);
217:
218: CURSOR csr_payroll_data_added(p_pay_basis_id NUMBER) IS
219: SELECT pay_basis_id
220: FROM hr_h2pi_pay_bases_v pay
221: WHERE pay.business_group_id = hr_h2pi_upload.g_to_business_group_id
222: AND pay.pay_basis_id = p_pay_basis_id
223: AND NOT EXISTS (SELECT 'X'
224: FROM hr_h2pi_id_mapping him

Line 230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;

226: AND him.table_name = 'PER_PAY_BASES'
227: AND him.to_business_group_id =
228: hr_h2pi_upload.g_to_business_group_id);
229:
230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;
231: l_pay_basis_to_id hr_h2pi_pay_bases.pay_basis_id%TYPe;
232: l_counter BINARY_INTEGER ;
233: l_pay_basis_id hr_h2pi_pay_bases.pay_basis_id%TYPE;
234: l_record_ok BOOLEAN;

Line 231: l_pay_basis_to_id hr_h2pi_pay_bases.pay_basis_id%TYPe;

227: AND him.to_business_group_id =
228: hr_h2pi_upload.g_to_business_group_id);
229:
230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;
231: l_pay_basis_to_id hr_h2pi_pay_bases.pay_basis_id%TYPe;
232: l_counter BINARY_INTEGER ;
233: l_pay_basis_id hr_h2pi_pay_bases.pay_basis_id%TYPE;
234: l_record_ok BOOLEAN;
235:

Line 233: l_pay_basis_id hr_h2pi_pay_bases.pay_basis_id%TYPE;

229:
230: l_ed_rec hr_h2pi_pay_bases_v%ROWTYPE;
231: l_pay_basis_to_id hr_h2pi_pay_bases.pay_basis_id%TYPe;
232: l_counter BINARY_INTEGER ;
233: l_pay_basis_id hr_h2pi_pay_bases.pay_basis_id%TYPE;
234: l_record_ok BOOLEAN;
235:
236: l_proc VARCHAR2(72) := g_package||'validate_pay_basis';
237:

Line 253: p_table_name => 'HR_H2PI_PAY_BASES',

249:
250: IF l_pay_basis_to_id = -1 THEN
251: hr_utility.set_location(l_proc, 30);
252: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,
253: p_table_name => 'HR_H2PI_PAY_BASES',
254: p_message_level => 'FATAL',
255: p_message_name => 'HR_289260_UD_DATA_ADDED');
256: ELSE
257: hr_utility.set_location(l_proc, 40);

Line 261: FROM hr_h2pi_pay_bases_v

257: hr_utility.set_location(l_proc, 40);
258: BEGIN
259: SELECT *
260: INTO l_ed_rec
261: FROM hr_h2pi_pay_bases_v
262: WHERE pay_basis_id = l_pay_basis_to_id;
263:
264: l_counter := l_counter + 1 ;
265: pay_bases_tab(l_counter) := l_pay_basis_to_id;

Line 271: p_table_name => 'HR_H2PI_PAY_BASES',

267: IF l_ed_rec.name <> v_ud_rec.name OR
268: l_ed_rec.pay_basis <> v_ud_rec.pay_basis THEN
269: hr_utility.set_location(l_proc, 50);
270: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,
271: p_table_name => 'HR_H2PI_PAY_BASES',
272: p_message_level => 'FATAL',
273: p_message_name => 'HR_289237_DATA_MISMATCH');
274: END IF;
275:

Line 280: p_table_name => 'HR_H2PI_PAY_BASES',

276: EXCEPTION
277: WHEN NO_DATA_FOUND THEN
278: hr_utility.set_location(l_proc, 60);
279: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,
280: p_table_name => 'HR_H2PI_PAY_BASES',
281: p_message_level=> 'FATAL',
282: p_message_name => 'HR_289235_ED_DATA_REMOVED');
283: WHEN MAPPING_ID_MISSING THEN
284: hr_utility.set_location(l_proc, 70);

Line 311: p_table_name => 'HR_H2PI_PAY_BASES',

307: IF csr_payroll_data_added%FOUND then
308: -- Pay basis data added.
309: hr_utility.set_location(l_proc, 100);
310: hr_h2pi_error.data_error(p_from_id => l_pay_basis_id,
311: p_table_name => 'HR_H2PI_PAY_BASES',
312: p_message_level => 'FATAL',
313: p_message_name => 'HR_289259_ED_DATA_ADDED');
314: CLOSE csr_payroll_data_added;
315:

Line 327: p_table_name => 'HR_H2PI_PAY_BASES',

323: IF csr_hr_data_removed%FOUND then
324: --HR Data removed
325: hr_utility.set_location(l_proc, 120);
326: hr_h2pi_error.data_error(p_from_id => l_pay_basis_id,
327: p_table_name => 'HR_H2PI_PAY_BASES',
328: p_message_level => 'FATAL',
329: p_message_name => 'HR_289236_UD_DATA_REMOVED');
330: END IF;
331: CLOSE csr_hr_data_removed;