[Home] [Help]
366: FROM hr_h2pi_id_mapping him,
367: hr_h2pi_payrolls pay1
368: WHERE him.to_id = pay.payroll_id
369: AND pay1.payroll_id = him.from_id
370: AND him.table_name = 'PAY_ALL_PAYROLLS_F'
371: AND him.to_business_group_id = pay.business_group_id);
372:
373: CURSOR csr_payroll_data_added(p_payroll_id NUMBER) IS
374: SELECT payroll_id
377: AND pay.payroll_id = p_payroll_id
378: AND NOT EXISTS (SELECT 'X'
379: FROM hr_h2pi_id_mapping him
380: WHERE him.to_id = pay.payroll_id
381: AND him.table_name = 'PAY_ALL_PAYROLLS_F'
382: AND him.to_business_group_id =
383: hr_h2pi_upload.g_to_business_group_id);
384:
385: l_ed_rec hr_h2pi_payrolls_v%ROWTYPE;
382: AND him.to_business_group_id =
383: hr_h2pi_upload.g_to_business_group_id);
384:
385: l_ed_rec hr_h2pi_payrolls_v%ROWTYPE;
386: l_payroll_to_id pay_all_payrolls_f.payroll_id%TYPe;
387: l_counter BINARY_INTEGER ;
388: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
389: l_record_ok BOOLEAN;
390:
384:
385: l_ed_rec hr_h2pi_payrolls_v%ROWTYPE;
386: l_payroll_to_id pay_all_payrolls_f.payroll_id%TYPe;
387: l_counter BINARY_INTEGER ;
388: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
389: l_record_ok BOOLEAN;
390:
391: l_proc VARCHAR2(72) := g_package||'validate_payroll';
392:
398: FOR v_ud_rec IN csr_payrolls LOOP
399: SAVEPOINT payroll_start;
400: hr_utility.set_location(l_proc, 20);
401: l_payroll_to_id := hr_h2pi_map.get_to_id
402: (p_table_name => 'PAY_ALL_PAYROLLS_F',
403: p_from_id => v_ud_rec.payroll_id);
404:
405: IF l_payroll_to_id = -1 THEN
406: hr_utility.set_location(l_proc, 30);
914: l_counter := l_counter + 1 ;
915: element_link_tab(l_counter) := l_element_link_to_id;
916:
917: l_payroll_id := hr_h2pi_map.get_to_id
918: (p_table_name => 'PAY_ALL_PAYROLLS_F',
919: p_from_id => v_ud_rec.payroll_id,
920: p_report_error => TRUE);
921: l_organization_id := hr_h2pi_map.get_to_id
922: (p_table_name => 'HR_ALL_ORGANIZATIONS_UNITS',