APPS.HR_SUPERVISOR_SS dependencies on HR_GENERAL

Line 97: decode(decode(hr_general.get_xbg_profile

93: ,HAO.ORGANIZATION_ID
94: )
95: ),'TRUE',0,1
96: ) +
97: decode(decode(hr_general.get_xbg_profile
98: ,'Y', hao.business_group_id
99: ,hr_general.get_business_group_id
100: )
101: ,hao.business_group_id,0,1

Line 99: ,hr_general.get_business_group_id

95: ),'TRUE',0,1
96: ) +
97: decode(decode(hr_general.get_xbg_profile
98: ,'Y', hao.business_group_id
99: ,hr_general.get_business_group_id
100: )
101: ,hao.business_group_id,0,1
102: ) +
103: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'

Line 114: decode(decode(hr_general.get_xbg_profile

110: )
111: )
112: ,'TRUE',0,1
113: ) +
114: decode(decode(hr_general.get_xbg_profile
115: ,'Y',pap.business_group_id
116: ,hr_general.get_business_group_id
117: )
118: ,pap.business_group_id,0,1

Line 116: ,hr_general.get_business_group_id

112: ,'TRUE',0,1
113: ) +
114: decode(decode(hr_general.get_xbg_profile
115: ,'Y',pap.business_group_id
116: ,hr_general.get_business_group_id
117: )
118: ,pap.business_group_id,0,1
119: )
120: ),0,'Y','N'

Line 547: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;

543: lv_message_number VARCHAR2(80);
544:
545: -- Assignment Security
546: l_supervisor_assignment_id number ;
547: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
548: l_proc constant varchar2(100) := g_package || ' update_supervisor';
549: BEGIN
550: hr_utility.set_location('Entering'|| l_proc,5);
551: OPEN lc_object_version_no ;

Line 665: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

661: p_selected_person_old_sup_id IS NULL ) OR
662: ( p_selected_person_sup_id IS NULL AND
663: p_selected_person_old_sup_id IS NOT NULL) OR
664: (p_selected_person_sup_id <> p_selected_person_old_sup_id) OR
665: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
666: AND (p_selected_person_sup_asg_id is not NULL and
667: p_sel_person_old_sup_asg_id is NULL)
668: ) OR
669: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

Line 669: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

665: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
666: AND (p_selected_person_sup_asg_id is not NULL and
667: p_sel_person_old_sup_asg_id is NULL)
668: ) OR
669: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
670: AND (p_selected_person_sup_asg_id is NULL and
671: p_sel_person_old_sup_asg_id is not NULL)
672: ) OR
673: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

Line 673: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

669: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
670: AND (p_selected_person_sup_asg_id is NULL and
671: p_sel_person_old_sup_asg_id is not NULL)
672: ) OR
673: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
674: AND p_selected_person_sup_asg_id <> p_sel_person_old_sup_asg_id)
675: )
676: THEN
677:

Line 711: (hr_general2.supervisor_assignments_in_use = 'TRUE' AND

707: -- if so update the supervisor
708:
709: IF ((p_direct_reports(i).supervisor_id <> p_selected_emp_id) or
710: (p_direct_reports(i).supervisor_id is Null) or
711: (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
712: p_direct_reports(i).supervisor_assignment_id <>
713: p_passed_assignment_id)
714: or (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
715: p_direct_reports(i).supervisor_assignment_id is NULL)

Line 714: or (hr_general2.supervisor_assignments_in_use = 'TRUE' AND

710: (p_direct_reports(i).supervisor_id is Null) or
711: (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
712: p_direct_reports(i).supervisor_assignment_id <>
713: p_passed_assignment_id)
714: or (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
715: p_direct_reports(i).supervisor_assignment_id is NULL)
716: )
717: THEN
718: update_supervisor(

Line 1605: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;

1601: -- Assignment Security
1602: l_supervisor_assignment_id number ;
1603: l_old_supervisor_assignment_id number ;
1604:
1605: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
1606: l_proc constant varchar2(100) := g_package || 'update_asg';
1607:
1608: BEGIN
1609: hr_utility.set_location('Entering'|| l_proc,5);