APPS.HR_SUPERVISOR_SS dependencies on HR_GENERAL2

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