DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on PER_INTERIM_PERSON_LIST

Line 1070: person_data PER_INTERIM_PERSON_LIST_STRUCT

1066: RAISE;
1067: END is_employee_check;
1068:
1069: PROCEDURE populateInterimPersonList (
1070: person_data PER_INTERIM_PERSON_LIST_STRUCT
1071: )
1072: IS
1073: --local variable
1074: l_proc constant varchar2(100) := g_package || ' populateInterimPersonList';

Line 1080: DELETE PER_INTERIM_PERSON_LIST;

1076: hr_utility.set_location('Entering: '|| l_proc,5);
1077: -- This commit is issued here to remove the Data from the Temp table.
1078: -- This can be replaced by truncate.
1079: --COMMIT;
1080: DELETE PER_INTERIM_PERSON_LIST;
1081: FOR i in 1.. person_data.count LOOP
1082: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1083: values (person_data(i).person_id, person_data(i).assignment_id, person_data(i).in_my_list);
1084: END LOOP;

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

1078: -- This can be replaced by truncate.
1079: --COMMIT;
1080: DELETE PER_INTERIM_PERSON_LIST;
1081: FOR i in 1.. person_data.count LOOP
1082: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1083: values (person_data(i).person_id, person_data(i).assignment_id, person_data(i).in_my_list);
1084: END LOOP;
1085: hr_utility.set_location('Leaving: '|| l_proc,10);
1086: EXCEPTION

Line 1101: DELETE PER_INTERIM_PERSON_LIST;

1097: l_proc constant varchar2(100) := g_package || ' populateInterimListFromMyList';
1098: BEGIN
1099: hr_utility.set_location('Entering: '|| l_proc,5);
1100: --COMMIT;
1101: DELETE PER_INTERIM_PERSON_LIST;
1102: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1103: SELECT selected_person_id, selected_assignment_id, 'Y'
1104: FROM hr_working_person_lists
1105: WHERE owning_person_id = person_id;

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

1098: BEGIN
1099: hr_utility.set_location('Entering: '|| l_proc,5);
1100: --COMMIT;
1101: DELETE PER_INTERIM_PERSON_LIST;
1102: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
1103: SELECT selected_person_id, selected_assignment_id, 'Y'
1104: FROM hr_working_person_lists
1105: WHERE owning_person_id = person_id;
1106: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 1129: FROM PER_INTERIM_PERSON_LIST list;

1125: list.person_id,
1126: NULL,
1127: NULL,
1128: list.assignment_id
1129: FROM PER_INTERIM_PERSON_LIST list;
1130: hr_utility.set_location('Leaving: '|| l_proc,10);
1131: EXCEPTION
1132: WHEN others THEN
1133: hr_utility.set_location('EXCEPTION: '|| l_proc,555);