APPS.BEN_EXT_ANSI dependencies on BEN_EXTRACT

Line 184: if ben_extract.g_per_lvl = 'Y' THEN

180: ben_ext_person.g_first_name; --this is the reference first name
181: ben_ext_person.g_part_last_name :=
182: ben_ext_person.g_last_name; --this is the reference last name
183: --
184: if ben_extract.g_per_lvl = 'Y' THEN
185: --
186: -- Process Person Level Records
187: --
188: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,

Line 204: IF ben_ext_person.g_part_type = 'P' AND ben_extract.g_enrt_lvl = 'Y' then

200: end if;
201: --
202: -- Process Enrollment Level Records
203: --
204: IF ben_ext_person.g_part_type = 'P' AND ben_extract.g_enrt_lvl = 'Y' then
205: --
206: -- create enrollment extract rows
207: -- =========================================
208: ben_ext_enrt.main(

Line 224: if ben_extract.g_elig_lvl = 'Y' then

220: end if; -- l_include = 'Y'
221: --
222: -- create eligibility extract rows
223: -- =========================================
224: if ben_extract.g_elig_lvl = 'Y' then
225: --
226: ben_ext_elig.main(
227: p_person_id => p_person_id,
228: -- p_per_in_ler_id => ben_ext_person.g_per_in_ler_id,

Line 312: if ben_extract.g_per_lvl = 'Y' THEN

308:
309:
310: close c_get_contact_info;
311: --
312: if ben_extract.g_per_lvl = 'Y' THEN
313: --
314: -- Process Person Level Records
315: --
316: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,

Line 332: if ben_ext_person.g_part_type = 'D' and ben_extract.g_enrt_lvl = 'Y' then

328: end if;
329: --
330: -- Process Enrollment Level Records
331: --
332: if ben_ext_person.g_part_type = 'D' and ben_extract.g_enrt_lvl = 'Y' then
333: --
334: ben_ext_enrt_spcl.main(
335: p_dpnt_person_id => p_person_id,
336: p_prtt_person_id => i.person_id,

Line 354: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP

350: end loop; -- i
351:
352:
353: -- validate the mandatory for low level in sequenc
354: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
355: --
356: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);

Line 356: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN

352:
353: -- validate the mandatory for low level in sequenc
354: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
355: --
356: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
359: l_rollback := TRUE; -- raise required_error;
360: end if ;

Line 357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||

353: -- validate the mandatory for low level in sequenc
354: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
355: --
356: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
359: l_rollback := TRUE; -- raise required_error;
360: end if ;
361:

Line 358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);

354: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
355: --
356: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
357: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
359: l_rollback := TRUE; -- raise required_error;
360: end if ;
361:
362: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then

Line 362: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then

358: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
359: l_rollback := TRUE; -- raise required_error;
360: end if ;
361:
362: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
363: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := false ;
364: end if ;
365: END LOOP;
366: --

Line 363: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := false ;

359: l_rollback := TRUE; -- raise required_error;
360: end if ;
361:
362: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
363: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := false ;
364: end if ;
365: END LOOP;
366: --
367: