APPS.BEN_CWB_EMP_ELIG dependencies on HR_API

Line 128: l_ws_start_date DATE := hr_api.g_date;

124: l_inelig_rsn_cd VARCHAR2(4) := NULL;
125: l_object_version_number NUMBER;
126: l_ws_val NUMBER;
127: l_elig_flag VARCHAR2(1);
128: l_ws_start_date DATE := hr_api.g_date;
129: l_proc VARCHAR2(80) := g_package||'.updateEligibility';
130:
131: CURSOR c_person_rate(v_person_rate_id IN VARCHAR2) IS
132: SELECT object_version_number

Line 150: l_ws_start_date := hr_api.g_date;

146: l_inelig_rsn_cd := 'MGR';
147: l_ws_start_date := NULL;
148: ELSE
149: l_inelig_rsn_cd := NULL;
150: l_ws_start_date := hr_api.g_date;
151: END IF;
152:
153: IF p_pl_elig_change_status = 'PY' THEN
154: IF p_pl_elig_flag = 'Y' THEN

Line 182: l_ws_start_date := hr_api.g_date;

178: l_inelig_rsn_cd := 'MGR';
179: l_ws_start_date := NULL;
180: ELSE
181: l_inelig_rsn_cd := NULL;
182: l_ws_start_date := hr_api.g_date;
183: END IF;
184: ben_cwb_person_rates_api.update_person_rate
185: (
186: p_group_per_in_ler_id => p_group_per_in_ler_id

Line 224: l_ws_start_date := hr_api.g_date;

220: l_inelig_rsn_cd := 'MGR';
221: l_ws_start_date := NULL;
222: ELSE
223: l_inelig_rsn_cd := NULL;
224: l_ws_start_date := hr_api.g_date;
225: END IF;
226:
227: IF p_pl_elig_change_status = 'PY' THEN
228: IF p_pl_elig_flag = 'Y' THEN

Line 256: l_ws_start_date := hr_api.g_date;

252: l_inelig_rsn_cd := 'MGR';
253: l_ws_start_date := NULL;
254: ELSE
255: l_inelig_rsn_cd := NULL;
256: l_ws_start_date := hr_api.g_date;
257: END IF;
258: ben_cwb_person_rates_api.update_person_rate
259: (
260: p_group_per_in_ler_id => p_group_per_in_ler_id

Line 298: l_ws_start_date := hr_api.g_date;

294: l_inelig_rsn_cd := 'MGR';
295: l_ws_start_date := NULL;
296: ELSE
297: l_inelig_rsn_cd := NULL;
298: l_ws_start_date := hr_api.g_date;
299: END IF;
300:
301: IF p_pl_elig_change_status = 'PY' THEN
302: IF p_pl_elig_flag = 'Y' THEN

Line 330: l_ws_start_date := hr_api.g_date;

326: l_inelig_rsn_cd := 'MGR';
327: l_ws_start_date := NULL;
328: ELSE
329: l_inelig_rsn_cd := NULL;
330: l_ws_start_date := hr_api.g_date;
331: END IF;
332: ben_cwb_person_rates_api.update_person_rate
333: (
334: p_group_per_in_ler_id => p_group_per_in_ler_id

Line 372: l_ws_start_date := hr_api.g_date;

368: l_inelig_rsn_cd := 'MGR';
369: l_ws_start_date := NULL;
370: ELSE
371: l_inelig_rsn_cd := NULL;
372: l_ws_start_date := hr_api.g_date;
373: END IF;
374:
375: IF p_pl_elig_change_status = 'PY' THEN
376: IF p_pl_elig_flag = 'Y' THEN

Line 404: l_ws_start_date := hr_api.g_date;

400: l_inelig_rsn_cd := 'MGR';
401: l_ws_start_date := NULL;
402: ELSE
403: l_inelig_rsn_cd := NULL;
404: l_ws_start_date := hr_api.g_date;
405: END IF;
406: ben_cwb_person_rates_api.update_person_rate
407: (
408: p_group_per_in_ler_id => p_group_per_in_ler_id

Line 451: l_ws_start_date := hr_api.g_date;

447: l_inelig_rsn_cd := 'MGR';
448: l_ws_start_date := NULL;
449: ELSE
450: l_inelig_rsn_cd := NULL;
451: l_ws_start_date := hr_api.g_date;
452: -- Need to call the routine which deletes all assignment changes
453: -- as the person becomes ineligible.
454: END IF;
455: