DBA Data[Home] [Help]

APPS.BEN_EXT_ENRT dependencies on HR_UTILITY

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

17: l_proc varchar2(72) := g_package||'initialize_enrt_globals';
18: --
19: Begin
20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: /* Start of Changes for WWBUG: 1828349: addition */
24: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
25: /* End of Changes for WWBUG: 1828349 */

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

158: ben_ext_person.g_enrt_pl_typ_pgm_fd_code := null;
159:
160:
161:
162: hr_utility.set_location('Exiting'||l_proc, 15);
163: --
164: End initialize_enrt_globals;
165: --
166: -- procedure to initialize rt info globals - May, 99

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

173: l_proc varchar2(72) := g_package||'initialize_rt_info_globals';
174: --
175: Begin
176: --
177: hr_utility.set_location('Entering'||l_proc, 5);
178: --
179: ben_ext_person.g_ee_pre_tax_cost := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;

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

210: ben_ext_person.g_pev_er_forfeited := null ;
211:
212:
213: --
214: hr_utility.set_location('Exiting'||l_proc, 15);
215: --
216: End initialize_rt_info_globals;
217: --
218: -- ----------------------------------------------------------------------------

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

331: l_proc varchar2(72) := g_package||'get_rt_info';
332: --
333: Begin
334: --
335: hr_utility.set_location('Entering'||l_proc, 5);
336: --
337: --
338: -- Initialize rt info globals - May, 99
339: initialize_rt_info_globals;

Line 375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );

371: open ttl_reimb_c;
372: fetch ttl_reimb_c into ben_ext_person.g_er_reimbursement , ben_ext_person.g_pev_er_reimbursement;
373: close ttl_reimb_c;
374:
375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );
376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );
377: --- Forfeiture
378: open ttl_type_cd_c('PRTRFS');
379: fetch ttl_type_cd_c into ben_ext_person.g_er_forfeited , ben_ext_person.g_pev_er_forfeited;

Line 376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );

372: fetch ttl_reimb_c into ben_ext_person.g_er_reimbursement , ben_ext_person.g_pev_er_reimbursement;
373: close ttl_reimb_c;
374:
375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );
376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );
377: --- Forfeiture
378: open ttl_type_cd_c('PRTRFS');
379: fetch ttl_type_cd_c into ben_ext_person.g_er_forfeited , ben_ext_person.g_pev_er_forfeited;
380: close ttl_type_cd_c ;

Line 395: hr_utility.set_location( 'CWBGP ' || ben_ext_person.g_er_cwb_grant_price , 911 );

391: open ttl_type_cd_c('CWBGP');
392: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_grant_price,l_dummy ;
393: close ttl_type_cd_c ;
394:
395: hr_utility.set_location( 'CWBGP ' || ben_ext_person.g_er_cwb_grant_price , 911 );
396:
397: open ttl_type_cd_c('CWBMR1');
398: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_1,l_dummy ;
399: close ttl_type_cd_c ;

Line 437: hr_utility.set_location( 'CWBWS ' || ben_ext_person.g_er_cwb_worksheet_amt , 911 );

433: open ttl_type_cd_c('CWBWS');
434: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_amt,l_dummy ;
435: close ttl_type_cd_c ;
436:
437: hr_utility.set_location( 'CWBWS ' || ben_ext_person.g_er_cwb_worksheet_amt , 911 );
438:
439: --
440: hr_utility.set_location('Exiting'||l_proc, 15);
441: --

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

436:
437: hr_utility.set_location( 'CWBWS ' || ben_ext_person.g_er_cwb_worksheet_amt , 911 );
438:
439: --
440: hr_utility.set_location('Exiting'||l_proc, 15);
441: --
442: End get_rt_info;
443: -- ----------------------------------------------------------------------------
444: -- |--------------------< main >----------------------------------------------|

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

826: --
827:
828: BEGIN
829: --
830: hr_utility.set_location('Entering'||l_proc, 5);
831: --
832: FOR enrt IN c_enrt_rslt LOOP
833: --
834: -- initialize enrt globals - May, 99

Line 1065: hr_utility.set_location(' person Id ' || p_person_id , 991) ;

1061: end if;
1062: --
1063: if ben_extract.g_rt_csr = 'Y' then
1064: --
1065: hr_utility.set_location(' person Id ' || p_person_id , 991) ;
1066: hr_utility.set_location(' result id ' || enrt.prtt_enrt_rslt_id , 991 ) ;
1067: get_rt_info(p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,
1068: p_effective_date => p_effective_date);
1069: --

Line 1066: hr_utility.set_location(' result id ' || enrt.prtt_enrt_rslt_id , 991 ) ;

1062: --
1063: if ben_extract.g_rt_csr = 'Y' then
1064: --
1065: hr_utility.set_location(' person Id ' || p_person_id , 991) ;
1066: hr_utility.set_location(' result id ' || enrt.prtt_enrt_rslt_id , 991 ) ;
1067: get_rt_info(p_prtt_enrt_rslt_id => enrt.prtt_enrt_rslt_id,
1068: p_effective_date => p_effective_date);
1069: --
1070: end if;

Line 1084: hr_utility.set_location('entering to open flex credit ' ,160);

1080: -- this is for person level so moving benxpers
1081: -- retrieve total flex credit info
1082: /*
1083: if ben_extract.g_flxcr_csr = 'Y' then
1084: hr_utility.set_location('entering to open flex credit ' ,160);
1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);
1086: open flex_cred_info_c(enrt.prtt_enrt_rslt_id);
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1088: ,ben_ext_person.g_flex_credit_forfited

Line 1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);

1081: -- retrieve total flex credit info
1082: /*
1083: if ben_extract.g_flxcr_csr = 'Y' then
1084: hr_utility.set_location('entering to open flex credit ' ,160);
1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);
1086: open flex_cred_info_c(enrt.prtt_enrt_rslt_id);
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1088: ,ben_ext_person.g_flex_credit_forfited
1089: ,ben_ext_person.g_flex_credit_used;

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

1273: --
1274: END IF; -- l_include = 'Y'
1275: --
1276: END LOOP;
1277: hr_utility.set_location('Exiting'||l_proc, 15);
1278:
1279: END; -- main
1280: --
1281: END; -- package