APPS.EAM_SAFETY_ASSOCIATION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38

    CURSOR C2 IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line: 62

              SELECT COUNT(*)
              INTO l_count
              FROM EAM_WORK_CLEARANCES
              WHERE WORK_CLEARANCE_ID   = l_safety_assoc_rec.TARGET_REF_ID
              AND organization_id = l_safety_assoc_rec.organization_id;

Line: 76

              SELECT COUNT(*)
              INTO l_count
              FROM EAM_WORK_PERMITS
              WHERE PERMIT_ID   = l_safety_assoc_rec.SOURCE_ID
              AND organization_id = l_safety_assoc_rec.organization_id;

Line: 100

                    SELECT COUNT(*)
                    INTO l_count
                    FROM EAM_SAFETY_ASSOCIATIONS
                    WHERE SOURCE_ID   = l_safety_assoc_rec.SOURCE_ID
                    AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
                    AND organization_id = l_safety_assoc_rec.organization_id;

Line: 186

             SELECT WP.PERMIT_NAME into l_token_tbl(1).token_value
             FROM EAM_WORK_PERMITS WP
             WHERE WP.PERMIT_ID   = l_safety_assoc_rec.SOURCE_ID
             AND WP.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 192

             SELECT EWC.WORK_CLEARANCE_NAME into l_token_tbl(2).token_value
             FROM EAM_WORK_CLEARANCES EWC
             WHERE EWC.WORK_CLEARANCE_ID   = l_safety_assoc_rec.TARGET_REF_ID
             AND EWC.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 226

    CURSOR C1 IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line: 253

              SELECT COUNT(*)
              INTO l_count
              FROM EAM_WORK_CLEARANCES
              WHERE WORK_CLEARANCE_ID   = l_safety_assoc_rec.source_id
              AND organization_id = l_safety_assoc_rec.organization_id;

Line: 267

              SELECT COUNT(*)
              INTO l_count
              FROM WIP_ENTITIES
              WHERE WIP_ENTITY_ID   = l_safety_assoc_rec.TARGET_REF_ID
              AND organization_id = l_safety_assoc_rec.organization_id;

Line: 291

                    SELECT COUNT(*)
                    INTO l_count
                    FROM EAM_SAFETY_ASSOCIATIONS
                    WHERE SOURCE_ID   = l_safety_assoc_rec.SOURCE_ID
                    AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
                    AND organization_id = l_safety_assoc_rec.organization_id;

Line: 346

			EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
                (  p_mesg_token_Tbl     => l_out_Mesg_Token_Tbl
                 , p_error_level        => l_error_level
                 , p_entity_index       => l_entity_index
                );

Line: 367

			EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
                (  p_mesg_token_Tbl     => l_out_Mesg_Token_Tbl
                 , p_error_level        => l_error_level
                 , p_entity_index       => l_entity_index
                );

Line: 388

			EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
                (  p_mesg_token_Tbl     => l_out_Mesg_Token_Tbl
                 , p_error_level        => l_error_level
                 , p_entity_index       => l_entity_index
                );

Line: 398

             SELECT EWC.WORK_CLEARANCE_NAME into l_token_tbl(1).token_value
             FROM EAM_WORK_CLEARANCES EWC
             WHERE EWC.WORK_CLEARANCE_ID   = l_safety_assoc_rec.SOURCE_ID
             AND EWC.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 404

             SELECT WE.WIP_ENTITY_NAME into l_token_tbl(2).token_value
             FROM WIP_ENTITIES we
             WHERE we.WIP_ENTITY_ID   = l_safety_assoc_rec.TARGET_REF_ID
             AND WE.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 417

			 EAM_ERROR_MESSAGE_PVT.Translate_And_Insert_Messages
                (  p_mesg_token_Tbl     => l_out_Mesg_Token_Tbl
                 , p_error_level        => l_error_level
                 , p_entity_index       => l_entity_index
                );

Line: 444

          CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line: 468

              SELECT COUNT(*)
              INTO l_count
              FROM EAM_WORK_PERMITS
              WHERE permit_id   = l_safety_assoc_rec.source_id
              AND organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 482

              SELECT COUNT(*)
              INTO l_count
              FROM WIP_ENTITIES
              WHERE WIP_ENTITY_ID   = l_safety_assoc_rec.TARGET_REF_ID
              AND organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 506

                    SELECT COUNT(*)
                    INTO l_count
                    FROM EAM_SAFETY_ASSOCIATIONS
                    WHERE SOURCE_ID   = l_safety_assoc_rec.SOURCE_ID
                    AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
                    AND organization_id = l_safety_assoc_rec.organization_id;

Line: 591

             SELECT WP.PERMIT_NAME into l_token_tbl(1).token_value
             FROM EAM_WORK_PERMITS WP
             WHERE WP.PERMIT_ID   = l_safety_assoc_rec.SOURCE_ID
             AND WP.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 598

             SELECT WE.WIP_ENTITY_NAME into l_token_tbl(2).token_value
             FROM WIP_ENTITIES we
             WHERE we.WIP_ENTITY_ID   = l_safety_assoc_rec.TARGET_REF_ID
             AND WE.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 632

          CURSOR C IS SELECT EAM_SAFETY_ASSOCIATIONS_S.NEXTVAL FROM SYS.DUAL;

Line: 669

                    SELECT COUNT(*)
                    INTO l_count
                    FROM EAM_SAFETY_ASSOCIATIONS
                    WHERE SOURCE_ID   = l_safety_assoc_rec.SOURCE_ID
                    AND TARGET_REF_ID = l_safety_assoc_rec.TARGET_REF_ID
                    AND organization_id = l_safety_assoc_rec.organization_id;

Line: 752

             SELECT iso.ISOLATION_NAME into l_token_tbl(1).token_value
             FROM EAM_ISOLATIONS iso
             WHERE iso.isolation_id   = l_safety_assoc_rec.SOURCE_ID
             AND iso.organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 759

             SELECT csi.instance_number into l_token_tbl(2).token_value
             FROM csi_item_instances csi
             WHERE csi.instance_id   = l_safety_assoc_rec.TARGET_REF_ID
             AND csi.last_vld_organization_id = l_safety_assoc_rec.ORGANIZATION_ID;

Line: 798

          OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
          OR (p_validation_level = EAM_PROCESS_WO_PVT.G_OPR_DELETE)then

             x_return_status := FND_API.G_RET_STS_SUCCESS;