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 2403: IF ben_extract.g_bb4_csr = 'Y' THEN

2399: end if;
2400: --
2401: -- Vacation
2402: --
2403: IF ben_extract.g_bb4_csr = 'Y' THEN
2404: open c_bnfts_bal('VAC');
2405: fetch c_bnfts_bal into
2406: g_benefit_bal_vacation;
2407: close c_bnfts_bal;

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

2408: END IF;
2409: --
2410: -- Sick Leave
2411: --
2412: IF ben_extract.g_bb3_csr = 'Y' THEN
2413: open c_bnfts_bal('SCK');
2414: fetch c_bnfts_bal into
2415: g_benefit_bal_sickleave;
2416: close c_bnfts_bal;

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

2417: END IF;
2418: --
2419: -- Pension
2420: --
2421: IF ben_extract.g_bb2_csr = 'Y' THEN
2422: open c_bnfts_bal('PENBEN');
2423: fetch c_bnfts_bal into
2424: g_benefit_bal_pension;
2425: close c_bnfts_bal;

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

2426: END IF;
2427: --
2428: -- Defined Contribution
2429: --
2430: IF ben_extract.g_bb1_csr = 'Y' THEN
2431: open c_bnfts_bal('DCBEN');
2432: fetch c_bnfts_bal into
2433: g_benefit_bal_dfncntrbn;
2434: close c_bnfts_bal;

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

2435: END IF;
2436: --
2437: -- Wellness
2438: --
2439: IF ben_extract.g_bb5_csr = 'Y' THEN
2440: open c_bnfts_bal('WLNS');
2441: fetch c_bnfts_bal into
2442: g_benefit_bal_wellness;
2443: close c_bnfts_bal;

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

2473: get_person_info (p_person_id => p_person_id,
2474: p_effective_date => g_person_ext_dt);
2475: --
2476: if g_debug then
2477: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);
2478: end if;
2479: if ben_extract.g_asg_csr = 'Y' then
2480: get_assignment_info (p_person_id => p_person_id,
2481: p_assignment_id => g_assignment_id,

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

2475: --
2476: if g_debug then
2477: hr_utility.set_location('asg level ' || ben_extract.g_asg_csr,99);
2478: end if;
2479: if ben_extract.g_asg_csr = 'Y' then
2480: get_assignment_info (p_person_id => p_person_id,
2481: p_assignment_id => g_assignment_id,
2482: p_effective_date => g_person_ext_dt,
2483: p_ext_rslt_id => p_ext_rslt_id );

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

2485: --
2486: -- get the primary address for communication too
2487: -- priamry address is used if the cmmunication not avaialable
2488:
2489: if ben_extract.g_addr_csr = 'Y' or ben_extract.g_asa_csr = 'Y' or ben_extract.g_cma_csr = 'Y' then
2490: get_primary_address_info (p_person_id => p_person_id,
2491: p_effective_date => g_person_ext_dt);
2492: end if;
2493: --

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

2490: get_primary_address_info (p_person_id => p_person_id,
2491: p_effective_date => g_person_ext_dt);
2492: end if;
2493: --
2494: if ben_extract.g_ma_csr = 'Y' then
2495: get_mailing_address_info (p_person_id => p_person_id,
2496: p_effective_date => g_person_ext_dt);
2497: end if;
2498: ---

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

2495: get_mailing_address_info (p_person_id => p_person_id,
2496: p_effective_date => g_person_ext_dt);
2497: end if;
2498: ---
2499: if ben_extract.g_cma_csr = 'Y' then
2500: get_comm_address_info(p_person_id => p_person_id,
2501: p_address_id => g_cm_address_id,
2502: p_effective_date => g_person_ext_dt);
2503: end if;

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

2502: p_effective_date => g_person_ext_dt);
2503: end if;
2504:
2505: --
2506: if ben_extract.g_phn_csr = 'Y' then
2507: get_phone_info (p_person_id => p_person_id,
2508: p_effective_date => g_person_ext_dt);
2509: end if;
2510: --

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

2507: get_phone_info (p_person_id => p_person_id,
2508: p_effective_date => g_person_ext_dt);
2509: end if;
2510: --
2511: if ben_extract.g_pos_csr = 'Y' then
2512: get_period_of_svc_info (p_person_id => p_person_id,
2513: p_effective_date => g_person_ext_dt);
2514: end if;
2515: --

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

