[Home] [Help]
84:
85: -- Cursor to fetch the Action Information Details
86: CURSOR c_get_act_info(p_context_id NUMBER,p_defbal_id NUMBER) IS
87: SELECT pai.action_information_id,pai.object_version_number,pai.source_id,pai.action_information4
88: FROM pay_action_information pai
89: WHERE pai.action_context_id = p_context_id
90: AND pai.action_information1 = p_defbal_id
91: AND pai.action_context_type = 'AAP'
92: AND pai.action_information_category = 'EMEA BALANCES';
151: IF l_act_info_id IS NOT NULL THEN
152: l_value := pay_balance_pkg.get_value(g_statutory_balance_table(l_index).new_defined_balance_id,
153: l_source_id,v_er_le.organization_id,NULL,NULL,NULL,NULL,NULL);
154: IF l_value <> 0 THEN
155: pay_action_information_api.update_action_information
156: (p_action_information_id => l_act_info_id
157: ,p_object_version_number => l_ovn
158: ,p_action_information1 => g_statutory_balance_table(l_index).new_defined_balance_id
159: ,p_action_information4 => fnd_number.number_to_canonical(l_value)
223:
224: -- Cursor to fetch the Action Information Details
225: CURSOR c_get_act_info(p_context_id NUMBER,p_defbal_id NUMBER) IS
226: SELECT pai.action_information_id,pai.object_version_number,pai.source_id,pai.action_information4
227: FROM pay_action_information pai
228: WHERE pai.action_context_id = p_context_id
229: AND pai.action_information1 = p_defbal_id
230: AND pai.action_context_type = 'AAP'
231: AND pai.action_information_category = 'EMEA BALANCES';
232:
233: -- Cursor to fetch the action information details
234: CURSOR c_get_action_info(p_asg_action_id NUMBER,p_act_info_cat VARCHAR2) IS
235: SELECT pai.action_information_id,pai.object_version_number
236: FROM pay_action_information pai
237: WHERE pai.action_context_id = p_asg_action_id
238: AND pai.action_information_category = p_act_info_cat;
239:
240: -- Cursor to fetch the Commencement Date of the Employee
239:
240: -- Cursor to fetch the Commencement Date of the Employee
241: CURSOR c_get_comm_date(p_asg_action_id NUMBER) IS
242: SELECT act_inf.action_information11
243: FROM pay_action_information act_inf
244: WHERE act_inf.action_context_id = p_asg_action_id
245: AND act_inf.action_information_category = 'EMPLOYEE DETAILS'
246: AND act_inf.action_context_type = 'AAP';
247:
291: IF l_comm_date IS NOT NULL THEN
292:
293: l_stage := 'Update Employee Details' || v_assact.assignment_action_id || ' date '|| l_comm_date;
294: fnd_file.put_line(FND_FILE.LOG,'Updating Commencement Date to '||l_comm_date);
295: pay_action_information_api.update_action_information
296: (p_action_information_id => l_act_info_id
297: ,p_object_version_number => l_object_version_number
298: ,p_action_information30 => l_comm_date
299: );
305: l_act_info_id := v_get_act_info.action_information_id;
306:
307: l_stage := 'Update P45 Information' || v_assact.assignment_action_id || ' person '|| v_assact.person_id;
308: fnd_file.put_line(FND_FILE.LOG,'Updating Person ID to '||v_assact.person_id);
309: pay_action_information_api.update_action_information
310: (p_action_information_id => l_act_info_id
311: ,p_object_version_number => l_object_version_number
312: ,p_action_information8 => v_assact.person_id
313: );
334: IF l_act_info_id IS NOT NULL THEN
335: l_value := pay_balance_pkg.get_value(g_statutory_balance_table(l_index).new_defined_balance_id,
336: l_source_id,p_org_id,NULL,NULL,NULL,NULL,NULL);
337: IF l_value <> 0 THEN
338: pay_action_information_api.update_action_information
339: (p_action_information_id => l_act_info_id
340: ,p_object_version_number => l_ovn
341: ,p_action_information1 => g_statutory_balance_table(l_index).new_defined_balance_id
342: ,p_action_information4 => fnd_number.number_to_canonical(l_value)