APPS.CUG_INCIDNT_ATTR_VALS_PVT SQL Statements

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

Line: 33

       select INCIDENT_TYPE_ID, SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_B
        WHERE INCIDENT_TYPE_ID = l_incident_type_id;

Line: 44

    SELECT incident_type_id into l_incident_type_id from cs_incidents_all_b where incident_id = l_incident_id;

Line: 80

			SELECT lookup_code
			INTO	l_sr_attr_code
			FROM   FND_LOOKUPS
			WHERE  lookup_type = 'CUG_SR_TYPE_ATTRIBUTES'
			and   description  = p_sr_tbl(i).sr_question  ;

Line: 98

		select CUG_INCIDNT_ATTR_VALS_B_S.NEXTVAL
		into p_sr_tbl(i).incidnt_attr_val_id
		from dual;

Line: 103

      CUG_INCIDNT_ATTR_VALS_PKG.INSERT_ROW (
          X_ROWID => l_rowid,
	  X_INCIDNT_ATTR_VAL_ID => p_sr_tbl(i).incidnt_attr_val_id ,
  	  X_OBJECT_VERSION_NUMBER  => p_sr_tbl(i).OBJECT_VERSION_NUMBER,
	  X_INCIDENT_ID  => p_sr_tbl(i).incident_id ,
	  X_SR_ATTRIBUTE_CODE  =>l_sr_attr_code,
  	  X_OVERRIDE_ADDR_VALID_FLAG  => p_sr_tbl(i).override_addr_valid_flag,
	  X_ATTRIBUTE1 =>p_sr_tbl(i).ATTRIBUTE1,
	  X_ATTRIBUTE2 => p_sr_tbl(i).ATTRIBUTE2,
	  X_ATTRIBUTE3=> p_sr_tbl(i).ATTRIBUTE3,
	  X_ATTRIBUTE4 => p_sr_tbl(i).ATTRIBUTE4,
	  X_ATTRIBUTE5 => p_sr_tbl(i).ATTRIBUTE5,
	  X_ATTRIBUTE6 =>p_sr_tbl(i).ATTRIBUTE6,
	  X_ATTRIBUTE7 => p_sr_tbl(i).ATTRIBUTE7,
	  X_ATTRIBUTE8 => p_sr_tbl(i).ATTRIBUTE8,
	  X_ATTRIBUTE9 => p_sr_tbl(i).ATTRIBUTE9,
	  X_ATTRIBUTE10 => p_sr_tbl(i).ATTRIBUTE10,
	  X_ATTRIBUTE11 => p_sr_tbl(i).ATTRIBUTE11,
	  X_ATTRIBUTE12 => p_sr_tbl(i).ATTRIBUTE12,
	  X_ATTRIBUTE13 => p_sr_tbl(i).ATTRIBUTE13,
	  X_ATTRIBUTE14 => p_sr_tbl(i).ATTRIBUTE14,
	  X_ATTRIBUTE15 => p_sr_tbl(i).ATTRIBUTE15,
	  X_ATTRIBUTE_CATEGORY=> p_sr_tbl(i).ATTRIBUTE_CATEGORY ,
          X_SR_ATTRIBUTE_VALUE =>  p_sr_tbl(i).sr_answer   ,
	  X_CREATION_DATE =>l_current_date,
	  X_CREATED_BY => l_created_by,
	  X_LAST_UPDATE_DATE => l_current_date,
	  X_LAST_UPDATED_BY =>l_created_by,
	  X_LAST_UPDATE_LOGIN => l_login
	  );

Line: 197

	SELECT	CSI.incident_number,
		CSI.workflow_process_id,
		CSI.incident_type_id,
		CST.name,CST.workflow,
		CST.autolaunch_workflow_flag
	FROM	cs_incidents_all_b CSI, cs_incident_types_vl CST
	WHERE	CSI.incident_id = p_incident_id
	AND	CST.incident_type_id = CSI.incident_type_id
	FOR UPDATE OF workflow_process_id NOWAIT;

Line: 227

        SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;

Line: 232

          UPDATE	CS_INCIDENTS_ALL_B
          SET	workflow_process_id = l_wf_process_id,
		last_updated_by = TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
		last_update_date = sysdate
          WHERE CURRENT OF l_ServeReq_csr;

Line: 238

		UPDATE	CS_INCIDENTS_ALL_B
		SET	workflow_process_id = l_wf_process_id,
			last_update_date = sysdate
		WHERE CURRENT OF l_ServeReq_csr;

Line: 373

	Select 'Incident Address ' ||'
' || 'Address : ' || nvl(incident_address, '    ') || '
' || 'City : ' || nvl(incident_city, ' ') || '
' || 'State : ' || nvl(incident_state, ' ') ||  '
' || 'Postal Code : ' || nvl(incident_postal_code, ' ') ||  '
' || 'Country : ' || nvl(incident_country, ' ')
	into	 l_addr_notes
	From 	cs_incidents_all_b
	Where 	incident_id = l_incident_id;

Line: 410

	        p_last_update_date => sysdate,
   	        p_last_updated_by => l_created_by_user_id,
     	      	p_creation_date  => sysdate,
     	      	p_created_by => l_created_by_user_id,
     	      	p_last_update_login => l_login_id,
	        p_note_type => 'CUG_SR_ATTR_DETAILS',
		p_jtf_note_contexts_tab => l_note_context_tab_dflt
      );