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_THREAD dependencies on BEN_EXTRACT

Line 101: 11/07/2001 mhoyes 115.66 - bug 2100912. Moved call to ben_extract.set_ext_lvls

97: 06/06/2001 tilak 115.62 caling formula is added for header/trailer - 1786750
98: 06/21/2001 tilak 115.63 gv$_system_parameter used instead of v$system_paramter
99: 07/27/2001 tilak 115.65 Change Event Dynomic sql is cahnged,
100: chg_eff_Dt is replaced p_effective date
101: 11/07/2001 mhoyes 115.66 - bug 2100912. Moved call to ben_extract.set_ext_lvls
102: from chunk level to thread level. Globals were
103: being over refreshed.
104: 11/09/2001 mhoyes 115.67 - bug 2100912. Moved call to ben_extract.setup_rcd_typ_lvl
105: from chunk level to thread level. Globals were

Line 104: 11/09/2001 mhoyes 115.67 - bug 2100912. Moved call to ben_extract.setup_rcd_typ_lvl

100: chg_eff_Dt is replaced p_effective date
101: 11/07/2001 mhoyes 115.66 - bug 2100912. Moved call to ben_extract.set_ext_lvls
102: from chunk level to thread level. Globals were
103: being over refreshed.
104: 11/09/2001 mhoyes 115.67 - bug 2100912. Moved call to ben_extract.setup_rcd_typ_lvl
105: from chunk level to thread level. Globals were
106: being over refreshed.
107: 11/26/2001 mhoyes 115.68 - dbdrv lines.
108:

Line 2314: ben_extract.set_ext_lvls

2310: -- memory consumption
2311: --
2312: -- Determine extract Levels
2313: --
2314: ben_extract.set_ext_lvls
2315: (p_ext_file_id => p_ext_file_id
2316: ,p_business_group_id => p_business_group_id
2317: );
2318: --

Line 2321: ben_extract.setup_rcd_typ_lvl

2317: );
2318: --
2319: -- Setup record and required level tables
2320: --
2321: ben_extract.setup_rcd_typ_lvl
2322: (p_ext_file_id => p_ext_file_id
2323: );
2324:
2325: --

Line 2380: ben_extract.Xtrct_skltn

