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 2312: ben_extract.set_ext_lvls

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

Line 2319: ben_extract.setup_rcd_typ_lvl

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

Line 2378: ben_extract.Xtrct_skltn

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

Line 5037: ben_extract.set_ext_lvls

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

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

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

Line 5059: ben_extract.setup_rcd_typ_lvl

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

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

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

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

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

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

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

Line 5072: ben_extract.g_proc_business_group_id ,

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

Line 5073: ben_extract.g_proc_business_group_name;

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

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

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

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

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

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

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

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

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

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

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

Line 5137: end if ; -- ben_extract.g_org_lvl

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

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

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

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

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

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

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

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

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

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

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