DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_BENEFIT_ACTIONS dependencies on BENUTILS

Line 241: l_param_rec benutils.g_batch_param_rec;

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'

Line 268: benutils.get_batch_parameters

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

Line 297: benutils.write_table_and_file(p_table => true,

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.

Line 353: ,p_personid_va in out nocopy benutils.g_number_table

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: )

Line 354: ,p_pactid_va in out nocopy benutils.g_number_table

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

Line 355: ,p_pactovn_va in out nocopy benutils.g_number_table

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: --

Line 356: ,p_lerid_va in out nocopy benutils.g_number_table

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();

Line 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: --

Line 361: l_pactid_va benutils.g_number_table := 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: --
365: cursor c_person_details

Line 362: l_pactovn_va benutils.g_number_table := benutils.g_number_table();

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

Line 363: l_lerid_va benutils.g_number_table := benutils.g_number_table();

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