[Home] [Help]
999: -- Start fix for Bug#8522324
1000: -- This cursor is to check whether element definition is already archieved
1001: CURSOR csr_check_archived(p_pact_id NUMBER) IS
1002: SELECT 1
1003: FROM DUAL
1004: WHERE EXISTS (SELECT NULL
1005: FROM pay_action_information pai
1006: WHERE pai.action_context_id = p_pact_id
1007: AND pai.action_context_type = 'PA'
1874: SELECT decode(g_element_table(l_index).uom, 'M',
1875: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1876: rec_element_value.result_value)
1877: INTO l_result_value
1878: FROM dual;
1879:
1880:
1881: pay_action_information_api.create_action_information (
1882: p_action_information_id => l_action_info_id
2196: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
2197: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
2198:
2199: if l_error ='Y' then
2200: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
2201: else
2202: -- Start fix for Bug#8522324
2203: /* Earlier the follwoing element definition archiever logic was in ARCHIVE_DEINIT procedure. Now the
2204: element defintion details are required in the archive_code procedure to archieve element's run result
2604: THEN
2605:
2606: SELECT pay_assignment_actions_s.NEXTVAL
2607: INTO l_actid
2608: FROM dual;
2609:
2610: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
2611:
2612: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
2642: THEN
2643:
2644: SELECT pay_assignment_actions_s.NEXTVAL
2645: INTO l_actid
2646: FROM dual;
2647:
2648: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
2649:
2650: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
2918: -- create additional archive assignment actions and interlocks
2919:
2920: SELECT pay_assignment_actions_s.NEXTVAL
2921: INTO l_actid
2922: FROM dual;
2923:
2924: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);
2925: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);
2926:
3140: g_paye_ref VARCHAR2(10);
3141:
3142: CURSOR csr_check_archived(p_pact_id NUMBER) IS
3143: SELECT 1
3144: FROM DUAL
3145: WHERE EXISTS (SELECT NULL
3146: FROM pay_action_information pai
3147: WHERE pai.action_context_id = p_pact_id
3148: AND pai.action_context_type = 'PA'