APPS.EAM_SAFETY_UTILITY_PVT dependencies on EAM_SAFETY_ASSOCIATIONS

Line 108: FROM EAM_SAFETY_ASSOCIATIONS esa

104: ,l_safety_association_rec.ATTRIBUTE30
105: ,l_safety_association_rec.CREATION_DATE
106: ,l_safety_association_rec.CREATED_BY
107:
108: FROM EAM_SAFETY_ASSOCIATIONS esa
109: WHERE esa.SOURCE_ID = p_source_id
110: AND esa.organization_id = p_organization_id
111: AND esa.ASSOCIATION_TYPE = p_association_type;
112:

Line 149: INSERT INTO EAM_SAFETY_ASSOCIATIONS(

145:
146: BEGIN
147: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inserting Safety Association Row'); END IF;
148:
149: INSERT INTO EAM_SAFETY_ASSOCIATIONS(
150: SAFETY_ASSOCIATION_ID
151: ,SOURCE_ID
152: ,TARGET_REF_ID
153: ,ASSOCIATION_TYPE

Line 269: UPDATE EAM_SAFETY_ASSOCIATIONS

265:
266: BEGIN
267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Safety Association Row'); END IF;
268:
269: UPDATE EAM_SAFETY_ASSOCIATIONS
270: SET
271: TARGET_REF_ID =p_safety_association_rec.TARGET_REF_ID
272: ,ASSOCIATION_TYPE =p_safety_association_rec.ASSOCIATION_TYPE
273: ,COMMENTS =p_safety_association_rec.COMMENTS

Line 351: DELETE FROM EAM_SAFETY_ASSOCIATIONS

347: X_pk5_value => null,
348: X_delete_document_flag => 'Y'
349: );
350:
351: DELETE FROM EAM_SAFETY_ASSOCIATIONS
352: WHERE SAFETY_ASSOCIATION_ID =p_safety_association_rec.SAFETY_ASSOCIATION_ID
353: AND ASSOCIATION_TYPE = p_association_type;
354:
355: x_return_status := FND_API.G_RET_STS_SUCCESS;