eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on BEN_EXTRACT

Line 680: if ben_extract.g_bg_csr = 'Y' then

676: --
677: close c_person_info;
678:
679:
680: if ben_extract.g_bg_csr = 'Y' then
681: open bus_c(l_business_group_id);
682: fetch bus_c into l_business_group_name;
683: close bus_c;
684: end if ;

Line 689: ben_extract.g_business_group_name := l_business_group_name ;

685:
686:
687: if g_ext_global_flag = 'Y' then
688: ben_ext_person.g_business_group_id := l_business_group_id ;
689: ben_extract.g_business_group_name := l_business_group_name ;
690: end if ;
691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;
692:
693: ---initalize the assignment_id as soon the person information avaialble

Line 691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;

687: if g_ext_global_flag = 'Y' then
688: ben_ext_person.g_business_group_id := l_business_group_id ;
689: ben_extract.g_business_group_name := l_business_group_name ;
690: end if ;
691: hr_utility.set_location('Global BG ' || ben_ext_person.g_business_group_id|| ' / ' ||ben_extract.g_proc_business_group_id,99) ;
692:
693: ---initalize the assignment_id as soon the person information avaialble
694: init_assignment_id(p_person_id =>p_person_id ,
695: p_effective_date =>p_effective_date );

Line 2369: IF ben_extract.g_bb4_csr = 'Y' THEN

2365: end if;
2366: --
2367: -- Vacation
2368: --
2369: IF ben_extract.g_bb4_csr = 'Y' THEN
2370: open c_bnfts_bal('VAC');
2371: fetch c_bnfts_bal into
2372: g_benefit_bal_vacation;
2373: close c_bnfts_bal;

Line 2378: IF ben_extract.g_bb3_csr = 'Y' THEN

2374: END IF;
2375: --
2376: -- Sick Leave
2377: --
2378: IF ben_extract.g_bb3_csr = 'Y' THEN
2379: open c_bnfts_bal('SCK');
2380: fetch c_bnfts_bal into
2381: g_benefit_bal_sickleave;
2382: close c_bnfts_bal;

Line 2387: IF ben_extract.g_bb2_csr = 'Y' THEN

2383: END IF;
2384: --
2385: -- Pension
2386: --
2387: IF ben_extract.g_bb2_csr = 'Y' THEN
2388: open c_bnfts_bal('PENBEN');
2389: fetch c_bnfts_bal into
2390: g_benefit_bal_pension;
2391: close c_bnfts_bal;

Line 2396: IF ben_extract.g_bb1_csr = 'Y' THEN

2392: END IF;
2393: --
2394: -- Defined Contribution
2395: --
2396: IF ben_extract.g_bb1_csr = 'Y' THEN
2397: open c_bnfts_bal('DCBEN');
2398: fetch c_bnfts_bal into
2399: g_benefit_bal_dfncntrbn;
2400: close c_bnfts_bal;

Line 2405: IF ben_extract.g_bb5_csr = 'Y' THEN

2401: END IF;
2402: --
2403: -- Wellness
2404: --
2405: IF ben_extract.g_bb5_csr = 'Y' THEN
2406: open c_bnfts_bal('WLNS');
2407: fetch c_bnfts_bal into
2408: g_benefit_bal_wellness;
2409: close c_bnfts_bal;

Line 2443: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);

2439: get_person_info (p_person_id => p_person_id,
2440: p_effective_date => g_person_ext_dt);
2441: --
2442: if g_debug then
2443: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);
2444: end if;
2445: if ben_extract.g_asg_csr = 'Y' then
2446: get_assignment_info (p_person_id => p_person_id,
2447: p_assignment_id => g_assignment_id,

Line 2445: if ben_extract.g_asg_csr = 'Y' then

2441: --
2442: if g_debug then
2443: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);
2444: end if;
2445: if ben_extract.g_asg_csr = 'Y' then
2446: get_assignment_info (p_person_id => p_person_id,
2447: p_assignment_id => g_assignment_id,
2448: p_effective_date => g_person_ext_dt,
2449: p_ext_rslt_id => p_ext_rslt_id );