2376: close c_range_thread;
2377: --
2378: l_line := 4;
2379: --
2380: ben_extract.Xtrct_skltn
2381: (p_ext_dfn_id => p_ext_dfn_id
2382: ,p_business_group_id => p_business_group_id
2383: ,p_effective_date => l_effective_date
2384: ,p_benefit_action_id => p_benefit_action_id

Line 5039: ben_extract.set_ext_lvls

5035: if g_debug then
5036: hr_utility.set_location ('Entering '||l_proc,5);
5037: end if;
5038: --
5039: ben_extract.set_ext_lvls
5040: (p_ext_file_id => p_ext_file_id
5041: ,p_business_group_id => p_business_group_id
5042: );
5043:

Line 5044: if nvl(ben_extract.g_subhead_dfn,'N') <> 'Y' then

5040: (p_ext_file_id => p_ext_file_id
5041: ,p_business_group_id => p_business_group_id
5042: );
5043:
5044: if nvl(ben_extract.g_subhead_dfn,'N') <> 'Y' then
5045: if g_debug then
5046: hr_utility.set_location ('Exiting no definition found '||l_proc,10);
5047: end if;
5048: return ;

Line 5061: ben_extract.setup_rcd_typ_lvl

5057:
5058:
5059: -- Setup record and required level tables
5060: --
5061: ben_extract.setup_rcd_typ_lvl
5062: (p_ext_file_id => p_ext_file_id
5063: );
5064: --
5065: g_ext_dfn_id := p_ext_dfn_id;

Line 5068: hr_utility.set_location ( ' org ' || ben_extract.g_org_lvl || ' pos '|| ben_extract.g_pos_lvl ||

5064: --
5065: g_ext_dfn_id := p_ext_dfn_id;
5066: g_ext_rslt_id := p_ext_rslt_id;
5067:
5068: hr_utility.set_location ( ' org ' || ben_extract.g_org_lvl || ' pos '|| ben_extract.g_pos_lvl ||
5069: ' pay ' || ben_extract.g_pay_lvl || ' bg ' || ben_extract.g_bg_csr , 99 ) ;
5070: --- get the processing bg
5071: --if ben_extract.g_bg_csr = 'Y' then
5072: open c_pbg ;

Line 5069: ' pay ' || ben_extract.g_pay_lvl || ' bg ' || ben_extract.g_bg_csr , 99 ) ;

5065: g_ext_dfn_id := p_ext_dfn_id;
5066: g_ext_rslt_id := p_ext_rslt_id;
5067:
5068: hr_utility.set_location ( ' org ' || ben_extract.g_org_lvl || ' pos '|| ben_extract.g_pos_lvl ||
5069: ' pay ' || ben_extract.g_pay_lvl || ' bg ' || ben_extract.g_bg_csr , 99 ) ;
5070: --- get the processing bg
5071: --if ben_extract.g_bg_csr = 'Y' then
5072: open c_pbg ;
5073: fetch c_pbg into

Line 5071: --if ben_extract.g_bg_csr = 'Y' then

5067:
5068: hr_utility.set_location ( ' org ' || ben_extract.g_org_lvl || ' pos '|| ben_extract.g_pos_lvl ||
5069: ' pay ' || ben_extract.g_pay_lvl || ' bg ' || ben_extract.g_bg_csr , 99 ) ;
5070: --- get the processing bg
5071: --if ben_extract.g_bg_csr = 'Y' then
5072: open c_pbg ;
5073: fetch c_pbg into
5074: ben_extract.g_proc_business_group_id ,
5075: ben_extract.g_proc_business_group_name;

Line 5074: ben_extract.g_proc_business_group_id ,

5070: --- get the processing bg
5071: --if ben_extract.g_bg_csr = 'Y' then
5072: open c_pbg ;
5073: fetch c_pbg into
5074: ben_extract.g_proc_business_group_id ,
5075: ben_extract.g_proc_business_group_name;
5076: close c_pbg ;
5077: hr_utility.set_location ( ' proc bg ' || ben_extract.g_proc_business_group_name , 99 ) ;
5078: --end if ;

Line 5075: ben_extract.g_proc_business_group_name;

5071: --if ben_extract.g_bg_csr = 'Y' then
5072: open c_pbg ;
5073: fetch c_pbg into
5074: ben_extract.g_proc_business_group_id ,
5075: ben_extract.g_proc_business_group_name;
5076: close c_pbg ;
5077: hr_utility.set_location ( ' proc bg ' || ben_extract.g_proc_business_group_name , 99 ) ;
5078: --end if ;
5079:

Line 5077: hr_utility.set_location ( ' proc bg ' || ben_extract.g_proc_business_group_name , 99 ) ;

5073: fetch c_pbg into
5074: ben_extract.g_proc_business_group_id ,
5075: ben_extract.g_proc_business_group_name;
5076: close c_pbg ;
5077: hr_utility.set_location ( ' proc bg ' || ben_extract.g_proc_business_group_name , 99 ) ;
5078: --end if ;
5079:
5080:
5081: for l_bg in c_bg Loop

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

5098:
5099:
5100: if l_include = 'Y' then
5101:
5102: if ben_extract.g_bg_csr = 'Y' then
5103:
5104: ben_ext_person.g_business_group_id := l_bg.business_group_id ;
5105: ben_extract.g_business_group_name := l_bg.name ;
5106: end if ;

Line 5105: ben_extract.g_business_group_name := l_bg.name ;

5101:
5102: if ben_extract.g_bg_csr = 'Y' then
5103:
5104: ben_ext_person.g_business_group_id := l_bg.business_group_id ;
5105: ben_extract.g_business_group_name := l_bg.name ;
5106: end if ;
5107:
5108: --- extract organization and postion level
5109: if ben_extract.g_org_lvl = 'Y' or ben_extract.g_pos_lvl = 'Y' then

Line 5109: if ben_extract.g_org_lvl = 'Y' or ben_extract.g_pos_lvl = 'Y' then

5105: ben_extract.g_business_group_name := l_bg.name ;
5106: end if ;
5107:
5108: --- extract organization and postion level
5109: if ben_extract.g_org_lvl = 'Y' or ben_extract.g_pos_lvl = 'Y' then
5110: for i in c_org(l_bg.business_group_id) loop
5111:
5112: hr_utility.set_location ('_organization '||i.name,10);
5113: if ben_extract.g_org_lvl = 'Y' then

Line 5113: if ben_extract.g_org_lvl = 'Y' then

5109: if ben_extract.g_org_lvl = 'Y' or ben_extract.g_pos_lvl = 'Y' then
5110: for i in c_org(l_bg.business_group_id) loop
5111:
5112: hr_utility.set_location ('_organization '||i.name,10);
5113: if ben_extract.g_org_lvl = 'Y' then
5114:
5115: if p_ext_crit_prfl_id is not null then
5116: ben_ext_evaluate_inclusion.Evaluate_subhead_incl
5117: (p_organization_id => i.organization_id ,

Line 5139: end if ; -- ben_extract.g_org_lvl

5135: p_ext_per_bg_id => l_bg.business_group_id,
5136: p_effective_date => p_effective_date
5137: );
5138: end if ; -- include
5139: end if ; -- ben_extract.g_org_lvl
5140:
5141: --- position
5142:
5143: if ben_extract.g_pos_lvl = 'Y' then

Line 5143: if ben_extract.g_pos_lvl = 'Y' then

5139: end if ; -- ben_extract.g_org_lvl
5140:
5141: --- position
5142:
5143: if ben_extract.g_pos_lvl = 'Y' then
5144:
5145: hr_utility.set_location( 'spl flag ' || g_subhdr_chg_log , 99 );
5146:
5147: if g_subhdr_chg_log = 'Y' then

Line 5246: if ben_extract.g_pay_lvl = 'Y' then

5242:
5243: --- payroll
5244:
5245:
5246: if ben_extract.g_pay_lvl = 'Y' then
5247: for j in c_pay (l_bg.business_group_id ) Loop
5248: init_sub_lvl ;
5249: l_include := 'Y' ;
5250: -- call inclusion criteris

Line 5287: if ben_extract.g_job_lvl = 'Y' then

5283:
5284:
5285: --- extract job level
5286:
5287: if ben_extract.g_job_lvl = 'Y' then
5288: for i in c_job (l_bg.business_group_id) loop
5289: init_sub_lvl ;
5290: l_include := 'Y' ;
5291: -- call inclusion criteris

Line 5325: if ben_extract.g_loc_lvl = 'Y' then

5321: end loop;
5322: end if ;
5323: --- extractr location level
5324:
5325: if ben_extract.g_loc_lvl = 'Y' then
5326: for i in c_loc (l_bg.business_group_id) loop
5327: init_sub_lvl ;
5328: l_include := 'Y' ;
5329: -- call inclusion criteris

Line 5362: if ben_extract.g_grd_lvl = 'Y' then

5358: end loop;
5359: end if ;
5360:
5361: -- extract grade informations
5362: if ben_extract.g_grd_lvl = 'Y' then
5363: for i in c_grade (l_bg.business_group_id) loop
5364: init_sub_lvl ;
5365: l_include := 'Y' ;
5366: -- call inclusion criteris