DBA Data[Home] [Help]

APPS.BEN_EXT_ELIG dependencies on HR_UTILITY

Line 387: hr_utility.set_location('Entering'||l_proc, 5);

383:
384: --
385: begin
386: --
387: hr_utility.set_location('Entering'||l_proc, 5);
388: hr_utility.set_location('p_elig_per_elctbl_chc_id '|| p_elig_per_elctbl_chc_id , 5);
389:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;

Line 388: hr_utility.set_location('p_elig_per_elctbl_chc_id '|| p_elig_per_elctbl_chc_id , 5);

384: --
385: begin
386: --
387: hr_utility.set_location('Entering'||l_proc, 5);
388: hr_utility.set_location('p_elig_per_elctbl_chc_id '|| p_elig_per_elctbl_chc_id , 5);
389:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;

Line 413: hr_utility.set_location('g_elig_ee_pre_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_pre_tax_cost , 5);

409:
410: if l_rate_total is not null or l_enb_rate_total is not null then
411: ben_ext_person.g_elig_ee_pre_tax_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
412: end if ;
413: hr_utility.set_location('g_elig_ee_pre_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_pre_tax_cost , 5);
414: --
415: l_rate_total := 0 ;
416: l_enb_rate_total := 0 ;
417:

Line 430: hr_utility.set_location('g_elig_ee_after_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_after_tax_cost , 5);

426: if l_rate_total is not null or l_enb_rate_total is not null then
427: ben_ext_person.g_elig_ee_after_tax_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
428: end if ;
429:
430: hr_utility.set_location('g_elig_ee_after_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_after_tax_cost , 5);
431: --
432: l_rate_total := 0 ;
433: l_enb_rate_total := 0 ;
434:

Line 480: hr_utility.set_location('g_elig_ee_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_ttl_distribution , 5);

476:
477: if l_rate_total is not null or l_enb_rate_total is not null then
478: ben_ext_person.g_elig_ee_ttl_distribution := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
479: end if ;
480: hr_utility.set_location('g_elig_ee_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_ttl_distribution , 5);
481: --
482:
483: l_rate_total := 0 ;
484: l_enb_rate_total := 0 ;

Line 498: hr_utility.set_location('g_elig_er_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_er_ttl_distribution , 5);

494:
495: if l_rate_total is not null or l_enb_rate_total is not null then
496: ben_ext_person.g_elig_er_ttl_distribution := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
497: end if ;
498: hr_utility.set_location('g_elig_er_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_er_ttl_distribution , 5);
499: --
500: l_rate_total := 0 ;
501: l_enb_rate_total := 0 ;
502:

Line 589: hr_utility.set_location('Exiting'||l_proc, 15);

585: open ttl_type_cd_c('CWBWS');
586: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_worksheet_amt;
587: close ttl_type_cd_c ;
588:
589: hr_utility.set_location('Exiting'||l_proc, 15);
590: --
591: End get_rt_info;
592: --
593: -- ----------------------------------------------------------------------------

Line 603: hr_utility.set_location('Entering'||l_proc, 5);

599: l_proc varchar2(72) := g_package||'init_detl_globals';
600: --
601: Begin
602: --
603: hr_utility.set_location('Entering'||l_proc, 5);
604: --
605: ben_ext_person.g_elig_enrt_strt_dt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;

Line 767: hr_utility.set_location('Exiting'||l_proc, 15);

763: ben_ext_person.g_elig_cobra_admin_zip := null;
764: ben_ext_person.g_elig_cobra_admin_phone := null;
765:
766: --
767: hr_utility.set_location('Exiting'||l_proc, 15);
768: --
769: End init_detl_globals;
770: --
771: -- ----------------------------------------------------------------------------

Line 781: hr_utility.set_location('Entering'||l_proc, 5);

777: l_proc varchar2(72) := g_package||'init_detl_drvd_fctr_globals';
778: --
779: Begin
780: --
781: hr_utility.set_location('Entering'||l_proc, 5);
782: --
783: ben_ext_person.g_elig_age_val := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;

Line 794: hr_utility.set_location('Exiting'||l_proc, 15);

790: ben_ext_person.g_elig_hrs_wkd := null;
791: ben_ext_person.g_elig_pct_fl_tm := null;
792: --
793: --
794: hr_utility.set_location('Exiting'||l_proc, 15);
795: --
796: End init_detl_drvd_fctr_globals;
797: --
798: -- ----------------------------------------------------------------------------

Line 1397: hr_utility.set_location('Entering'||l_proc, 5);

1393:
1394:
1395: Begin
1396: --
1397: hr_utility.set_location('Entering'||l_proc, 5);
1398: --
1399: init_detl_globals;
1400: --
1401: ---FOR elig IN c_elig(p_person_id) LOOP

Line 1870: hr_utility.set_location(' cobra cursor ' || ben_Extract.g_cbradm_csr ,160);

1866: end if;
1867:
1868: --
1869: -- cobra admin information
1870: hr_utility.set_location(' cobra cursor ' || ben_Extract.g_cbradm_csr ,160);
1871: if ben_Extract.g_cbradm_csr = 'Y' then
1872:
1873: hr_utility.set_location('getting cobra admin ' ,160);
1874: open c_cbradm_pl(l_elig_pl_id_va(i));

Line 1873: hr_utility.set_location('getting cobra admin ' ,160);

1869: -- cobra admin information
1870: hr_utility.set_location(' cobra cursor ' || ben_Extract.g_cbradm_csr ,160);
1871: if ben_Extract.g_cbradm_csr = 'Y' then
1872:
1873: hr_utility.set_location('getting cobra admin ' ,160);
1874: open c_cbradm_pl(l_elig_pl_id_va(i));
1875: fetch c_cbradm_pl into ben_ext_person.g_elig_cobra_admin_name ,
1876: l_organization_id ;
1877: if c_cbradm_pl%notfound then

Line 1884: hr_utility.set_location(' cobra admin ' || ben_ext_person.g_elig_cobra_admin_name ,160);

1880: l_organization_id ;
1881: close c_cbradm_pgm ;
1882: end if ;
1883: close c_cbradm_pl ;
1884: hr_utility.set_location(' cobra admin ' || ben_ext_person.g_elig_cobra_admin_name ,160);
1885: --- cobra admin address
1886: if l_organization_id is not null then
1887:
1888: hr_utility.set_location('getting cobra admin address ' ,160);

Line 1888: hr_utility.set_location('getting cobra admin address ' ,160);

1884: hr_utility.set_location(' cobra admin ' || ben_ext_person.g_elig_cobra_admin_name ,160);
1885: --- cobra admin address
1886: if l_organization_id is not null then
1887:
1888: hr_utility.set_location('getting cobra admin address ' ,160);
1889: open c_cbradm_adr(l_organization_id ) ;
1890: fetch c_cbradm_adr into
1891: ben_ext_person.g_elig_cobra_admin_org_name
1892: ,ben_ext_person.g_elig_cobra_admin_addr1

Line 1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);

1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);
1903: end if ;
1904: end if ;
1905: -- cobra end

Line 1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);

1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);
1903: end if ;
1904: end if ;
1905: -- cobra end
1906:

Line 1941: hr_utility.set_location('Exiting'||l_proc, 15);

1937: END IF;
1938: --
1939: END LOOP;
1940: --
1941: hr_utility.set_location('Exiting'||l_proc, 15);
1942: --
1943: END;
1944: END;