APPS.HR_UTIL_MISC_SS dependencies on PER_INTERIM_PERSON_LIST

Line 866: person_data PER_INTERIM_PERSON_LIST_STRUCT

862: RAISE;
863: END is_employee_check;
864:
865: PROCEDURE populateInterimPersonList (
866: person_data PER_INTERIM_PERSON_LIST_STRUCT
867: )
868: IS
869: --local variable
870: l_proc constant varchar2(100) := g_package || ' populateInterimPersonList';

Line 876: DELETE PER_INTERIM_PERSON_LIST;

872: hr_utility.set_location('Entering: '|| l_proc,5);
873: -- This commit is issued here to remove the Data from the Temp table.
874: -- This can be replaced by truncate.
875: --COMMIT;
876: DELETE PER_INTERIM_PERSON_LIST;
877: FOR i in 1.. person_data.count LOOP
878: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
879: values (person_data(i).person_id, person_data(i).assignment_id, person_data(i).in_my_list);
880: END LOOP;

Line 878: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)

874: -- This can be replaced by truncate.
875: --COMMIT;
876: DELETE PER_INTERIM_PERSON_LIST;
877: FOR i in 1.. person_data.count LOOP
878: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
879: values (person_data(i).person_id, person_data(i).assignment_id, person_data(i).in_my_list);
880: END LOOP;
881: hr_utility.set_location('Leaving: '|| l_proc,10);
882: EXCEPTION

Line 897: DELETE PER_INTERIM_PERSON_LIST;

893: l_proc constant varchar2(100) := g_package || ' populateInterimListFromMyList';
894: BEGIN
895: hr_utility.set_location('Entering: '|| l_proc,5);
896: --COMMIT;
897: DELETE PER_INTERIM_PERSON_LIST;
898: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
899: SELECT selected_person_id, selected_assignment_id, 'Y'
900: FROM hr_working_person_lists
901: WHERE owning_person_id = person_id;

Line 898: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)

894: BEGIN
895: hr_utility.set_location('Entering: '|| l_proc,5);
896: --COMMIT;
897: DELETE PER_INTERIM_PERSON_LIST;
898: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
899: SELECT selected_person_id, selected_assignment_id, 'Y'
900: FROM hr_working_person_lists
901: WHERE owning_person_id = person_id;
902: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 925: FROM PER_INTERIM_PERSON_LIST list;

921: list.person_id,
922: NULL,
923: NULL,
924: list.assignment_id
925: FROM PER_INTERIM_PERSON_LIST list;
926: hr_utility.set_location('Leaving: '|| l_proc,10);
927: EXCEPTION
928: WHEN others THEN
929: hr_utility.set_location('EXCEPTION: '|| l_proc,555);