[Home] [Help]
1587: SELECT decode(g_element_table(l_index).uom, 'M',
1588: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1589: rec_element_value.result_value)
1590: INTO l_result_value
1591: FROM dual;
1592:
1593:
1594: pay_action_information_api.create_action_information (
1595: p_action_information_id => l_action_info_id
1909: --Added for bug fix 3567562, call to the procedure to get the PAYE reference value
1910: get_paye_reference (l_consolidation_set,g_paye_ref,l_bg_id,l_canonical_start_date,l_canonical_end_date,l_error);
1911:
1912: if l_error ='Y' then
1913: sqlstr := 'SELECT 1 FROM dual WHERE to_char(:payroll_action_id) = dummy';
1914: else
1915:
1916:
1917: /*FOR tax_info_rec IN csr_get_org_tax_address (l_consolidation_set,g_paye_ref) LOOP
2307: THEN
2308:
2309: SELECT pay_assignment_actions_s.NEXTVAL
2310: INTO l_actid
2311: FROM dual;
2312:
2313: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
2314:
2315: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
2345: THEN
2346:
2347: SELECT pay_assignment_actions_s.NEXTVAL
2348: INTO l_actid
2349: FROM dual;
2350:
2351: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
2352:
2353: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
2612: -- create additional archive assignment actions and interlocks
2613:
2614: SELECT pay_assignment_actions_s.NEXTVAL
2615: INTO l_actid
2616: FROM dual;
2617:
2618: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);
2619: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.master_assignment_action_id,30);
2620:
2826: g_paye_ref VARCHAR2(10);
2827:
2828: CURSOR csr_check_archived(p_pact_id NUMBER) IS
2829: SELECT 1
2830: FROM DUAL
2831: WHERE EXISTS (SELECT NULL
2832: FROM pay_action_information pai
2833: WHERE pai.action_context_id = p_pact_id
2834: AND pai.action_context_type = 'PA'