2512: get_period_of_svc_info (p_person_id => p_person_id,
2513: p_effective_date => g_person_ext_dt);
2514: end if;
2515: --
2516: if ben_extract.g_asa_csr = 'Y' then
2517: get_svc_area_info (p_postal_code => g_prim_postal_code,
2518: p_effective_date => g_person_ext_dt);
2519: end if;
2520: --

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

2517: get_svc_area_info (p_postal_code => g_prim_postal_code,
2518: p_effective_date => g_person_ext_dt);
2519: end if;
2520: --
2521: if ben_extract.g_ler_csr = 'Y' then
2522: get_started_ler_info (p_person_id => p_person_id,
2523: p_effective_date => g_person_ext_dt);
2524: end if;
2525: --

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

2522: get_started_ler_info (p_person_id => p_person_id,
2523: p_effective_date => g_person_ext_dt);
2524: end if;
2525: --
2526: if ben_extract.g_bgr_csr = 'Y' then
2527: get_bnfts_group_info (p_benfts_grp_id => g_benefit_group_id);
2528: end if;
2529: --
2530: if ben_extract.g_abs_csr = 'Y' then

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

2526: if ben_extract.g_bgr_csr = 'Y' then
2527: get_bnfts_group_info (p_benfts_grp_id => g_benefit_group_id);
2528: end if;
2529: --
2530: if ben_extract.g_abs_csr = 'Y' then
2531: get_absence_info (p_person_id => p_person_id,
2532: p_effective_date => g_person_ext_dt);
2533: end if;
2534: --

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

2531: get_absence_info (p_person_id => p_person_id,
2532: p_effective_date => g_person_ext_dt);
2533: end if;
2534: --
2535: if ben_extract.g_cbra_csr = 'Y' then
2536: get_cobra_info (p_person_id => p_person_id,
2537: p_effective_date => g_person_ext_dt);
2538: end if;
2539: --

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

2536: get_cobra_info (p_person_id => p_person_id,
2537: p_effective_date => g_person_ext_dt);
2538: end if;
2539: --
2540: if ben_extract.g_bb1_csr = 'Y' or ben_extract.g_bb2_csr = 'Y' or ben_extract.g_bb3_csr = 'Y'
2541: or ben_extract.g_bb4_csr = 'Y' or ben_extract.g_bb5_csr = 'Y' then
2542: get_bnfts_bal_info (p_person_id => p_person_id,
2543: p_effective_date => g_person_ext_dt);
2544: end if;

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

2537: p_effective_date => g_person_ext_dt);
2538: end if;
2539: --
2540: if ben_extract.g_bb1_csr = 'Y' or ben_extract.g_bb2_csr = 'Y' or ben_extract.g_bb3_csr = 'Y'
2541: or ben_extract.g_bb4_csr = 'Y' or ben_extract.g_bb5_csr = 'Y' then
2542: get_bnfts_bal_info (p_person_id => p_person_id,
2543: p_effective_date => g_person_ext_dt);
2544: end if;
2545: ---

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

2543: p_effective_date => g_person_ext_dt);
2544: end if;
2545: ---
2546:
2547: if ben_extract.g_sup_csr = 'Y' then
2548: -- supervisor infor expect supervisor id so if it not intialised
2549: -- intialise again
2550: if nvl(ben_extract.g_asg_csr,'N') <> 'Y' then
2551: get_assignment_info (p_person_id => p_person_id,

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

2546:
2547: if ben_extract.g_sup_csr = 'Y' then
2548: -- supervisor infor expect supervisor id so if it not intialised
2549: -- intialise again
2550: if nvl(ben_extract.g_asg_csr,'N') <> 'Y' then
2551: get_assignment_info (p_person_id => p_person_id,
2552: p_assignment_id => g_assignment_id,
2553: p_effective_date => g_person_ext_dt,
2554: p_ext_rslt_id => p_ext_rslt_id );

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

2557: get_supervisor_info (p_supervisor_id => g_asg_supervisor_id ,
2558: p_effective_date => g_person_ext_dt);
2559: end if;
2560: -- basic salary
2561: if ben_extract.g_bsl_csr = 'Y' then
2562: get_base_annual_salary_info(p_person_id => p_person_id,
2563: p_effective_date => g_person_ext_dt);
2564: end if;
2565: if ben_extract.g_shl_csr = 'Y' then

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

2561: if ben_extract.g_bsl_csr = 'Y' then
2562: get_base_annual_salary_info(p_person_id => p_person_id,
2563: p_effective_date => g_person_ext_dt);
2564: end if;
2565: if ben_extract.g_shl_csr = 'Y' then
2566: get_School_info(p_person_id => p_person_id,
2567: p_effective_date => g_person_ext_dt);
2568: end if;
2569:

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

2567: p_effective_date => g_person_ext_dt);
2568: end if;
2569:
2570: --person level flex provided and used
2571: if ben_extract.g_flxcr_csr = 'Y' then
2572: get_person_flex_credit(p_person_id => p_person_id,
2573: p_effective_date => g_person_ext_dt);
2574: end if ;
2575:

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