Line 2455: if ben_extract.g_addr_csr = 'Y' or ben_extract.g_asa_csr = 'Y' or ben_extract.g_cma_csr = 'Y' then

2451: --
2452: -- get the primary address for communication too
2453: -- priamry address is used if the cmmunication not avaialable
2454:
2455: if ben_extract.g_addr_csr = 'Y' or ben_extract.g_asa_csr = 'Y' or ben_extract.g_cma_csr = 'Y' then
2456: get_primary_address_info (p_person_id => p_person_id,
2457: p_effective_date => g_person_ext_dt);
2458: end if;
2459: --

Line 2460: if ben_extract.g_ma_csr = 'Y' then

2456: get_primary_address_info (p_person_id => p_person_id,
2457: p_effective_date => g_person_ext_dt);
2458: end if;
2459: --
2460: if ben_extract.g_ma_csr = 'Y' then
2461: get_mailing_address_info (p_person_id => p_person_id,
2462: p_effective_date => g_person_ext_dt);
2463: end if;
2464: ---

Line 2465: if ben_extract.g_cma_csr = 'Y' then

2461: get_mailing_address_info (p_person_id => p_person_id,
2462: p_effective_date => g_person_ext_dt);
2463: end if;
2464: ---
2465: if ben_extract.g_cma_csr = 'Y' then
2466: get_comm_address_info(p_person_id => p_person_id,
2467: p_address_id => g_cm_address_id,
2468: p_effective_date => g_person_ext_dt);
2469: end if;

Line 2472: if ben_extract.g_phn_csr = 'Y' then

2468: p_effective_date => g_person_ext_dt);
2469: end if;
2470:
2471: --
2472: if ben_extract.g_phn_csr = 'Y' then
2473: get_phone_info (p_person_id => p_person_id,
2474: p_effective_date => g_person_ext_dt);
2475: end if;
2476: --

Line 2477: if ben_extract.g_pos_csr = 'Y' then

2473: get_phone_info (p_person_id => p_person_id,
2474: p_effective_date => g_person_ext_dt);
2475: end if;
2476: --
2477: if ben_extract.g_pos_csr = 'Y' then
2478: get_period_of_svc_info (p_person_id => p_person_id,
2479: p_effective_date => g_person_ext_dt);
2480: end if;
2481: --

Line 2482: if ben_extract.g_asa_csr = 'Y' then

2478: get_period_of_svc_info (p_person_id => p_person_id,
2479: p_effective_date => g_person_ext_dt);
2480: end if;
2481: --
2482: if ben_extract.g_asa_csr = 'Y' then
2483: get_svc_area_info (p_postal_code => g_prim_postal_code,
2484: p_effective_date => g_person_ext_dt);
2485: end if;
2486: --

Line 2487: if ben_extract.g_ler_csr = 'Y' then

2483: get_svc_area_info (p_postal_code => g_prim_postal_code,
2484: p_effective_date => g_person_ext_dt);
2485: end if;
2486: --
2487: if ben_extract.g_ler_csr = 'Y' then
2488: get_started_ler_info (p_person_id => p_person_id,
2489: p_effective_date => g_person_ext_dt);
2490: end if;
2491: --

Line 2492: if ben_extract.g_bgr_csr = 'Y' then

2488: get_started_ler_info (p_person_id => p_person_id,
2489: p_effective_date => g_person_ext_dt);
2490: end if;
2491: --
2492: if ben_extract.g_bgr_csr = 'Y' then
2493: get_bnfts_group_info (p_benfts_grp_id => g_benefit_group_id);
2494: end if;
2495: --
2496: if ben_extract.g_abs_csr = 'Y' then

Line 2496: if ben_extract.g_abs_csr = 'Y' then

2492: if ben_extract.g_bgr_csr = 'Y' then
2493: get_bnfts_group_info (p_benfts_grp_id => g_benefit_group_id);
2494: end if;
2495: --
2496: if ben_extract.g_abs_csr = 'Y' then
2497: get_absence_info (p_person_id => p_person_id,
2498: p_effective_date => g_person_ext_dt);
2499: end if;
2500: --

Line 2501: if ben_extract.g_cbra_csr = 'Y' then

