DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on BEN_EPE_SHD

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

1330: -- Set the object version number for the insert
1331: --
1332: l_object_version_number := 1;
1333: --
1334: ben_epe_shd.g_api_dml := true; -- Set the api dml status
1335: --
1336: -- CWB Changes Start
1337: --
1338: l_elig_flag := p_elig_flag;

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

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

Line 2345: l_rec ben_epe_shd.g_rec_type;

2341: --
2342: -- Declare cursors and local variables
2343: --
2344: l_proc varchar2(72) ;
2345: l_rec ben_epe_shd.g_rec_type;
2346: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
2347: l_elig_flag varchar2(30);
2348: l_inelig_rsn_cd varchar2(30);
2349: --

Line 2383: ben_epe_shd.convert_args

2379: --
2380: -- CWB Changes : End
2381: --
2382: l_rec :=
2383: ben_epe_shd.convert_args
2384: (
2385: p_elig_per_elctbl_chc_id,
2386: -- p_enrt_typ_cycl_cd,
2387: p_enrt_cvg_strt_dt_cd,

Line 2491: ben_epe_shd.lck

2487:
2488: --
2489: -- We must lock the row which we need to update.
2490: --
2491: ben_epe_shd.lck
2492: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
2493: ,p_object_version_number => p_object_version_number
2494: );
2495: --

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

2498: --CWB
2499: -- Check only if the new manager is not null or defaulted.
2500: --
2501: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and
2502: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))
2503: then
2504: chk_valid_mgr(p_elig_per_elctbl_chc_id,p_ws_mgr_id,p_effective_date);
2505: end if;
2506: --CWB

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

2511: --
2512: if g_debug then
2513: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
2514: end if;
2515: ben_epe_shd.g_api_dml := true; -- Set the api dml status
2516: --
2517: -- Update the ben_elig_per_elctbl_chc Row
2518: --
2519:

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

2620: program_update_date = l_rec.program_update_date,
2621: object_version_number = l_object_version_number
2622: where elig_per_elctbl_chc_id = l_rec.elig_per_elctbl_chc_id;
2623: --
2624: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
2625: --
2626: if g_debug then
2627: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);
2628: end if;

Line 2952: ben_epe_shd.lck

2948: l_proc := g_package||'lck';
2949: hr_utility.set_location('Entering:'|| l_proc, 10);
2950: end if;
2951: --
2952: ben_epe_shd.lck
2953: (
2954: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
2955: ,p_object_version_number => p_object_version_number
2956: );