DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_EFC_FUNCTIONS

Line 1500: l_df_counts ben_efc_functions.g_attach_df_counts;

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;
1504: l_pil_row ben_per_in_ler%rowtype;

Line 1777: ben_efc_functions.CompObject_ChkAttachDF

1773: l_compobj_id := l_comp_obj_tree_row.pgm_id;
1774: --
1775: end if;
1776: --
1777: ben_efc_functions.CompObject_ChkAttachDF
1778: (p_coent_scode => l_coent_scode
1779: ,p_compobj_id => l_compobj_id
1780: --
1781: ,p_counts => l_df_counts

Line 1940: ben_efc_functions.maintain_chunks

1936: -- Check for end of chunk and commit if necessary
1937: --
1938: l_pk1 := l_efc_row.elig_per_id;
1939: --
1940: ben_efc_functions.maintain_chunks
1941: (p_row_count => l_row_count
1942: ,p_pk1 => l_pk1
1943: ,p_chunk_size => p_chunk
1944: ,p_efc_worker_id => p_efc_worker_id

Line 2002: ben_efc_functions.conv_check

1998: --
1999: end loop;
2000: CLOSE c_efc_rows;
2001: --
2002: ben_efc_functions.conv_check
2003: (p_table_name => 'ben_elig_per_f'
2004: ,p_efctable_name => 'ben_elig_per_f_efc'
2005: --
2006: ,p_tabwhere_clause => ' (comp_ref_amt is not null '

Line 2130: l_df_counts ben_efc_functions.g_attach_df_counts;

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;
2134: l_pil_row ben_per_in_ler%rowtype;

Line 2483: ben_efc_functions.CompObject_ChkAttachDF

2479: l_oipl_count := l_oipl_count+1;
2480: --
2481: -- Check for attached derived factors
2482: --
2483: ben_efc_functions.CompObject_ChkAttachDF
2484: (p_coent_scode => 'COP'
2485: ,p_compobj_id => l_oipl_id
2486: --
2487: ,p_counts => l_df_counts

Line 2660: ben_efc_functions.maintain_chunks

2656: -- Check for end of chunk and commit if necessary
2657: --
2658: l_pk1 := l_efc_row.elig_per_opt_id;
2659: --
2660: ben_efc_functions.maintain_chunks
2661: (p_row_count => l_row_count
2662: ,p_pk1 => l_pk1
2663: ,p_chunk_size => p_chunk
2664: ,p_efc_worker_id => p_efc_worker_id

Line 2723: ben_efc_functions.conv_check

2719: CLOSE c_efc_rows;
2720: --
2721: -- Check that all rows have been converted or excluded
2722: --
2723: ben_efc_functions.conv_check
2724: (p_table_name => 'ben_elig_per_opt_f'
2725: ,p_efctable_name => 'ben_elig_per_opt_f_efc'
2726: ,p_tabwhere_clause => ' (comp_ref_amt is not null '
2727: ||' or rt_comp_ref_amt is not null) '

Line 3565: ben_efc_functions.CompObject_GetParUom

3561: --
3562: --
3563: -- Get the parent UOM
3564: --
3565: ben_efc_functions.CompObject_GetParUom
3566: (p_pgm_id => l_efc_row.pgm_id
3567: ,p_ptip_id => l_efc_row.ptip_id
3568: ,p_pl_id => l_efc_row.pl_id
3569: ,p_plip_id => l_efc_row.plip_id

Line 3786: ben_efc_functions.maintain_chunks

3782: -- Check for end of chunk and commit if necessary
3783: --
3784: l_pk1 := l_efc_row.enrt_bnft_id;
3785: --
3786: ben_efc_functions.maintain_chunks
3787: (p_row_count => l_row_count
3788: ,p_pk1 => l_pk1
3789: ,p_chunk_size => p_chunk
3790: ,p_efc_worker_id => p_efc_worker_id

Line 3861: ben_efc_functions.conv_check

3857: CLOSE c_efc_rows;
3858: --
3859: -- Check that all rows have been converted or excluded
3860: --
3861: ben_efc_functions.conv_check
3862: (p_table_name => 'ben_enrt_bnft'
3863: ,p_efctable_name => 'ben_enrt_bnft_efc'
3864: ,p_tabwhere_clause => ' (mx_wout_ctfn_val is not null '
3865: ||' or mn_val is not null '

Line 4418: ben_efc_functions.maintain_chunks

4414: -- Check for end of chunk and commit if necessary
4415: --
4416: l_pk1 := l_efc_row.enrt_prem_id;
4417: --
4418: ben_efc_functions.maintain_chunks
4419: (p_row_count => l_row_count
4420: ,p_pk1 => l_pk1
4421: ,p_chunk_size => p_chunk
4422: ,p_efc_worker_id => p_efc_worker_id

Line 4480: ben_efc_functions.conv_check

4476: */
4477: --
4478: -- Check that all rows have been converted or excluded
4479: --
4480: ben_efc_functions.conv_check
4481: (p_table_name => 'ben_enrt_prem'
4482: ,p_efctable_name => 'ben_enrt_prem_efc'
4483: ,p_tabwhere_clause => ' val is not null '
4484: --

Line 5652: ben_efc_functions.maintain_chunks

5648: -- Check for end of chunk and commit if necessary
5649: --
5650: l_pk1 := l_efc_row.enrt_rt_id;
5651: --
5652: ben_efc_functions.maintain_chunks
5653: (p_row_count => l_chunkrow_count
5654: ,p_pk1 => l_pk1
5655: ,p_chunk_size => p_chunk
5656: ,p_efc_worker_id => p_efc_worker_id

Line 5778: ben_efc_functions.conv_check

5774: */
5775: --
5776: -- Check that all rows have been converted or excluded
5777: --
5778: ben_efc_functions.conv_check
5779: (p_table_name => 'ben_enrt_rt'
5780: ,p_efctable_name => 'ben_enrt_rt_efc'
5781: ,p_tabwhere_clause => ' (cmcd_mn_elcn_val is not null '
5782: ||' or cmcd_mn_elcn_val is not null '