2497: get_absence_info (p_person_id => p_person_id,
2498: p_effective_date => g_person_ext_dt);
2499: end if;
2500: --
2501: if ben_extract.g_cbra_csr = 'Y' then
2502: get_cobra_info (p_person_id => p_person_id,
2503: p_effective_date => g_person_ext_dt);
2504: end if;
2505: --

Line 2506: if ben_extract.g_bb1_csr = 'Y' or ben_extract.g_bb2_csr = 'Y' or ben_extract.g_bb3_csr = 'Y'

2502: get_cobra_info (p_person_id => p_person_id,
2503: p_effective_date => g_person_ext_dt);
2504: end if;
2505: --
2506: if ben_extract.g_bb1_csr = 'Y' or ben_extract.g_bb2_csr = 'Y' or ben_extract.g_bb3_csr = 'Y'
2507: or ben_extract.g_bb4_csr = 'Y' or ben_extract.g_bb5_csr = 'Y' then
2508: get_bnfts_bal_info (p_person_id => p_person_id,
2509: p_effective_date => g_person_ext_dt);
2510: end if;

Line 2507: or ben_extract.g_bb4_csr = 'Y' or ben_extract.g_bb5_csr = 'Y' then

2503: p_effective_date => g_person_ext_dt);
2504: end if;
2505: --
2506: if ben_extract.g_bb1_csr = 'Y' or ben_extract.g_bb2_csr = 'Y' or ben_extract.g_bb3_csr = 'Y'
2507: or ben_extract.g_bb4_csr = 'Y' or ben_extract.g_bb5_csr = 'Y' then
2508: get_bnfts_bal_info (p_person_id => p_person_id,
2509: p_effective_date => g_person_ext_dt);
2510: end if;
2511: ---

Line 2513: if ben_extract.g_sup_csr = 'Y' then

2509: p_effective_date => g_person_ext_dt);
2510: end if;
2511: ---
2512:
2513: if ben_extract.g_sup_csr = 'Y' then
2514: -- supervisor infor expect supervisor id so if it not intialised
2515: -- intialise again
2516: if nvl(ben_extract.g_asg_csr,'N') <> 'Y' then
2517: get_assignment_info (p_person_id => p_person_id,

Line 2516: if nvl(ben_extract.g_asg_csr,'N') <> 'Y' then

2512:
2513: if ben_extract.g_sup_csr = 'Y' then
2514: -- supervisor infor expect supervisor id so if it not intialised
2515: -- intialise again
2516: if nvl(ben_extract.g_asg_csr,'N') <> 'Y' then
2517: get_assignment_info (p_person_id => p_person_id,
2518: p_assignment_id => g_assignment_id,
2519: p_effective_date => g_person_ext_dt,
2520: p_ext_rslt_id => p_ext_rslt_id );

Line 2527: if ben_extract.g_bsl_csr = 'Y' then

2523: get_supervisor_info (p_supervisor_id => g_asg_supervisor_id ,
2524: p_effective_date => g_person_ext_dt);
2525: end if;
2526: -- basic salary
2527: if ben_extract.g_bsl_csr = 'Y' then
2528: get_base_annual_salary_info(p_person_id => p_person_id,
2529: p_effective_date => g_person_ext_dt);
2530: end if;
2531: if ben_extract.g_shl_csr = 'Y' then

Line 2531: if ben_extract.g_shl_csr = 'Y' then

2527: if ben_extract.g_bsl_csr = 'Y' then
2528: get_base_annual_salary_info(p_person_id => p_person_id,
2529: p_effective_date => g_person_ext_dt);
2530: end if;
2531: if ben_extract.g_shl_csr = 'Y' then
2532: get_School_info(p_person_id => p_person_id,
2533: p_effective_date => g_person_ext_dt);
2534: end if;
2535:

Line 2537: if ben_extract.g_flxcr_csr = 'Y' then

2533: p_effective_date => g_person_ext_dt);
2534: end if;
2535:
2536: --person level flex provided and used
2537: if ben_extract.g_flxcr_csr = 'Y' then
2538: get_person_flex_credit(p_person_id => p_person_id,
2539: p_effective_date => g_person_ext_dt);
2540: end if ;
2541:

