DBA Data[Home] [Help]

APPS.HREMPTER dependencies on BEN_ABV_LER

Line 400: l_old ben_abv_ler.g_abv_ler_rec;

396: l_proc varchar2(72):=g_package||'delete_assign_fpd';
397: --
398: -- Start of Fix for WWBUG 1408379
399: --
400: l_old ben_abv_ler.g_abv_ler_rec;
401: l_new ben_abv_ler.g_abv_ler_rec;
402: --
403: cursor c1 is
404: select *

Line 401: l_new ben_abv_ler.g_abv_ler_rec;

397: --
398: -- Start of Fix for WWBUG 1408379
399: --
400: l_old ben_abv_ler.g_abv_ler_rec;
401: l_new ben_abv_ler.g_abv_ler_rec;
402: --
403: cursor c1 is
404: select *
405: from per_assignment_budget_values_f abv

Line 508: ben_abv_ler.ler_chk(p_old => l_old,

504: where abv.assignment_budget_value_id = l_c1.assignment_budget_value_id
505: and abv.effective_start_date = l_c1.effective_start_date
506: and abv.effective_end_date = l_c1.effective_end_date;
507: --
508: ben_abv_ler.ler_chk(p_old => l_old,
509: p_new => l_new,
510: p_effective_date => l_c1.effective_start_date);
511: --
512: end loop;

Line 3476: l_old_abv ben_abv_ler.g_abv_ler_rec;

3472: from per_assignment_budget_values_f
3473: where assignment_id = p_assignment_id
3474: and effective_end_date = l_final_process_date;
3475: --
3476: l_old_abv ben_abv_ler.g_abv_ler_rec;
3477: l_new_abv ben_abv_ler.g_abv_ler_rec;
3478: l_c2 c2%rowtype;
3479: --
3480: -- End of Fix for WWBUG 1408379

Line 3477: l_new_abv ben_abv_ler.g_abv_ler_rec;

3473: where assignment_id = p_assignment_id
3474: and effective_end_date = l_final_process_date;
3475: --
3476: l_old_abv ben_abv_ler.g_abv_ler_rec;
3477: l_new_abv ben_abv_ler.g_abv_ler_rec;
3478: l_c2 c2%rowtype;
3479: --
3480: -- End of Fix for WWBUG 1408379
3481: --

Line 4283: ben_abv_ler.ler_chk(p_old => l_old_abv,

4279: where abv.assignment_id = c_ass_rec.assignment_id
4280: and abv.assignment_budget_value_id = l_c2.assignment_budget_value_id
4281: and abv.effective_end_date = l_final_process_date;
4282: --
4283: ben_abv_ler.ler_chk(p_old => l_old_abv,
4284: p_new => l_new_abv,
4285: p_effective_date => l_c2.effective_start_date);
4286: --
4287: end loop;