3223: end if;
3224: --
3225: if l_include = 'Y' then
3226: --
3227: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
3228:
3229: process_ext_levels(
3230: p_person_id => p_person_id,
3231: p_ext_rslt_id => p_ext_rslt_id,

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

3258: --
3259: g_trans_num := 1;
3260: --
3261: ben_ext_util.get_chg_dates
3262: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
3263: p_effective_date => g_effective_date, --in
3264: p_chg_actl_strt_dt => l_chg_actl_strt_dt, --out
3265: p_chg_actl_end_dt => l_chg_actl_end_dt, --out
3266: p_chg_eff_strt_dt => l_chg_eff_strt_dt, --out

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

3461: END IF;
3462: --
3463: g_rcd_seq := 1; -- what's this do? th.
3464: --
3465: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
3466: --
3467: process_ext_levels(
3468: p_person_id => p_person_id,
3469: p_ext_rslt_id => p_ext_rslt_id,

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

3995: hr_utility.set_location(' Change Event Code ' || g_chg_evt_cd , 99 );
3996: end if;
3997: g_rcd_seq := 1;
3998: --
3999: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
4000: --
4001: process_ext_levels(
4002: p_person_id => p_person_id,
4003: p_ext_rslt_id => p_ext_rslt_id,

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

4043: --
4044: g_trans_num := 1;
4045: --
4046: ben_ext_util.get_cm_dates
4047: (p_ext_dfn_id => ben_extract.g_ext_dfn_id, --in
4048: p_effective_date => g_effective_date, --in
4049: p_to_be_sent_strt_dt => l_to_be_sent_strt_dt, --out
4050: p_to_be_sent_end_dt => l_to_be_sent_end_dt); --out
4051:

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

4208: IF l_include = 'Y' THEN
4209: --
4210: g_rcd_seq := 1;
4211: --
4212: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
4213: --
4214: process_ext_levels(
4215: p_person_id => p_person_id,
4216: p_ext_rslt_id => p_ext_rslt_id,

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

4568:
4569: ----
4570: g_rcd_seq := 1;
4571: --
4572: if nvl(ben_extract.g_spcl_hndl_flag,'X') <> 'Y' then -- normal processing
4573: --
4574: process_ext_levels(
4575: p_person_id => p_person_id,
4576: p_ext_rslt_id => p_ext_rslt_id,

Line 4624: p_request_id => ben_extract.g_request_id,

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

Line 4639: p_request_id => ben_extract.g_request_id,

4635: write_error(
4636: p_err_num => g_err_num,
4637: p_err_name => l_err_message,
4638: p_typ_cd => 'E',
4639: p_request_id => ben_extract.g_request_id,
4640: p_ext_rslt_id => p_ext_rslt_id
4641: );
4642: Raise ;
4643:

Line 4660: p_request_id => ben_extract.g_request_id,

4656: write_error(
4657: p_err_num => g_err_num,
4658: p_err_name => l_err_message,
4659: p_typ_cd => 'E',
4660: p_request_id => ben_extract.g_request_id,
4661: p_ext_rslt_id => p_ext_rslt_id
4662: );
4663: end if ;
4664:

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

4739: --
4740: l_rollback:=FALSE;
4741:
4742: if g_debug then
4743: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );
4744: end if;
4745: --
4746: IF ben_extract.g_per_lvl = 'Y' THEN
4747: --

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

4742: if g_debug then
4743: hr_utility.set_location('ben_extract.g_per_lvl ' || ben_extract.g_per_lvl ,99 );
4744: end if;
4745: --
4746: IF ben_extract.g_per_lvl = 'Y' THEN
4747: --
4748: -- Process Personal Level Detail Records
4749: --
4750: --

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

4773: --IF nvl(g_chg_evt_cd, '*') <> 'TBBC' then
4774: --
4775: -- extract enrollment levels
4776: --
4777: IF (ben_extract.g_enrt_lvl = 'Y' OR ben_extract.g_dpnt_lvl = 'Y' OR ben_extract.g_bnf_lvl = 'Y' OR
4778: ben_extract.g_actn_lvl = 'Y' or ben_extract.g_prem_lvl = 'Y' ) THEN
4779: --
4780: if g_debug then
4781: hr_utility.set_location(' ben_ext_enrt.main',99 );

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

4774: --
4775: -- extract enrollment levels
4776: --
4777: IF (ben_extract.g_enrt_lvl = 'Y' OR ben_extract.g_dpnt_lvl = 'Y' OR ben_extract.g_bnf_lvl = 'Y' OR
4778: ben_extract.g_actn_lvl = 'Y' or ben_extract.g_prem_lvl = 'Y' ) THEN
4779: --
4780: if g_debug then
4781: hr_utility.set_location(' ben_ext_enrt.main',99 );
4782: end if;

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

4792: END IF;
4793: --
4794: --
4795: --RCHASE
4796: --ELSIF nvl(g_chg_evt_cd, '*') = 'TBBC' and ben_extract.g_enrt_lvl = 'Y' then
4797: --
4798: -- open purged_rslt_c(g_chg_pl_id);
4799: --
4800: -- fetch purged_rslt_c into

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

4817: --END IF; -- part type
4818: --
4819: -- create eligibility extract rows
4820: -- =========================================
4821: if ben_extract.g_elig_lvl = 'Y' or ben_extract.g_eligdpnt_lvl = 'Y' then
4822: --
4823: ben_ext_elig.main(
4824: p_person_id => p_person_id,
4825: p_ext_rslt_id => p_ext_rslt_id,

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

4835: end if;
4836: --
4837: -- create flex credit extract rows
4838: -- =========================================
4839: if ben_extract.g_flex_lvl = 'Y' then
4840: --
4841: ben_ext_flcr.main(
4842: p_person_id => p_person_id,
4843: p_ext_rslt_id => p_ext_rslt_id,

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

4853: end if;
4854: --
4855: -- create payroll extract rows
4856: -- ================================
4857: if ben_extract.g_payroll_lvl = 'Y' then
4858: --
4859: ben_ext_payroll.main(
4860: p_person_id => p_person_id,
4861: p_ext_rslt_id => p_ext_rslt_id,

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

4870: end if;
4871: --
4872: -- create run result extract rows
4873: -- ================================
4874: if ben_extract.g_runrslt_lvl = 'Y' then
4875: --
4876: ben_ext_runrslt.main(
4877: p_person_id => p_person_id,
4878: p_ext_rslt_id => p_ext_rslt_id,

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

4887: end if;
4888: --
4889: -- create contact extract rows
4890: -- ================================
4891: if ben_extract.g_contact_lvl = 'Y' then
4892: --
4893: ben_ext_contact.main(
4894: p_person_id => p_person_id,
4895: p_ext_rslt_id => p_ext_rslt_id,

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

4905:
4906: --- cwb
4907: if p_data_typ_cd = 'CW' THEN
4908:
4909: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );
4910:
4911: if ben_extract.g_cwb_bdgt_lvl = 'Y' then
4912: ben_ext_cwb.extract_person_groups
4913: ( p_person_id => p_person_id,

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

4907: if p_data_typ_cd = 'CW' THEN
4908:
4909: hr_utility.set_location( ' bdgt lvl ' || ben_extract.g_cwb_bdgt_lvl , 99 );
4910:
4911: if ben_extract.g_cwb_bdgt_lvl = 'Y' then
4912: ben_ext_cwb.extract_person_groups
4913: ( p_person_id => p_person_id,
4914: p_per_in_ler_id => g_cwb_per_group_per_in_ler_id,
4915: p_ext_rslt_id => p_ext_rslt_id,

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

4919: p_business_group_id => p_business_group_id,
4920: p_effective_date => g_person_ext_dt) ;
4921: end if ;
4922:
4923: if ben_extract.g_cwb_awrd_lvl = 'Y' then
4924: ben_ext_cwb.extract_person_rates
4925: ( p_person_id => p_person_id,
4926: p_per_in_ler_id => g_cwb_per_group_per_in_ler_id,
4927: p_ext_rslt_id => p_ext_rslt_id,

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

4936:
4937: --
4938:
4939:
4940: if ben_extract.g_otl_summ_lvl = 'Y' then
4941:
4942: hxc_ext_timecard.process_summary (
4943: p_person_id => p_person_id,
4944: p_ext_rslt_id => p_ext_rslt_id,

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

4952:
4953: --
4954: /* this validation is done on low level , this is changed to do in record level
4955: this validation moved to benxfrmt.pkb
4956: FOR i in ben_extract.gtt_rcd_rqd_vals.first .. ben_extract.gtt_rcd_rqd_vals.last LOOP
4957: --
4958: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found
4959: THEN
4960: l_rollback := TRUE; -- raise required_error;

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

4954: /* this validation is done on low level , this is changed to do in record level
4955: this validation moved to benxfrmt.pkb
4956: FOR i in ben_extract.gtt_rcd_rqd_vals.first .. ben_extract.gtt_rcd_rqd_vals.last LOOP
4957: --
4958: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found
4959: THEN
4960: l_rollback := TRUE; -- raise required_error;
4961: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'
4962: THEN

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

4957: --
4958: IF NOT ben_extract.gtt_rcd_rqd_vals(i).rcd_found
4959: THEN
4960: l_rollback := TRUE; -- raise required_error;
4961: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'
4962: THEN
4963: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := FALSE; -- reset the value
4964: END IF;
4965: --

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

4959: THEN
4960: l_rollback := TRUE; -- raise required_error;
4961: ELSIF ben_extract.gtt_rcd_rqd_vals(1).low_lvl_cd <> 'NOREQDRCD'
4962: THEN
4963: ben_extract.gtt_rcd_rqd_vals(i).rcd_found := FALSE; -- reset the value
4964: END IF;
4965: --
4966: END LOOP;
4967: */

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

4967: */
4968:
4969:
4970: -- validate the mandatory for low level in sequenc
4971: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4972: --
4973: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);

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

4969:
4970: -- validate the mandatory for low level in sequenc
4971: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4972: --
4973: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4976: l_rollback := TRUE; -- raise required_error;
4977: end if ;

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

4970: -- validate the mandatory for low level in sequenc
4971: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4972: --
4973: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4976: l_rollback := TRUE; -- raise required_error;
4977: end if ;
4978: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then

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

4971: FOR i in ben_extract.gtt_rcd_rqd_vals_seq.first .. ben_extract.gtt_rcd_rqd_vals_seq.last LOOP
4972: --
4973: If NOT ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found THEN
4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4976: l_rollback := TRUE; -- raise required_error;
4977: end if ;
4978: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
4979: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value

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

4974: hr_utility.set_location('Mandatory failed '||ben_extract.gtt_rcd_rqd_vals_seq(i).low_lvl_cd || ' '||
4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4976: l_rollback := TRUE; -- raise required_error;
4977: end if ;
4978: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
4979: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value
4980: end if ;
4981: END LOOP;
4982: --

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

4975: ben_extract.gtt_rcd_rqd_vals_seq(i).seq_num , 15);
4976: l_rollback := TRUE; -- raise required_error;
4977: end if ;
4978: if ben_extract.gtt_rcd_rqd_vals_seq(1).low_lvl_cd <> 'NOREQDRCD' then
4979: ben_extract.gtt_rcd_rqd_vals_seq(i).rcd_found := FALSE; -- reset the value
4980: end if ;
4981: END LOOP;
4982: --
4983: IF l_rollback