APPS.CS_SR_STATUS_PROPAGATION_PKG SQL Statements

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

Line: 32

      SELECT incident_id
        FROM CS_ESTIMATE_DETAILS
        WHERE incident_id = p_service_request_id
	  AND (charge_line_type = 'IN_PROGRESS'
            OR (charge_line_type='ACTUAL'
	        AND interface_to_oe_flag = 'Y'
	        AND order_line_id is null));

Line: 41

	  SELECT a.task_id,
                 a.source_object_id ,
	         --b.closed_flag,
                 a.open_flag,
	         --b.completed_flag,
	         a.scheduled_start_date,
	         a.scheduled_end_date,
	         a.actual_start_date,
	         a.actual_end_date,
	         c.rule
	    FROM JTF_TASKS_B a,
	         --JTF_TASK_STATUSES_B b,
	         JTF_TASK_TYPES_B c
	    WHERE a.task_type_id = c.task_type_id
	     --a.task_status_id = b.task_status_id
	      AND a.source_object_type_code = 'SR'
	      AND a.source_object_id = p_service_request_id;

Line: 187

      SELECT task.task_id,
             task.object_version_number,
             --status.closed_flag,
             task.open_flag,
             type.rule
	FROM JTF_TASKS_B task,
	     --JTF_TASK_STATUSES_B  status,
             JTF_TASK_TYPES_B type
	WHERE task.source_object_type_code = 'SR'
	  AND task.source_object_id = p_service_request_id
          AND task.task_type_id = type.task_type_id
          --AND task.task_status_id = status.task_status_id
	  --AND nvl(status.closed_flag,'N') = 'N';

Line: 203

      SELECT status.close_flag
        FROM cs_incidents_all_B sr,
             cs_incident_statuses_b status
        WHERE sr.incident_id = p_service_request_id
          AND sr.incident_status_id = status.incident_status_id
          AND status.close_flag = 'Y';

Line: 275

	          Call update_task() API to update the task status to the
                  status value held in the Service: Task Auto Close Status
                  profile option
               */

--dbms_output.put_line('Found a NFS task ');

Line: 282

                 JTF_TASKS_PUB.update_task(
	                                p_api_version => 1.0,
	                                p_init_msg_list => p_init_msg_list,
	                                p_commit => p_commit,
                                        p_object_version_number => sr_tasks.object_version_number,
                                        p_task_id => sr_tasks.task_id,
                                        p_task_status_id => l_auto_task_close_status,
                                        x_return_status => l_return_status,
                                        x_msg_count => x_msg_count,
                                        x_msg_data => x_msg_data
                                       );

Line: 294

 	         -- If update_task() API returned error, raise an exception

	         if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
	           raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line: 364

      SELECT incident_status_id
        FROM cs_incidents_all_b
        WHERE incident_id = c_request_id;

Line: 369

      SELECT incident_id
        FROM CS_ESTIMATE_DETAILS
        WHERE incident_id = p_service_request_id
	  AND (charge_line_type = 'IN_PROGRESS'
            OR (charge_line_type='ACTUAL'
	        AND interface_to_oe_flag = 'Y'
	        AND order_line_id is null));

Line: 378

	  SELECT tasks.task_id
	    FROM JTF_TASKS_B tasks
	         --JTF_TASK_STATUSES_B status
	    WHERE tasks.source_object_type_code  = 'SR'
	      AND tasks.source_object_id         = p_service_request_id
	      --AND tasks.task_status_id           = status.task_status_id
	      --AND nvl(status.closed_flag,'N')    = 'N';

Line: 388

       SELECT REPAIR_LINE_ID
         FROM csd_repairs
         WHERE incident_id = p_service_request_id;

Line: 393

       SELECT wip_entity_id
         FROM eam_wo_service_association
         WHERE service_request_id = p_service_request_id;

Line: 398

       SELECT ue.mr_header_id
         FROM ahl_unit_effectivities_app_v sr_ue,
              ahl_unit_effectivities_app_v ue,
              ahl_ue_relationships uer
         WHERE sr_ue.unit_effectivity_id = uer.ue_id
           and uer.related_ue_id = ue.unit_effectivity_id
           and sr_ue.cs_incident_id = p_service_request_id;

Line: 406

       Select object_version_number
         FROM cs_incidents_all_b
         WHERE incident_id = p_service_request_id;

Line: 414

      SELECT inc.incident_number, emp.source_id
      FROM jtf_rs_resource_extns emp ,
           cs_incidents_all_b inc
      WHERE emp.resource_id = inc.incident_owner_id
        AND inc.incident_id = p_service_request_id;

Line: 494

         CS_ServiceRequest_PVT.Update_Status
           ( p_api_version          => 2.0,
             p_init_msg_list        => p_init_msg_list,
             p_commit               => p_commit,
             p_resp_id              => l_resp_id,
             p_validation_level     => fnd_api.g_valid_level_none,
             x_return_status        => x_return_status,
             x_msg_count            => x_msg_count,
             x_msg_data             => x_msg_data,
             p_request_id           => p_service_request_id,
             p_status_id            => l_status_id,
           --  p_closed_date          => l_close_date,
             p_object_version_number => l_object_version_number,
             p_last_updated_by      => p_user_id,
             p_last_update_date     => sysdate,
             x_interaction_id       => l_interaction_id);

Line: 549

                        msg_name        =>  'CS_SR_NTFY_OWNER_UPDATE_FAILED');

Line: 553

                        aname           =>  'UPDATE_ERROR_DATA',
                        avalue          =>  l_msg_data);

Line: 559

                        aname           =>  'UPDATE_REQUEST_NUMBER',
                        avalue          =>  l_request_number);