237: l_package varchar2(80) := g_package||'.check_all_slaves_finished';
238: l_no_slaves boolean := true;
239: l_dummy varchar2(1);
240: l_master varchar2(1) := 'N';
241: l_param_rec benutils.g_batch_param_rec;
242: l_slave_errored boolean := false;
243: --
244: cursor c_master is
245: select 'Y'
264: fetch c_master into l_master;
265: --
266: close c_master;
267: --
268: benutils.get_batch_parameters
269: (p_benefit_action_id => p_benefit_action_id,
270: p_rec => l_param_rec);
271: --
272: -- Check slave status
293: --
294: end if;
295: hr_utility.set_location (l_package||' Write to file ',35);
296: --
297: benutils.write_table_and_file(p_table => true,
298: p_file => false);
299: commit;
300: --
301: -- Fire off Reports for BENMNGLE run.
349: (p_benefit_action_id in number
350: ,p_start_person_action_id in number
351: ,p_end_person_action_id in number
352: --
353: ,p_personid_va in out nocopy benutils.g_number_table
354: ,p_pactid_va in out nocopy benutils.g_number_table
355: ,p_pactovn_va in out nocopy benutils.g_number_table
356: ,p_lerid_va in out nocopy benutils.g_number_table
357: )
350: ,p_start_person_action_id in number
351: ,p_end_person_action_id in number
352: --
353: ,p_personid_va in out nocopy benutils.g_number_table
354: ,p_pactid_va in out nocopy benutils.g_number_table
355: ,p_pactovn_va in out nocopy benutils.g_number_table
356: ,p_lerid_va in out nocopy benutils.g_number_table
357: )
358: IS
351: ,p_end_person_action_id in number
352: --
353: ,p_personid_va in out nocopy benutils.g_number_table
354: ,p_pactid_va in out nocopy benutils.g_number_table
355: ,p_pactovn_va in out nocopy benutils.g_number_table
356: ,p_lerid_va in out nocopy benutils.g_number_table
357: )
358: IS
359: --
352: --
353: ,p_personid_va in out nocopy benutils.g_number_table
354: ,p_pactid_va in out nocopy benutils.g_number_table
355: ,p_pactovn_va in out nocopy benutils.g_number_table
356: ,p_lerid_va in out nocopy benutils.g_number_table
357: )
358: IS
359: --
360: l_personid_va benutils.g_number_table := benutils.g_number_table();
356: ,p_lerid_va in out nocopy benutils.g_number_table
357: )
358: IS
359: --
360: l_personid_va benutils.g_number_table := benutils.g_number_table();
361: l_pactid_va benutils.g_number_table := benutils.g_number_table();
362: l_pactovn_va benutils.g_number_table := benutils.g_number_table();
363: l_lerid_va benutils.g_number_table := benutils.g_number_table();
364: --
357: )
358: IS
359: --
360: l_personid_va benutils.g_number_table := benutils.g_number_table();
361: l_pactid_va benutils.g_number_table := benutils.g_number_table();
362: l_pactovn_va benutils.g_number_table := benutils.g_number_table();
363: l_lerid_va benutils.g_number_table := benutils.g_number_table();
364: --
365: cursor c_person_details
358: IS
359: --
360: l_personid_va benutils.g_number_table := benutils.g_number_table();
361: l_pactid_va benutils.g_number_table := benutils.g_number_table();
362: l_pactovn_va benutils.g_number_table := benutils.g_number_table();
363: l_lerid_va benutils.g_number_table := benutils.g_number_table();
364: --
365: cursor c_person_details
366: (c_bft_id number
359: --
360: l_personid_va benutils.g_number_table := benutils.g_number_table();
361: l_pactid_va benutils.g_number_table := benutils.g_number_table();
362: l_pactovn_va benutils.g_number_table := benutils.g_number_table();
363: l_lerid_va benutils.g_number_table := benutils.g_number_table();
364: --
365: cursor c_person_details
366: (c_bft_id number
367: ,c_stpact_id number