APPS.HR_SUPERVISOR_SS dependencies on HR_GENERAL2

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);