APPS.EAM_ESTABLISHMENT_UTILITY_PVT dependencies on EAM_ESTABLISHMENT_DETAILS

Line 140: FROM EAM_ESTABLISHMENT_DETAILS iso

136: ,l_safety_establishment_rec.ATTRIBUTE30
137: ,l_safety_establishment_rec.CREATION_DATE
138: ,l_safety_establishment_rec.CREATED_BY
139:
140: FROM EAM_ESTABLISHMENT_DETAILS iso
141: WHERE iso.establishment_id = p_establishment_id
142: AND iso.organization_id = p_organization_id;
143:
144: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

Line 173: INSERT INTO EAM_ESTABLISHMENT_DETAILS(

169: BEGIN
170:
171: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Isolation Establishment record for ' || p_safety_establishment_rec.establishment_id); END IF;
172:
173: INSERT INTO EAM_ESTABLISHMENT_DETAILS(
174: establishment_id
175: ,establishment_source
176: ,establishment_source_id
177: ,sequence_type

Line 307: UPDATE EAM_ESTABLISHMENT_DETAILS

303:
304: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Isolation establishment rec for ' || p_safety_establishment_rec.establishment_id); END IF;
305:
306:
307: UPDATE EAM_ESTABLISHMENT_DETAILS
308: SET
309: establishment_source =p_safety_establishment_rec.establishment_source
310: ,establishment_source_id =p_safety_establishment_rec.establishment_source_id
311: ,sequence_type =p_safety_establishment_rec.sequence_type

Line 380: DELETE FROM EAM_ESTABLISHMENT_DETAILS

376: ) IS
377: BEGIN
378: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deletiing establishment details ' ); END IF;
379:
380: DELETE FROM EAM_ESTABLISHMENT_DETAILS
381: WHERE establishment_id =p_safety_establishment_rec.establishment_id
382: AND organization_id = p_organization_id;
383:
384: x_return_status := FND_API.G_RET_STS_SUCCESS;