[Home] [Help]
315: g_ptu_balance_value_tab.DELETE;
316: g_ye_balance_value_tab.DELETE;
317:
318: /*This code will be move to script and mapped to this file if needed*/
319: pay_mx_archive_dbi_pkg.create_archive_routes;
320: hr_utility.trace('Called from initialization_code and initialized for whole process');
321: hr_utility.trace('Getting the year end balances ');
322: OPEN c_get_balances ;
323: FETCH c_get_balances BULK COLLECT INTO g_archive_item_details;
330: FOR i IN g_archive_item_details.first..g_archive_item_details.last
331: LOOP
332: -- initialize for year end balance id for BBR
333: g_ye_balance_value_tab(i).defined_balance_id := g_archive_item_details(i).def_bal_id;
334: pay_mx_archive_dbi_pkg.create_archive_dbi('A_' || g_archive_item_details(i).user_entity_name);
335: END loop;
336:
337: FOR j IN g_ptu_bal_details.first..g_ptu_bal_details.last
338: LOOP
337: FOR j IN g_ptu_bal_details.first..g_ptu_bal_details.last
338: LOOP
339: -- initialize for ptu year end balance id for BBR
340: g_ptu_balance_value_tab(j).defined_balance_id := g_ptu_bal_details(j).def_bal_id;
341: pay_mx_archive_dbi_pkg.create_archive_dbi('A_' || g_ptu_bal_details(j).user_entity_name);
342: END loop;
343:
344: end load_ye_balance;
345:
701:
702: -- Create the Archive DBI routes if they don't exist
703: --
704: hr_utility.set_location(gv_package || lv_procedure_name, 10);
705: /* pay_mx_archive_dbi_pkg.create_archive_routes;*/
706: hr_utility.trace('p_prev_archiver_exists ' || p_prev_archiver_exists);
707: hr_utility.trace('p_ytd_action_id ' || p_ytd_action_id);
708: /*Modified the code logic, by using BBR for bug 7529502*/
709: IF p_prev_archiver_exists = 'Y' THEN