[Home] [Help]
171: close csr_bat;
172: --
173: -- Set the status of this record
174: --
175: pay_batch_object_status_pkg.set_status
176: (p_object_type => 'BEL'
177: ,p_object_id => p_batch_element_link_id
178: ,p_object_status => 'P'
179: ,p_payroll_action_id => p_payroll_action_id
255: or (l_bat_rec.people_group_id is not null) then
256: --
257: -- Set the batch object status
258: --
259: pay_batch_object_status_pkg.set_status
260: (p_object_type => 'EL'
261: ,p_object_id => l_link_rec.element_link_id
262: ,p_object_status => 'U'
263: ,p_payroll_action_id => p_payroll_action_id
266: end if;
267: --
268: -- Update the batch record as complete.
269: --
270: pay_batch_object_status_pkg.set_status
271: (p_object_type => 'BEL'
272: ,p_object_id => p_batch_element_link_id
273: ,p_object_status => 'C'
274: ,p_payroll_action_id => p_payroll_action_id
418: bat.business_group_id = p_bgid
419: and (bat.batch_element_link_id = p_batlink_id
420: or ( p_gen_link_type = 'A'
421: and p_batlink_id is null
422: and nvl(pay_batch_object_status_pkg.get_status
423: ('BEL',bat.batch_element_link_id)
424: ,'U') <> 'C')
425: )
426: and bat.element_link_id is null
537: ,bos.payroll_action_id
538: ,bos.object_status
539: from
540: pay_element_links_f pel
541: ,pay_batch_object_status bos
542: where
543: p_phase = 1
544: and ( pel.element_link_id = p_elelink_id
545: or ( p_gen_link_type = 'A'
596: --
597: ,bos.payroll_action_id
598: ,bos.object_status
599: from
600: pay_batch_object_status bos
601: ,pay_element_links_f pel
602: where
603: bos.payroll_action_id = p_pact_id
604: and bos.object_type = 'EL'
644: is
645: pragma autonomous_transaction;
646: begin
647: --
648: pay_batch_object_status_pkg.set_status
649: (p_object_type => 'EL'
650: ,p_object_id => p_element_link_id
651: ,p_object_status => 'P'
652: ,p_payroll_action_id => p_payroll_action_id
725: null;
726:
727: elsif p_phase = 1 then
728: --
729: pay_batch_object_status_pkg.set_status
730: (p_object_type => 'EL'
731: ,p_object_id => l_rec.element_link_id
732: ,p_object_status => 'P'
733: ,p_payroll_action_id => p_pact_rec.payroll_action_id
1249: for i in 1..g_batch_links.count loop
1250: --
1251: begin
1252: if g_batch_links(i) = g_err_batch_link_id then
1253: pay_batch_object_status_pkg.set_status
1254: (p_object_type => 'BEL'
1255: ,p_object_id => g_err_batch_link_id
1256: ,p_object_status => 'E'
1257: ,p_payroll_action_id => p_payroll_action_id
1256: ,p_object_status => 'E'
1257: ,p_payroll_action_id => p_payroll_action_id
1258: );
1259: else
1260: pay_batch_object_status_pkg.set_status
1261: (p_object_type => 'BEL'
1262: ,p_object_id => g_batch_links(i)
1263: ,p_object_status => 'U'
1264: ,p_payroll_action_id => p_payroll_action_id
1281:
1282: --
1283: -- Delete the object status records.
1284: --
1285: delete from pay_batch_object_status
1286: where payroll_action_id = p_payroll_action_id
1287: and object_status in ('P', 'C')
1288: ;
1289: --
1288: ;
1289: --
1290: -- Unset payroll action id for other status.
1291: --
1292: update pay_batch_object_status
1293: set payroll_action_id = null
1294: where payroll_action_id = p_payroll_action_id
1295: ;
1296: elsif l_status in ('C','I') then
1296: elsif l_status in ('C','I') then
1297: --
1298: -- Update the status for the processing records.
1299: --
1300: update pay_batch_object_status
1301: set object_status = l_status
1302: where payroll_action_id = p_payroll_action_id
1303: and object_status = 'P'
1304: ;
1306: --
1307: -- Ensure there is no processing records just in case.
1308: --
1309: select count(1) into l_count
1310: from pay_batch_object_status
1311: where payroll_action_id = p_payroll_action_id
1312: and object_status = 'P'
1313: ;
1314: --