DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on PER_INTERIM_ENTITY_LIST

Line 1284: entity_data PER_INTERIM_ENTITY_LIST_STRUCT

1280: raise;
1281: END SET_SYS_CTX;
1282:
1283: PROCEDURE populateInterimEntityList (
1284: entity_data PER_INTERIM_ENTITY_LIST_STRUCT
1285: ,p_retain_cache IN VARCHAR2
1286: )
1287: IS
1288: --local variable

Line 1294: DELETE PER_INTERIM_ENTITY_LIST;

1290: BEGIN
1291: hr_utility.set_location('Entering: '|| l_proc,5);
1292: if p_retain_cache = 'N'
1293: then
1294: DELETE PER_INTERIM_ENTITY_LIST;
1295: end if;
1296: FOR i in 1.. entity_data.count LOOP
1297: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)
1298: 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 1297: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)

1293: then
1294: DELETE PER_INTERIM_ENTITY_LIST;
1295: end if;
1296: FOR i in 1.. entity_data.count LOOP
1297: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)
1298: 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);
1299: END LOOP;
1300: hr_utility.set_location('Leaving: '|| l_proc,10);
1301: EXCEPTION

Line 1312: DELETE PER_INTERIM_ENTITY_LIST;

1308: IS
1309: l_proc constant varchar2(100) := g_package || 'clearInterimEntityList';
1310: BEGIN
1311: hr_utility.set_location('Entering: '|| l_proc,5);
1312: DELETE PER_INTERIM_ENTITY_LIST;
1313: END clearInterimEntityList;
1314:
1315: procedure isPersonTerminated (
1316: result out nocopy varchar2,