APPS.HR_SUPERVISOR_SS dependencies on HR_GENERAL

Line 92: decode(decode(hr_general.get_xbg_profile

88: ,HAO.ORGANIZATION_ID
89: )
90: ),'TRUE',0,1
91: ) +
92: decode(decode(hr_general.get_xbg_profile
93: ,'Y', hao.business_group_id
94: ,hr_general.get_business_group_id
95: )
96: ,hao.business_group_id,0,1

Line 94: ,hr_general.get_business_group_id

90: ),'TRUE',0,1
91: ) +
92: decode(decode(hr_general.get_xbg_profile
93: ,'Y', hao.business_group_id
94: ,hr_general.get_business_group_id
95: )
96: ,hao.business_group_id,0,1
97: ) +
98: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'

Line 109: decode(decode(hr_general.get_xbg_profile

105: )
106: )
107: ,'TRUE',0,1
108: ) +
109: decode(decode(hr_general.get_xbg_profile
110: ,'Y',pap.business_group_id
111: ,hr_general.get_business_group_id
112: )
113: ,pap.business_group_id,0,1

Line 111: ,hr_general.get_business_group_id

107: ,'TRUE',0,1
108: ) +
109: decode(decode(hr_general.get_xbg_profile
110: ,'Y',pap.business_group_id
111: ,hr_general.get_business_group_id
112: )
113: ,pap.business_group_id,0,1
114: )
115: ),0,'Y','N'

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

498: lv_message_number VARCHAR2(80);
499:
500: -- Assignment Security
501: l_supervisor_assignment_id number ;
502: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
503: l_proc constant varchar2(100) := g_package || ' update_supervisor';
504: BEGIN
505: hr_utility.set_location('Entering'|| l_proc,5);
506: OPEN lc_object_version_no ;

Line 620: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

616: p_selected_person_old_sup_id IS NULL ) OR
617: ( p_selected_person_sup_id IS NULL AND
618: p_selected_person_old_sup_id IS NOT NULL) OR
619: (p_selected_person_sup_id <> p_selected_person_old_sup_id) OR
620: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
621: AND (p_selected_person_sup_asg_id is not NULL and
622: p_sel_person_old_sup_asg_id is NULL)
623: ) OR
624: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

Line 624: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

620: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
621: AND (p_selected_person_sup_asg_id is not NULL and
622: p_sel_person_old_sup_asg_id is NULL)
623: ) OR
624: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
625: AND (p_selected_person_sup_asg_id is NULL and
626: p_sel_person_old_sup_asg_id is not NULL)
627: ) OR
628: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

Line 628: ( hr_general2.supervisor_assignments_in_use = 'TRUE'

624: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
625: AND (p_selected_person_sup_asg_id is NULL and
626: p_sel_person_old_sup_asg_id is not NULL)
627: ) OR
628: ( hr_general2.supervisor_assignments_in_use = 'TRUE'
629: AND p_selected_person_sup_asg_id <> p_sel_person_old_sup_asg_id)
630: )
631: THEN
632:

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

662: -- if so update the supervisor
663:
664: IF ((p_direct_reports(i).supervisor_id <> p_selected_emp_id) or
665: (p_direct_reports(i).supervisor_id is Null) or
666: (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
667: p_direct_reports(i).supervisor_assignment_id <>
668: p_passed_assignment_id)
669: or (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
670: p_direct_reports(i).supervisor_assignment_id is NULL)

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

665: (p_direct_reports(i).supervisor_id is Null) or
666: (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
667: p_direct_reports(i).supervisor_assignment_id <>
668: p_passed_assignment_id)
669: or (hr_general2.supervisor_assignments_in_use = 'TRUE' AND
670: p_direct_reports(i).supervisor_assignment_id is NULL)
671: )
672: THEN
673: update_supervisor(

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

1556: -- Assignment Security
1557: l_supervisor_assignment_id number ;
1558: l_old_supervisor_assignment_id number ;
1559:
1560: l_assignment_security_profile varchar(30) := hr_general2.supervisor_assignments_in_use ;
1561: l_proc constant varchar2(100) := g_package || 'update_asg';
1562:
1563: BEGIN
1564: hr_utility.set_location('Entering'|| l_proc,5);