Line 3193: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing

3189: end if;
3190: --
3191: if l_include = 'Y' then
3192: --
3193: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
3194:
3195: process_ext_levels(
3196: p_person_id => p_person_id,
3197: p_ext_rslt_id => p_ext_rslt_id,

Line 3228: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in

3224: --
3225: g_trans_num := 1;
3226: --
3227: ben_ext_util.get_chg_dates
3228: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
3229: p_effective_date => g_effective_date, --in
3230: p_chg_actl_strt_dt => l_chg_actl_strt_dt, --out
3231: p_chg_actl_end_dt => l_chg_actl_end_dt, --out
3232: p_chg_eff_strt_dt => l_chg_eff_strt_dt, --out

Line 3431: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing

3427: END IF;
3428: --
3429: g_rcd_seq := 1; -- what's this do? th.
3430: --
3431: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
3432: --
3433: process_ext_levels(
3434: p_person_id => p_person_id,
3435: p_ext_rslt_id => p_ext_rslt_id,

Line 3965: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing

3961: hr_utility.set_location(' Change Event Code ' || g_chg_evt_cd , 99 );
3962: end if;
3963: g_rcd_seq := 1;
3964: --
3965: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
3966: --
3967: process_ext_levels(
3968: p_person_id => p_person_id,
3969: p_ext_rslt_id => p_ext_rslt_id,

Line 4013: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in

4009: --
4010: g_trans_num := 1;
4011: --
4012: ben_ext_util.get_cm_dates
4013: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
4014: p_effective_date => g_effective_date, --in
4015: p_to_be_sent_strt_dt => l_to_be_sent_strt_dt, --out
4016: p_to_be_sent_end_dt => l_to_be_sent_end_dt); --out
4017:

Line 4177: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing

4173: IF l_include = 'Y' THEN
4174: --
4175: g_rcd_seq := 1;
4176: --
4177: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
4178: --
4179: process_ext_levels(
4180: p_person_id => p_person_id,
4181: p_ext_rslt_id => p_ext_rslt_id,

Line 4537: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing

4533:
4534: ----
4535: g_rcd_seq := 1;
4536: --
4537: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
4538: --
4539: process_ext_levels(
4540: p_person_id => p_person_id,
4541: p_ext_rslt_id => p_ext_rslt_id,

Line 4589: p_request_id => ben_extract.g_request_id,

4585: write_error(
4586: p_err_num => g_err_num,
4587: p_err_name => l_err_message,
4588: p_typ_cd => 'E',
4589: p_request_id => ben_extract.g_request_id,
4590: p_ext_rslt_id => p_ext_rslt_id
4591: );
4592:
4593: When detail_restart_error then

Line 4604: p_request_id => ben_extract.g_request_id,

4600: write_error(
4601: p_err_num => g_err_num,
4602: p_err_name => l_err_message,
4603: p_typ_cd => 'E',
4604: p_request_id => ben_extract.g_request_id,
4605: p_ext_rslt_id => p_ext_rslt_id
4606: );
4607: Raise ;
4608:

Line 4625: p_request_id => ben_extract.g_request_id,

4621: write_error(
4622: p_err_num => g_err_num,
4623: p_err_name => l_err_message,
4624: p_typ_cd => 'E',
4625: p_request_id => ben_extract.g_request_id,
4626: p_ext_rslt_id => p_ext_rslt_id
4627: );
4628: end if ;
4629:

Line 4708: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );

4704: --
4705: l_rollback:=FALSE;
4706:
4707: if g_debug then
4708: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );
4709: end if;
4710: --
4711: IF ben_extract.g_per_lvl = 'Y' THEN
4712: --

Line 4711: IF ben_extract.g_per_lvl = 'Y' THEN

4707: if g_debug then
4708: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );
4709: end if;
4710: --
4711: IF ben_extract.g_per_lvl = 'Y' THEN
4712: --
4713: -- Process Personal Level Detail Records
4714: --
4715: --

Line 4742: IF (ben_extract.g_enrt_lvl = 'Y' OR ben_extract.g_dpnt_lvl = 'Y' OR ben_extract.g_bnf_lvl = 'Y' OR

4738: --IF nvl(g_chg_evt_cd, '*') <> 'TBBC' then
4739: --
4740: -- extract enrollment levels
4741: --
4742: IF (ben_extract.g_enrt_lvl = 'Y' OR ben_extract.g_dpnt_lvl = 'Y' OR ben_extract.g_bnf_lvl = 'Y' OR
4743: ben_extract.g_actn_lvl = 'Y' or ben_extract.g_prem_lvl = 'Y' ) THEN
4744: --
4745: if g_debug then
4746: hr_utility.set_location(' ben_ext_enrt.main',99 );

Line 4743: ben_extract.g_actn_lvl = 'Y' or ben_extract.g_prem_lvl = 'Y' ) THEN

4739: --
4740: -- extract enrollment levels
4741: --
4742: IF (ben_extract.g_enrt_lvl = 'Y' OR ben_extract.g_dpnt_lvl = 'Y' OR ben_extract.g_bnf_lvl = 'Y' OR
4743: ben_extract.g_actn_lvl = 'Y' or ben_extract.g_prem_lvl = 'Y' ) THEN
4744: --
4745: if g_debug then
4746: hr_utility.set_location(' ben_ext_enrt.main',99 );
4747: end if;

Line 4761: --ELSIF nvl(g_chg_evt_cd, '*') = 'TBBC' and ben_extract.g_enrt_lvl = 'Y' then

4757: END IF;
4758: --
4759: --
4760: --RCHASE
4761: --ELSIF nvl(g_chg_evt_cd, '*') = 'TBBC' and ben_extract.g_enrt_lvl = 'Y' then
4762: --
4763: -- open purged_rslt_c(g_chg_pl_id);
4764: --
4765: -- fetch purged_rslt_c into

Line 4786: if ben_extract.g_elig_lvl = 'Y' or ben_extract.g_eligdpnt_lvl = 'Y' then

4782: --END IF; -- part type
4783: --
4784: -- create eligibility extract rows
4785: -- =========================================
4786: if ben_extract.g_elig_lvl = 'Y' or ben_extract.g_eligdpnt_lvl = 'Y' then
4787: --
4788: ben_ext_elig.main(
4789: p_person_id => p_person_id,
4790: p_ext_rslt_id => p_ext_rslt_id,

Line 4804: if ben_extract.g_flex_lvl = 'Y' then

4800: end if;
4801: --
4802: -- create flex credit extract rows
4803: -- =========================================
4804: if ben_extract.g_flex_lvl = 'Y' then
4805: --
4806: ben_ext_flcr.main(
4807: p_person_id => p_person_id,
4808: p_ext_rslt_id => p_ext_rslt_id,

Line 4822: if ben_extract.g_payroll_lvl = 'Y' then

4818: end if;
4819: --
4820: -- create payroll extract rows
4821: -- ================================
4822: if ben_extract.g_payroll_lvl = 'Y' then
4823: --
4824: ben_ext_payroll.main(
4825: p_person_id => p_person_id,
4826: p_ext_rslt_id => p_ext_rslt_id,

Line 4839: if ben_extract.g_runrslt_lvl = 'Y' then

4835: end if;
4836: --
4837: -- create run result extract rows
4838: -- ================================
4839: if ben_extract.g_runrslt_lvl = 'Y' then
4840: --
4841: ben_ext_runrslt.main(
4842: p_person_id => p_person_id,
4843: p_ext_rslt_id => p_ext_rslt_id,

Line 4856: if ben_extract.g_contact_lvl = 'Y' then

4852: end if;
4853: --
4854: -- create contact extract rows
4855: -- ================================
4856: if ben_extract.g_contact_lvl = 'Y' then
4857: --
4858: ben_ext_contact.main(
4859: p_person_id => p_person_id,
4860: p_ext_rslt_id => p_ext_rslt_id,

Line 4874: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );

4870:
4871: --- cwb
4872: if p_data_typ_cd = 'CW' THEN
4873:
4874: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );
4875:
4876: if ben_extract.g_cwb_bdgt_lvl = 'Y' then
4877: ben_ext_cwb.extract_person_groups
4878: ( p_person_id => p_person_id,

Line 4876: if ben_extract.g_cwb_bdgt_lvl = 'Y' then

4872: if p_data_typ_cd = 'CW' THEN
4873:
4874: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );
4875:
4876: if ben_extract.g_cwb_bdgt_lvl = 'Y' then
4877: ben_ext_cwb.extract_person_groups
4878: ( p_person_id => p_person_id,
4879: p_per_in_ler_id => g_cwb_per_group_per_in_ler_id,
4880: p_ext_rslt_id => p_ext_rslt_id,

Line 4888: if ben_extract.g_cwb_awrd_lvl = 'Y' then

4884: p_business_group_id => p_business_group_id,
4885: p_effective_date => g_person_ext_dt) ;
4886: end if ;
4887:
4888: if ben_extract.g_cwb_awrd_lvl = 'Y' then
4889: ben_ext_cwb.extract_person_rates
4890: ( p_person_id => p_person_id,
4891: p_per_in_ler_id => g_cwb_per_group_per_in_ler_id,
4892: p_ext_rslt_id => p_ext_rslt_id,

Line 4905: if ben_extract.g_otl_summ_lvl = 'Y' then

4901:
4902: --
4903:
4904:
4905: if ben_extract.g_otl_summ_lvl = 'Y' then
4906:
4907: hxc_ext_timecard.process_summary (
4908: p_person_id => p_person_id,
4909: p_ext_rslt_id => p_ext_rslt_id,

Line 4921: FOR i in ben_extract.gtt_rcd_rqd_vals.first .. ben_extract.gtt_rcd_rqd_vals.last LOOP

4917:
4918: --
4919: /* this validation is done on low level , this is changed to do in record level
4920: this validation moved to benxfrmt.pkb
4921: FOR i in ben_extract.gtt_rcd_rqd_vals.first .. ben_extract.gtt_rcd_rqd_vals.last LOOP
4922: --
4923: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found
4924: THEN
4925: l_rollback := TRUE; -- raise required_error;

Line 4923: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found

4919: /* this validation is done on low level , this is changed to do in record level
4920: this validation moved to benxfrmt.pkb
4921: FOR i in ben_extract.gtt_rcd_rqd_vals.first .. ben_extract.gtt_rcd_rqd_vals.last LOOP
4922: --
4923: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found
4924: THEN
4925: l_rollback := TRUE; -- raise required_error;
4926: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'
4927: THEN

Line 4926: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'

4922: --
4923: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found
4924: THEN
4925: l_rollback := TRUE; -- raise required_error;
4926: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'
4927: THEN
4928: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := FALSE; -- reset the value
4929: END IF;
4930: --

Line 4928: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := FALSE; -- reset the value

4924: THEN
4925: l_rollback := TRUE; -- raise required_error;
4926: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'
4927: THEN
4928: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := FALSE; -- reset the value
4929: END IF;
4930: --
4931: END LOOP;
4932: */

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

4932: */
4933:
4934:
4935: -- validate the mandatory for low level in sequenc
4936: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4937: --
4938: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4939: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4940: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);

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

4934:
4935: -- validate the mandatory for low level in sequenc
4936: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4937: --
4938: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4939: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4940: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4941: l_rollback := TRUE; -- raise required_error;
4942: end if ;

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

4935: -- validate the mandatory for low level in sequenc
4936: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4937: --
4938: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4939: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4940: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4941: l_rollback := TRUE; -- raise required_error;
4942: end if ;
4943: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then

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

4936: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4937: --
4938: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4939: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4940: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4941: l_rollback := TRUE; -- raise required_error;
4942: end if ;
4943: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
4944: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value

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

4939: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4940: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4941: l_rollback := TRUE; -- raise required_error;
4942: end if ;
4943: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
4944: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value
4945: end if ;
4946: END LOOP;
4947: --

Line 4944: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value

4940: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4941: l_rollback := TRUE; -- raise required_error;
4942: end if ;
4943: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
4944: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value
4945: end if ;
4946: END LOOP;
4947: --
4948: IF l_rollback