DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on PER_INTERIM_ENTITY_LIST

Line 1080: entity_data PER_INTERIM_ENTITY_LIST_STRUCT

1076: raise;
1077: END SET_SYS_CTX;
1078:
1079: PROCEDURE populateInterimEntityList (
1080: entity_data PER_INTERIM_ENTITY_LIST_STRUCT
1081: ,p_retain_cache IN VARCHAR2
1082: )
1083: IS
1084: --local variable

Line 1090: DELETE PER_INTERIM_ENTITY_LIST;

1086: BEGIN
1087: hr_utility.set_location('Entering: '|| l_proc,5);
1088: if p_retain_cache = 'N'
1089: then
1090: DELETE PER_INTERIM_ENTITY_LIST;
1091: end if;
1092: FOR i in 1.. entity_data.count LOOP
1093: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)
1094: values (entity_data(i).entity_name, entity_data(i).state,entity_data(i).pk1,entity_data(i).pk2,entity_data(i).pk3,entity_data(i).pk4,entity_data(i).pk5);

Line 1093: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)

1089: then
1090: DELETE PER_INTERIM_ENTITY_LIST;
1091: end if;
1092: FOR i in 1.. entity_data.count LOOP
1093: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)
1094: values (entity_data(i).entity_name, entity_data(i).state,entity_data(i).pk1,entity_data(i).pk2,entity_data(i).pk3,entity_data(i).pk4,entity_data(i).pk5);
1095: END LOOP;
1096: hr_utility.set_location('Leaving: '|| l_proc,10);
1097: EXCEPTION

Line 1108: DELETE PER_INTERIM_ENTITY_LIST;

1104: IS
1105: l_proc constant varchar2(100) := g_package || 'clearInterimEntityList';
1106: BEGIN
1107: hr_utility.set_location('Entering: '|| l_proc,5);
1108: DELETE PER_INTERIM_ENTITY_LIST;
1109: END clearInterimEntityList;
1110:
1111: procedure isPersonTerminated (
1112: result out nocopy varchar2,