DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_MANAGE_LIFE_EVENTS

Line 414: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

410: --
411: end DetectPILInfo;
412: --
413: procedure DetectBCOLRowInfo
414: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
415: ,p_effective_date in date
416: ,p_business_group_id in number
417: --
418: ,p_faterr_code out nocopy varchar2

Line 458: ,ben_manage_life_events.g_cmp_flag) <> 0)

454: --
455: -- Check for a comp DF
456: --
457: IF (bitand(p_comp_obj_tree_row.flag_bit_val
458: ,ben_manage_life_events.g_cmp_flag) <> 0)
459: THEN
460: --
461: ben_derive_part_and_rate_cache.get_comp_elig
462: (p_pgm_id => p_comp_obj_tree_row.pgm_id

Line 475: ,ben_manage_life_events.g_cmp_rt_flag) <> 0)

471: --
472: p_faterr_code := null;
473: --
474: elsif (bitand(p_comp_obj_tree_row.flag_bit_val
475: ,ben_manage_life_events.g_cmp_rt_flag) <> 0)
476: OR
477: (p_comp_obj_tree_row.oiplip_id IS NOT NULL
478: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
479: ,ben_manage_life_events.g_cmp_rt_flag) <> 0)

Line 479: ,ben_manage_life_events.g_cmp_rt_flag) <> 0)

475: ,ben_manage_life_events.g_cmp_rt_flag) <> 0)
476: OR
477: (p_comp_obj_tree_row.oiplip_id IS NOT NULL
478: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
479: ,ben_manage_life_events.g_cmp_rt_flag) <> 0)
480: THEN
481: --
482: ben_derive_part_and_rate_cache.get_comp_rate
483: (p_pgm_id => p_comp_obj_tree_row.pgm_id

Line 1497: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;

1493: l_nomatco boolean;
1494: l_noattdf boolean;
1495: l_nocmpattdf boolean;
1496: --
1497: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
1498: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1499: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1500: l_df_counts ben_efc_functions.g_attach_df_counts;
1501: l_per_row per_all_people_f%ROWTYPE;

Line 1498: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;

1494: l_noattdf boolean;
1495: l_nocmpattdf boolean;
1496: --
1497: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
1498: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1499: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1500: l_df_counts ben_efc_functions.g_attach_df_counts;
1501: l_per_row per_all_people_f%ROWTYPE;
1502: l_empasg_row per_all_assignments_f%ROWTYPE;

Line 1499: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;

1495: l_nocmpattdf boolean;
1496: --
1497: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
1498: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1499: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
1500: l_df_counts ben_efc_functions.g_attach_df_counts;
1501: l_per_row per_all_people_f%ROWTYPE;
1502: l_empasg_row per_all_assignments_f%ROWTYPE;
1503: l_benasg_row per_all_assignments_f%ROWTYPE;

Line 1679: ben_manage_life_events.g_cache_proc_object.delete;

1675: ben_pil_object.clear_down_cache;
1676: --
1677: if nvl(l_prevbgp_id,-9999) <> l_efc_row.business_group_id then
1678: --
1679: ben_manage_life_events.g_cache_proc_object.delete;
1680: --
1681: end if;
1682: --
1683: begin

Line 1694: l_comp_obj_tree := ben_manage_life_events.g_cache_proc_object;

1690: ,p_mode => l_mode
1691: );
1692: --
1693: l_prevbgp_id := l_efc_row.business_group_id;
1694: l_comp_obj_tree := ben_manage_life_events.g_cache_proc_object;
1695: --
1696: -- Set comp object context values
1697: --
1698: l_comp_obj_tree_row := l_init_comp_obj_tree_row;

Line 2127: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;

2123: l_nomatco boolean;
2124: l_noattdf boolean;
2125: l_nocmpattdf boolean;
2126: --
2127: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
2128: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2129: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2130: l_df_counts ben_efc_functions.g_attach_df_counts;
2131: l_per_row per_all_people_f%ROWTYPE;

Line 2128: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;

2124: l_noattdf boolean;
2125: l_nocmpattdf boolean;
2126: --
2127: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
2128: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2129: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2130: l_df_counts ben_efc_functions.g_attach_df_counts;
2131: l_per_row per_all_people_f%ROWTYPE;
2132: l_empasg_row per_all_assignments_f%ROWTYPE;

Line 2129: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;

2125: l_nocmpattdf boolean;
2126: --
2127: l_comp_obj_tree ben_manage_life_events.g_cache_proc_object_table;
2128: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2129: l_init_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
2130: l_df_counts ben_efc_functions.g_attach_df_counts;
2131: l_per_row per_all_people_f%ROWTYPE;
2132: l_empasg_row per_all_assignments_f%ROWTYPE;
2133: l_benasg_row per_all_assignments_f%ROWTYPE;

Line 2378: ben_manage_life_events.g_cache_proc_object.delete;

2374: ben_pil_object.clear_down_cache;
2375: --
2376: if nvl(l_prevbgp_id,-9999) <> l_efc_row.business_group_id then
2377: --
2378: ben_manage_life_events.g_cache_proc_object.delete;
2379: --
2380: end if;
2381: --
2382: begin

Line 2393: l_comp_obj_tree := ben_manage_life_events.g_cache_proc_object;

2389: ,p_mode => l_mode
2390: );
2391: --
2392: l_prevbgp_id := l_efc_row.business_group_id;
2393: l_comp_obj_tree := ben_manage_life_events.g_cache_proc_object;
2394: --
2395: -- Set comp object context values
2396: --
2397: l_comp_obj_tree_row := l_init_comp_obj_tree_row;

Line 3413: when ben_manage_life_events.g_record_error then

3409: ,p_enb_valrow => l_enb_valrow
3410: );
3411: --
3412: exception
3413: when ben_manage_life_events.g_record_error then
3414: --
3415: fnd_message.raise_error;
3416: --
3417: end;