APPS.EAM_REQUEST_VALIDATE_PVT SQL Statements

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

Line: 148

	    SELECT 1
	      INTO g_dummy
	      FROM mtl_parameters mp
	     WHERE mp.organization_id = p_eam_request_rec.organization_id;

Line: 153

	    SELECT nvl(hou.date_to,sysdate+1)
	      INTO l_disable_date
	      FROM hr_organization_units hou
	      WHERE organization_id =  p_eam_request_rec.organization_id;

Line: 188

	    SELECT 1
	      INTO g_dummy
	      FROM wip_eam_parameters wep, mtl_parameters mp
	     WHERE wep.organization_id = mp.organization_id
	       AND mp.eam_enabled_flag = 'Y'
	       AND wep.organization_id = p_eam_request_rec.organization_id;

Line: 219

	     SELECT 1
	       INTO g_dummy
	       FROM WIP_DISCRETE_JOBS wdj
              WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
  	            WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
  	        AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;

Line: 250

	     SELECT 1
	       INTO g_dummy
	       FROM WIP_DISCRETE_JOBS wdj
              WHERE wdj.STATUS_TYPE IN (WIP_CONSTANTS.DRAFT,WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED,
				       WIP_CONSTANTS.HOLD,WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG)
    	        AND wdj.wip_entity_id = p_eam_request_rec.wip_entity_id ;

Line: 282

	     SELECT 1
	       INTO g_dummy
	       FROM WIP_EAM_WORK_REQUESTS wewr
              WHERE wewr.work_request_id = p_eam_request_rec.request_id
	        AND WORK_REQUEST_STATUS_ID = 3 ;

Line: 314

	     SELECT 1
	       INTO g_dummy
	       FROM CS_INCIDENTS_ALL_B ciab ,CS_INCIDENT_TYPES_B citb
              WHERE ciab.status_flag='O'
	        AND ciab.MAINT_ORGANIZATION_ID  = p_eam_request_rec.ORGANIZATION_ID
		AND ciab.INCIDENT_TYPE_ID = citb.INCIDENT_TYPE_ID
		AND nvl(citb.MAINTENANCE_FLAG,'N')   = 'Y'
		AND ciab.INCIDENT_ID = p_eam_request_rec.request_id;

Line: 350

		SELECT COUNT(wip_entity_id) INTO g_dummy
		  FROM WIP_EAM_WORK_REQUESTS
		 WHERE work_request_id	 = p_eam_request_rec.request_id
		   AND organization_id  = p_eam_request_rec.organization_id;

Line: 379

		SELECT	COUNT(1)
	   	  INTO 	g_dummy
       	          FROM  EAM_WO_SERVICE_ASSOCIATION
        	 WHERE  maintenance_organization_id = p_eam_request_rec.organization_id
        	   AND 	wip_entity_id	  	    = p_eam_request_rec.wip_entity_id
	           AND  (enable_flag IS NULL OR enable_flag = 'Y');      -- Fix for 3773450