DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_EPE_SHD

Line 1339: ben_epe_shd.g_api_dml := true; -- Set the api dml status

1335: -- Set the object version number for the insert
1336: --
1337: l_object_version_number := 1;
1338: --
1339: ben_epe_shd.g_api_dml := true; -- Set the api dml status
1340: --
1341: -- CWB Changes Start
1342: --
1343: l_elig_flag := p_elig_flag;

Line 1572: ben_epe_shd.g_api_dml := false; -- Unset the api dml status

1568: if g_debug then
1569: hr_utility.set_location('Dn Insert: '||l_proc, 5);
1570: end if;
1571: --
1572: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
1573: --
1574: -- When in validation only mode raise the Validate_Enabled exception
1575: --
1576: if p_validate then

Line 2350: l_rec ben_epe_shd.g_rec_type;

2346: --
2347: -- Declare cursors and local variables
2348: --
2349: l_proc varchar2(72) ;
2350: l_rec ben_epe_shd.g_rec_type;
2351: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
2352: l_elig_flag varchar2(30);
2353: l_inelig_rsn_cd varchar2(30);
2354: --

Line 2388: ben_epe_shd.convert_args

2384: --
2385: -- CWB Changes : End
2386: --
2387: l_rec :=
2388: ben_epe_shd.convert_args
2389: (
2390: p_elig_per_elctbl_chc_id,
2391: -- p_enrt_typ_cycl_cd,
2392: p_enrt_cvg_strt_dt_cd,

Line 2496: ben_epe_shd.lck

2492:
2493: --
2494: -- We must lock the row which we need to update.
2495: --
2496: ben_epe_shd.lck
2497: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
2498: ,p_object_version_number => p_object_version_number
2499: );
2500: --

Line 2507: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))

2503: --CWB
2504: -- Check only if the new manager is not null or defaulted.
2505: --
2506: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and
2507: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))
2508: then
2509: chk_valid_mgr(p_elig_per_elctbl_chc_id,p_ws_mgr_id,p_effective_date);
2510: end if;
2511: --CWB

Line 2520: ben_epe_shd.g_api_dml := true; -- Set the api dml status

2516: --
2517: if g_debug then
2518: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
2519: end if;
2520: ben_epe_shd.g_api_dml := true; -- Set the api dml status
2521: --
2522: -- Update the ben_elig_per_elctbl_chc Row
2523: --
2524:

Line 2629: ben_epe_shd.g_api_dml := false; -- Unset the api dml status

2625: program_update_date = l_rec.program_update_date,
2626: object_version_number = l_object_version_number
2627: where elig_per_elctbl_chc_id = l_rec.elig_per_elctbl_chc_id;
2628: --
2629: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
2630: --
2631: if g_debug then
2632: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);
2633: end if;

Line 2957: ben_epe_shd.lck

2953: l_proc := g_package||'lck';
2954: hr_utility.set_location('Entering:'|| l_proc, 10);
2955: end if;
2956: --
2957: ben_epe_shd.lck
2958: (
2959: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
2960: ,p_object_version_number => p_object_version_number
2961: );