APPS.BEN_EXT_THREAD dependencies on HR_GENERAL

Line 559: -- to_char(l_temp_dt,hr_general.decode_lookup('BEN_EXT_FRMT_MASK',elmt_rec.frmt_mask_cd)) || ''' ' ;

555: --l_curr_string := ' VAL_' || ltrim(to_char(elmt_rec.seq_num,'09')) || ' = ''' || to_char(l_temp_dt) || ''' ' ;
556: l_value := to_char(l_temp_dt) ;
557: else
558: --l_curr_string := ' VAL_' || ltrim(to_char(elmt_rec.seq_num,'09')) || ' = ''' ||
559: -- to_char(l_temp_dt,hr_general.decode_lookup('BEN_EXT_FRMT_MASK',elmt_rec.frmt_mask_cd)) || ''' ' ;
560: l_col_name := ' VAL_' || ltrim(to_char(elmt_rec.seq_num,'09')) ;
561: l_value := to_char(l_temp_dt,hr_general.decode_lookup('BEN_EXT_FRMT_MASK',elmt_rec.frmt_mask_cd)) ;
562: end if;
563: --

Line 561: l_value := to_char(l_temp_dt,hr_general.decode_lookup('BEN_EXT_FRMT_MASK',elmt_rec.frmt_mask_cd)) ;

557: else
558: --l_curr_string := ' VAL_' || ltrim(to_char(elmt_rec.seq_num,'09')) || ' = ''' ||
559: -- to_char(l_temp_dt,hr_general.decode_lookup('BEN_EXT_FRMT_MASK',elmt_rec.frmt_mask_cd)) || ''' ' ;
560: l_col_name := ' VAL_' || ltrim(to_char(elmt_rec.seq_num,'09')) ;
561: l_value := to_char(l_temp_dt,hr_general.decode_lookup('BEN_EXT_FRMT_MASK',elmt_rec.frmt_mask_cd)) ;
562: end if;
563: --
564: /*
565: if l_tot_string is null then

Line 1218: hr_general.decode_lookup('BEN_EXT_FRMT_MASK',b.frmt_mask_cd) frmt_mask_cd,

1214: b.ext_data_elmt_id,
1215: b.data_elmt_typ_cd,
1216: b.data_elmt_rl,
1217: b.name,
1218: hr_general.decode_lookup('BEN_EXT_FRMT_MASK',b.frmt_mask_cd) frmt_mask_cd,
1219: b.frmt_mask_cd frmt_mask_lookup_cd ,
1220: b.string_val,
1221: b.dflt_val,
1222: b.max_length_num,

Line 4725: if HR_SECURITY.VIEW_ALL = 'Y' and hr_general.get_xbg_profile = 'Y' then

4721: -- hr_utility.set_location ('Entering '||l_proc,5);
4722: -- hr_utility.set_location ('person '||p_person_id ,5);
4723: -- end if;
4724:
4725: if HR_SECURITY.VIEW_ALL = 'Y' and hr_general.get_xbg_profile = 'Y' then
4726: -- hr_utility.set_location ('Exiting '||l_proc,5);
4727: return l_return ;
4728: end if ;
4729:

Line 4732: if hr_general.get_xbg_profile <> 'Y'

4728: end if ;
4729:
4730: /* moved down
4731: -- this is common validation for asg and person
4732: if hr_general.get_xbg_profile <> 'Y'
4733: and hr_general.get_business_group_id is not null
4734: and hr_general.get_business_group_id <> p_business_group_id then
4735: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4736: Return false ;

Line 4733: and hr_general.get_business_group_id is not null

4729:
4730: /* moved down
4731: -- this is common validation for asg and person
4732: if hr_general.get_xbg_profile <> 'Y'
4733: and hr_general.get_business_group_id is not null
4734: and hr_general.get_business_group_id <> p_business_group_id then
4735: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4736: Return false ;
4737: end if ;

Line 4734: and hr_general.get_business_group_id <> p_business_group_id then

4730: /* moved down
4731: -- this is common validation for asg and person
4732: if hr_general.get_xbg_profile <> 'Y'
4733: and hr_general.get_business_group_id is not null
4734: and hr_general.get_business_group_id <> p_business_group_id then
4735: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4736: Return false ;
4737: end if ;
4738:

Line 4755: if hr_general.get_xbg_profile <> 'Y'

4751:
4752:
4753:
4754: -- this is common validation for asg and person
4755: if hr_general.get_xbg_profile <> 'Y'
4756: and hr_general.get_business_group_id is not null
4757: and hr_general.get_business_group_id <> l_business_group_id then
4758: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4759: Return false ;

Line 4756: and hr_general.get_business_group_id is not null

4752:
4753:
4754: -- this is common validation for asg and person
4755: if hr_general.get_xbg_profile <> 'Y'
4756: and hr_general.get_business_group_id is not null
4757: and hr_general.get_business_group_id <> l_business_group_id then
4758: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4759: Return false ;
4760: end if ;

Line 4757: and hr_general.get_business_group_id <> l_business_group_id then

4753:
4754: -- this is common validation for asg and person
4755: if hr_general.get_xbg_profile <> 'Y'
4756: and hr_general.get_business_group_id is not null
4757: and hr_general.get_business_group_id <> l_business_group_id then
4758: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4759: Return false ;
4760: end if ;
4761: